Open Multiple Crystal Reports

Hello,

I have an aspx page which opens an application form in crystal report when the page loads. I'm using vb code to load the report, provide DB credentials, and reports parameters - this works great.

I now want to open multiple application forms onload using the same Crystal Report Viewer. I'm sure this can be achieved but have no idea how.

I'd appreciate any help.

Thanks.
LVL 1
SasDevAsked:
Who is Participating?
 
musalmanConnect With a Mentor ERP ConsultantCommented:
see - you can send Comma separated ID e.g.  1,2,3,4,5
Then you can split these ID's at Stored procedure level and then iterate thse ID's.
Finally return the results and then on the report, Make  Group by on these ID ...
Also, use Next Page  After option to put all ID details in separate pages.
0
 
mlmccCommented:
If you mean simultaneously so you can tab between them then the answer is no.  A viewer can have a single report source.

You can have multiple viewers in an application and open several reports that way.

mlmcc
0
 
SasDevAuthor Commented:
If I were to use multiple viewers, how is that achieved? I'd want to pass application ID's (1,2,3,4,5) or ID's (1,3,8,26,130) to CR; view them in a window and print them with a single click.
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
mlmccCommented:
What do you mean application IDs?

Multiple viewers will either be on a single form or on multiple forms.
Each would have code to load as you do now.

mlmcc
0
 
musalmanERP ConsultantCommented:
It seems that there is no such a need of multiple viewers.
You can design your Report in  way that will generate One single report and generate Multiple pages for multiple forms by getting Application ID's as Input.

Lets say , You will create a Simple report of Order Details pattern where you will pass Order ID and report will show Order ID and their details Page wise. (One Order Detail / Per Page)

Then you can print them on a single click.
0
 
SasDevAuthor Commented:
Thanks for your reply!

You can design your Report in  way that will generate One single report and generate Multiple pages for multiple forms by getting Application ID's as Input.

How can I achieved this? My report can only accept a single parameter at a time. I don't know how to pass multiple parameters from my .Net page and collect them in CR.

I'd appreciate any examples too.

Thanks much.
0
 
SasDevAuthor Commented:
Thanks again for your comment.

I implemented kind of similar thought in achieving the goal. On my ASP.Net onclick event I'm calling CR which gets all the required parameters from a SP on load. And I have this SP configured to return the required ID's.

So, it's similar to what you're suggesting but a little different :)

Thanks much.
0
 
musalmanERP ConsultantCommented:
Glad to help you !
Always try to think in all possible ways...Not stick with one idea :)
0
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.

All Courses

From novice to tech pro — start learning today.