I have an orderreport page where it lists all of the orders that have been placed, on each individual order i can click and it brings up a page where it shows the order items shipping info and such. I can print on each of those pages, Is there a way to say pring ordernumbers 1 2 and 3 or to say print all with a certain status.
View Replieshow to do multiple pinting in asp.What i mean is,if i use a loop to populate a page and print,then if i went to the next record and populate,i would like it to print that and the next and so on.
The looping bit is fine.The only problem is the printing.If i use the print html code, it brings up the common dialog box and the user has to click on print.Is there a way to get round this and just print without the dialog box?
I need solutions/ideas for this problem. We have an ASP e-commerce site.
Whenever we need to print orders, instead of printing each order we would like to print everything in one go. Any possible solutions?
One thing I implemented was - displaying all "open" orders in one page with css page-break-after after each order. But I have a problem - since the invoice has been formatted with tables - all invoices do not start at the top of the page. Further, if an invoice is too long - the second page starts printing at the middle or bottom of the page.
BTW, Page-break-after or before or both does not make a difference.
I have a small team who are building e commerce sites for different clients .One of our client wants his customer orders to be faxed directly to him.
View Replies View RelatedI have a site where orders are placed, i was just thinking of a good way for customers to keep track of there orders, at the moment they can page through there orders and and find it manually, I was thinking of putting a seach in also. Another one was to export all there orders in to an excel file, and one think thats any good?
View Replies View RelatedI'm trying to pull a listing of customers for which no orders appear in the order table.
table names are "customers" and "orders"
both tables contain a column named "idCustomer"
I thought performing a subquery that would sum up the total of order numbers would give me a means by which I could determine this, but I'm still getting incorrect results.
select customers.idcustomer,customers.customercompany, Orders.idorder,Orders.idcustomer,orders.orderDate from customers inner join orders on customers.idcustomer = orders.idcustomer where customers.idcustomer in(select count(idorder) as totalorders from orders where orders.idcustomer = customers.idcustomer and totalorders = 0)
I'm creating an online shop which has an area showing the top ten best selling products. I'd like to generate the list of the best selling products from my OrdersDetail table (which is table showing listing purchases made on the site), ordered by the most popular at the top and the least popular at the bottom.
I thought if I could use the SQL DISTINCT command this would create a list of products without duplicates, then if I could COUNT them I'd generate a list of the most popular products in the OrdersDetails table. This nearly works but the list won't ORDER BY the COUNT column (I get an error). This is my code so far:
SELECT DISTINCT ProductDescription, COUNT(ProductDescription) AS bestSellers
FROM OrdersDetail
GROUP BY ProductDescription
I am reaching the point in the implementation of my first shopping cart where I need to place all the customer’s products within their shopping basket into an orders table.
I am sure many of you have performed this task before so I wondered if you wouldn’t mind pointing me in the right direction. I am not really sure exactly what is usually stored within the orders table in most shopping carts. My shopping cart contents is stored in a session array like this Code:
Is there a way I can put a print button on my asp that will actually print the current Screen opened. My asp has an access backend.On my asp page can I have a button that can actually print a report from the Acesss Database.
View Replies View RelatedIs there a way I can put a print button on my asp that will actually print the current Screen opened. My asp has an access backend.On my asp page can I have a button that can actually print a report from the Acesss Database.ie a button that will go the report section of access DB and print teh report that I want a way to get around with the appropriate codes will be appreciated as I am new to asp programming.
View Replies View RelatedJust as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
need to print a document like a invoice. Does it take client side only?
View Replies View RelatedI have written a report in ASP that comes up in .pdf format. It is exactly what I want except I can't control page breaking. The report lines roll over automatically thus I don't have a report title header. Is there a way in ASP to perform that task? I have also read about using .css for this, but can't seem to find a good example.
View Replies View RelatedIs it possible to send a file directly to printer in ASP?
I have an ASP page display the list of files associated with the record with
hyperlinks to the files. I want to provide a link next to each file to allow
people to click the button and send the appriopriate file to the printer.
Is it possible to do this in ASP or ASP.Net?
Just wondering if it is possible to make an asp page shrink to fix all the data on a page?
View Replies View RelatedI need to take the report of Ledger of all the customers. I want each customer Ledger to be printed on different page with same page headers and page footers. Only the the Name of the customer and his ledger information would be changed.
One cutomer's Ledger can go for more than one page, In that case it must print the data on the same number of pages and start the next customer page after this customer's ledger finishes.
Infact I am looking for complete reporting system as we can make in Crystal Reports with Classic Visual Studio or .net.Hope someone can help with dumy Sourcecode. Infact I need to know how I'll format in HTML. ASP and Database queries are easy to run.
I have big problem in printing.. I am getting 20 colums of information from my database.
in asp, the width of the page is long. The problem now iam facing is printing, its only printing those information which are visible and the rest on the right side of the browser is not printing..I really dont know what to do.
I have an asp page that displays a recordset from a table in paginated format with header values on each page from another table in the database. To print, one needs to click the print button and a new page properly formatted pops up and opens the print manager in windows.
One must do this for each page. If I have 300 pages that's a lot of work for the end-user.Attached is the code I'm using to print.Does anyone see how I could make it utomatically print ALL the pages, rather than one at a time?
What I want to do is spit recordset variables from the database and place them on a page so they can be printed. The problem I am running into is that it cuts off part of
the printed page. Does anyone know of a way to clean produce a page to be printed even if there is multiple pages so that it does not cut off text?
I'm in the middle of a project using ASP pages that access an Access database. I'd like to know how I can print a page without IE putting the Page X of X at the top and the address/ date at the bottom of the page.
View Replies View RelatedCould you anyone tell me how to print PDF from my ASP page.
View Replies View RelatedI am using a simple printer friendly page the opens up as
a new window. I use a DIV TAG called "printReady" in the section I want
to print (Printer friendly) then in a javascript function
I do this:
var printFriendly = document.getElementById("printReady")
var strHTML = printFriendly.innerHTML
I then open a new window with the Javascript and write the
HTML (mostly Text) to the new window.
var printWin = window.open("","printSpecial");
printWin.document.open();
printWin.document.write(html);
printWin.document.close();
This works fine, but if the page is to wide using
Landscape is fine, but in portrait mode it only prints one
page the cut off part is not printed on the second page.
Some times the page will print but the text is missing.
Only the table outlines print.
Any one experience this before or have any suggestions if
this can be overcome.
I have some code to print a web page through javascript. Does anyone know if I can set the Orientation to be Landscape through Javascript?
View Replies View RelatedDoes anyone knows how to print images to a pringter connected on the Web Server (IIS) Machine using ASP?
View Replies View Relatedi gave a print option for a html page. but that is printing the url which i doesnot want.
also is there a way that when user prints it should also display page numbers. How to get rid of the URL while printing.
I have a asp page that has a print button. After the page is printed it refreshes the page and give me an error saying that parameter @TRN_CODE has no default value.
What I don't understand is why I don't get that error the first time the page loads. It has no default value then either. It always get that parameter from the request.querystring.... anyone have any ideas? Code:
Is there a way to prevent the user from printing a page? I have a form that I would like to make it impossible or very difficult to print out.
View Replies View RelatedI am trying to create a popup page to print little cards to Avery labels. I can get the page to work out but it always prints the margins to far over so it doesn't fit in the cells. I was wondering if any one new any resources to give details on how to accomplish this or of another method?I have also tried creating a dynamic word doc but then the user could change the text values which wouldn't work.
View Replies View RelatedIN Windows 98 below script was running fine
<SCRIPT ID=clientEventHandlersVB LANGUAGE=vbscript>
<!--
function button1_onclick()
Const ForReading = 1, ForWriting = 2, ForAppending = 8
Dim fso, f,a
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.OpenTextFile("c: estfile.txt", ForWriting, True)
f.Write txtout.value & vbcrlf
f.Close
Set a = fso.GetFile("c: estfile.txt")
a.Copy ("c:lpt1:")
'msgbox("helo")
end function
-->
</SCRIPT>
but after installing XP giving error ACTIVEX OBJECT CANT CREATE OBJECT.
I know this topic has been flagged to death in this forum and there is always a limited response, but here goes.
I wish to format a html page (which is to be printed) programmatically using asp/javascript/css....whatever. I particularly want to set page layout to landscape and suppress the header and footer crap that IE adds to each and every print out. Now i can basically get page layout to go to landscape by creating a css file and having the following code:
<style type="text/css" media="print">
@page { size: landscape
</style>
However, no matter what i do i cant get rid of the header and footer IE puts on every page. There is a third party app from meadco scripting that permits users to do this but you have to install on each and every client that is going to be printing !! Which we dont want......so if they can do it, it must be able to be done !! But has anyone any inkling on how to do it?
I have an SQL statement which outputs the following data:
A: RS("SelectorName")
B: RS("SelectorQty")
C: RS("ShipQty")
For each record printed, I need to calculate (B * C), this is easy
enough.
I set up a variable as follows: TMW = RS("SelectorQty") * RS("ShipQty")
The page currently prints as follows:-
96 50
96 100
96 100
96 100
(96 = SelectorName, 50 & 100 = TMW)
<I want to print here : 96 = 350
97 12
97 18
97 53
97 67
<I want to print here : 97 = 150
..... and so on.
Can anyone help me do this ? or explain how to do this.
****** >>>>Eventually, I just need a page that prints out:
i.e. running through each Selector and printing the sum.
96 = 350
97 = 150
and so on ....... I just though I ought to explain in stages.