0

i had made project on vb.net i have added snap shot of my project.I had created access database now i want to take date as input from the user & from that day i want to print all records & their total for each column. I had already created a from accepting the date.
Is there is need to create template or any thing please give the brief idea about this and some code also
thank you

Attachments 2.png 30.72 KB app1.png 16.37 KB
2
Contributors
1
Reply
3
Views
5 Years
Discussion Span
Last Post by Phasma
0

From your question I take it you just want to print the recordset from your access query. There are many ways to do what you want. As I dislike playing with VS2008's reportviewer and for simple applications I feel the crystal reports is overkill.

I use the following:
1.Create a stored procedure/query that takes your Date parameter
2.Fill a dataset with the results
3.Write the results to xml file
4.Import the xml into an EXCEL spreadsheet
5.Print the spreadsheet

You can create your own class with excel, pass the dataset to it, and format it the way you want. This will skip the xml step. Printing the spreadsheet makes a very nice output.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.