Solved

Open Multiple Crystal Reports

Posted on 2011-09-30
8
416 Views
Last Modified: 2012-06-27
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.
0
Comment
Question by:SasDev
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
8 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 36894606
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
 
LVL 1

Author Comment

by:SasDev
ID: 36894731
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 36894764
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
[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

 
LVL 4

Expert Comment

by:musalman
ID: 36896094
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
 
LVL 1

Author Comment

by:SasDev
ID: 36903002
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
 
LVL 4

Accepted Solution

by:
musalman earned 500 total points
ID: 36904219
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
 
LVL 1

Author Comment

by:SasDev
ID: 36904591
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
 
LVL 4

Expert Comment

by:musalman
ID: 36906108
Glad to help you !
Always try to think in all possible ways...Not stick with one idea :)
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

726 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