Crystal Reports Multi Records selection

Posted on 2012-08-31
Last Modified: 2012-09-05
Hi. I have a report that is run that has over 25 different client names that have to be selected. So I have created a parameter field called client name and inserted the clients that should be selected. I then create report>select expert> record, and is equal to and my parameter.  When I run the report it works as expected showing me the clients I select all and then run the report. What I want to do for the report not to ask me to select the clients I want this hard coded as such so the report runs using the parameter I have all ready created without asking me to select the clients. I presume that is possible, I just not sure how

Many Thanks
Question by:George_Milton
    LVL 26

    Accepted Solution

    The entire purpose of a parameter is to prompt you for values at run time.  If you don't want to be prompted, then you'll need to hard code the values into the record selection criteria.  Since you're already using the Record Select Expert, instead of choosing a parameter, look up actual database values for the underlying field. You'll also have to change the criteria from 'equal to' to 'is one of'.
    LVL 100

    Assisted Solution

    If you prefer to type the values yourself you can use
    {YourField} IN ['Client1', 'Client2']

    Is there another field that could identify the 25 clients you want?

    Can you create a view in the database?
    If so you could create a view that selects the clients then use it as an inner join to the table.


    Author Closing Comment

    Thanks, both great help

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    746 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

    18 Experts available now in Live!

    Get 1:1 Help Now