• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1218
  • Last Modified:

How to create a loop from query to export individual 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.

Lalla Belle
Lalla Belle
  • 2
1 Solution
That makes sense.

There are third-party tools that can do it for you.
In particular Visual Cut

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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now