How to set a VS2010 Crystal Reports multi value to show all programmatically

Question

5.00/5 (1 vote)

See more:

VS2010

, +

Hi,

I am trying to learn how to use Crystal Reports and I have set up a parameter in my report to allow multiple values. This works well except that it prompts the user to enter a value or values when I run the report. What I would really like is for the default action to be all values are displayed with no user prompt. If he wants to filter to a subset then he can. I have searched but can not seem to find how to do this anywhere.

Thanks in advance for any advice,

Preston

Surely there is a way to programatically set the value of the multi-parameter to all?

Posted 9-Nov-11 10:20am

Preston Phillips

Updated 10-Nov-11 3:59am

v2

Add a Solution

2 solutions

Solution 1

With Crystal Report, you can pass the parameter via code (bypassing the Crystal Report UI to input parameters). This looks to be what you are trying to accomplish:

VS 2010 - Passing Parameter Programatically to Crystal reports[^]

The other option would be to create your own UI and then pass the selected values to the report using either a selection formula or parameters.

Posted 10-Nov-11 18:20pm

Pete _BSC

Updated 10-Nov-11 18:21pm

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Preston Phillips · Accepted Answer · 2011-11-11T06:11:00

After a lot more digging and experimentation I found the pieces of the puzzle I needed to make the report behave like I wanted. Here are the key pieces. To set the parameter value programatically you do the following.

rpt.SetParameterValue("parm", "*");

Then in the Crystal Reports menu select Report->Selection Formula->Saved Data...
add the following formula

VB

if HasValue({?parm}) Then
    if {?parm} = "*" Then
        True
    else
        {?parm} = {Table.FieldEquatedToParm}
else
    True

This will allow the report to come and display all the values without prompting the user to enter a value. Then if the user decides they want to filter the report they can use the parameter panel to choose a filter value. The formula get kind of nasty if increase the number of filterable columns though.