[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Filter Crystal Reports results by passing in a list

Posted on 2012-09-13
2
Medium Priority
?
622 Views
Last Modified: 2012-09-16
I am using asp.net and have a Crystal report which queries my Order table.  In this table the PK is the int ID.  I would like to pass the report a list of IDs to restrict the results to only orders whose IDs are in this list.   How can I do this?  I am new to Crystal I am uncertain even how to add paramters to the reports.

I also need to pass a second parameter of Status which can be either "O" for open or "C" for closed.  How can I have the report filtered by two parameters?
0
Comment
Question by:canuckconsulting
2 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 38397569
To create parameters

Right click PARAMETERS in the Field Explorer
Click NEW
Give it a Name - Status
Set the type to STRING
You can add values in the box
Click SAVE

Right click PARAMETERS in the Field Explorer
Click NEW
Give it a Name - IdList
Set type to NUMBER
In the bottom options
Set ALLOW MULTIPLE VALUES to TRUE

To use them
Click REPORT --> SELECT EXPERT --> RECORD SELECTION
{IdField} IN {?IdList}
AND
{StatusField} = {?Status}

mlmcc
0
 

Author Closing Comment

by:canuckconsulting
ID: 38403207
Thanks!  I ended up passing the rpt populate datasets so did not need to pass the parameters as I controlled using raw data.  Keeping this for next time though!
0

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

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
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 …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month17 days, 16 hours left to enroll

830 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