Lalla Belle
asked on
How to create a loop from query to export individual crystal reports
Hi,
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.