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

Posted on 2012-08-28
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
    LVL 100

    Accepted Solution

    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

    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 100

    Expert Comment

    Sorry, I have never seen such an ability.

    There are several inexpensive schedulers or you can write your own

    LVL 18

    Expert Comment

    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 rules I cannot point you to our website or to mention the name since this will be considered as an advertisement.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    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…
    I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    759 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

    10 Experts available now in Live!

    Get 1:1 Help Now