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


Manually Open Multiple Crystal Reports and Use Same Parameters by Entering Once

Posted on 2012-08-28
Medium Priority
Last Modified: 2012-08-28

Does anyone know if it possible to manually open a bunch of Crystal Reports .rpt files and only enter the parameters once to be used for all reports?  I find a need to open reports that all use the same parameters and it is time consuming to manually enter the same parameters in each individual report.  It would be great if I can enter the parameters in one report and have the other reports use the same parameters.  Not sure if that is a feature or if it needs to be done programatically.  I'm looking only for the manual process, not to be done programically.  Thanks.
Question by:craigbtg
  • 2
LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 38340934
The only way I can think to do that would be to embed the reports into a master report that accepts the parameters and links them to the reports.

That works only if the reports do not already have subreports.

The other ways to do it require an application written to handle the reports.
What is your objection to an application or a report scheduler?


Author Comment

ID: 38340992
OK, thanks.  No objetion to an application, was just wondering if there is a nice quick way to do it without needing to write anything special.  I was hoping there would be an option such as "check off this box and it will do what you need".  Wishful thinking!
LVL 101

Expert Comment

ID: 38341354
Sorry, I have never seen such an ability.

There are several inexpensive schedulers or you can write your own


LVL 18

Expert Comment

ID: 38342528
My company provides an inexpensive report viewer that can do that. Basically you can define a group of reports and set the parameters on the group level. You can set the parameters' values manually or calculate them on the fly using C# or formulas similar to crystal reports formulas. You can schedule the group or run it manually. There is also a workflow which will allow you to not run some reports depending on some conditions (for ex. if parameter A=1 run report 1,2 and 3, if parameter A=2 the run reports 1, 3 and 4). You will be able to process report results separately or  to combine them in one pdf or excel file. Results can be delivered by e-mail, to SharePoint or Document management, local network ..

The viewer is listed on Ken Hamady's website site. By experts-exchange.com rules I cannot point you to our website or to mention the name since this will be considered as an advertisement.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

571 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