Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 426
  • Last Modified:

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.
0
SasDev
Asked:
SasDev
  • 3
  • 3
  • 2
1 Solution
 
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
 
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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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
 
musalmanERP 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
 
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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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