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?
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?