Solved

How to create a loop from query to export individual crystal reports

Posted on 2011-03-03
3
1,186 Views
Last Modified: 2012-05-11
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.

0
Comment
Question by:Lalla Belle
  • 2
3 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 35033463
That makes sense.

There are third-party tools that can do it for you.
In particular Visual Cut
http://www.milletsoftware.com/Visual_CUT.htm

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35275386
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.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now