How to create a loop from query to export individual crystal reports
Posted on 2011-03-03
I have a stored procedure that is quite complex and takes a date as parameter. The result set in vb.net returns fine, and a Crystal report is generated and exported to pdf. This all works,
However, I need to create seperate crystal reports for each client.
One of the fields returned by the query is clientcode.
I think the correct way to go about it is,
Create a variable for clientcode in vb.net program,
Create a function in vb.net to return the clientcodes from the previous resultset.
Then to create some kind of loop, to loop through all the "clientcodes", and to create & generate seperate pdf exports for the clientcode based crystal reports.