Solved

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

Posted on 2011-03-03
3
1,188 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

910 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

21 Experts available now in Live!

Get 1:1 Help Now