Skip to Content (Press Enter)
UserImage.jpg
Vasile Bilanici
7Views
3Comments
Create a "Print Report" button to report and print results from a querry...
Question
Hello, my name is Vasi and i would like to know how to create a report with a table obtained after a querry and also how to print it. The report must include header wich is from table fields (name of employee) and as content, the rest of the data from the table.


 Ex.:
We have a database with employee wich are distributing beer in the city. One employee covers and distributes in more that one zone. So for one employee we have let's say 10 locations with addresses and beer name.
When we search for employee (part of name) we get a table with name addres and beer.
So, the search button is working and i have the results in a table. But i need a buton like "Print report" to print a report with name as header and the rest of a the table (address, beer) as content.

Thank You very, very much.
0
0
10 Oct 2010
Copy Link
2016-04-21 20-09-55
J.
 
MVP
Hi Vasi,

Why would you need a special print-report button, Is the "print" of the browser not enough?
0
0
12 Oct 2010
Copy Link
UserImage.jpg
Vasile Bilanici
Hello Joost. Yes, the standard pritn button would be enough ...  but how can I print only the table and title without all the menus, logos, and buttons?
Thank You.
0
0
12 Oct 2010
Copy Link
2016-04-21 20-09-55
J.
 
MVP
There are multiple ways to do it ofcourse :)

Create a simple link on a page that pops up a new window with the same info, only stripped down to the bone.
(if you have the table as a webblock it would be really really easy)

or...

Use the advantage of stylesheets and the tag "media"

Great info to make a page printer-friendly: https://webdesign.about.com/cs/css/a/aa042103a.htm


0
0
12 Oct 2010
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.