Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need advice for data access using CR in a .NET web app

Status
Not open for further replies.

hapax

Programmer
Nov 10, 2006
105
US
I'm creating a Crystal Report to generate monthly customer invoices. I'm wondering the best way to do the data access.
I'm using the Crystal Report inside a web app created using Visual Studio. I have already created code to re-run the report again for each customer ID to create the invoice for that customer in PDF form.

My idea is to first get the customer ID in my web app, then pass it to the report as a parameter. Then each section of the report will use the customer ID to perform a separate query to get the data for that section of the report.
Is this a good method?

I assume it would be best to create stored procedures for each section of the report?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top