Solved

Crystal Report Cascading Parameter and Null value.

Posted on 2013-06-03
8
1,009 Views
Last Modified: 2013-06-25
I am using CR XI R2,
Can second cascading dynamic parameter be empty?

I have dynamic cascading parameter composed of Par1 and Par2.
Par1 could have option A,B,C,D  Par2 have related  values  for Par1 A ->  Par2 = 1,2.3; for Par1 B-> Par2 = 4,5,6 and on.
Why I need those parameters. I am excluding records from report that have value  from parameter Par2.

What I am doing I first pull out records that have value for Par1 e.g. A and B it populates parameter Par2 with related values: 1,2,3,4,5,6.

Now I need to select from parameter Par2 which value or values I will exclude from report.

Problem is that sometimes I want all records from Par1 and I do not want to exclude none from Par2.

But I am prompted to enter value  in Par2 as report will not run.
How to go around this,  I can not use command that Is not part of solution.
0
Comment
Question by:Taras
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
8 Comments
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 167 total points
ID: 39216426
Dynamic parameters only have the values available in the database.

You could create a new parameter that would indicate whether to include all values or use the value to exclude

The filter would be something like

{?IncludeAll} = "Y"
OR
{YourField} <> {?Par2}

mlmcc
0
 

Author Comment

by:Taras
ID: 39216868
mlmcc.
I tried it it still will no run as parameters
is on form and is not populated. Report is not running.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39216908
Can you upload the report?

mlmcc
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

 
LVL 18

Assisted Solution

by:vasto
vasto earned 333 total points
ID: 39217271
You need to select a value in the second parameter. If you are using a command as  a datasource for the dynamic parameters you can append a record for each value from the first combo box . something like
par 1          par 2
value 1       n.a.
value 2       n.a.
value 3       n.a.

You will be able to select n.a. Check in a formula if the value of the second parameter is equal to n.a. and if it is - ignore it.

Another approach is to use a viewer, which supports "real" cascading parameters, like the one shown here : http://www.r-tag.com/Pages/Preview_CascadingParameters.aspx
In the sample video a value "all" is added to each of the parameters
0
 

Author Comment

by:Taras
ID: 39217295
Sorry I can not.
It looks like while parameters seating  in report they ask for value.

If I put just {?IncludeAll} = "Y"  as filter I can run report and show all records.
However I lost paramters.

With your sugestion {?IncludeAll} = "Y"
OR
{YourField} <> {?Par2}

 I can see paramters both Par1 and Par2.

In Par1 I Have value A,B,C,D on availabel side. End If I don not select any of them and move on right side it will not enter data in Par2  that is what I want.
 
However it will not run report if you do not populate parameter Par2.
As Par2 will not be populated if Par1 is not populated it looks like somethign should be done with Par1 too. I am not sure.??
0
 

Author Comment

by:Taras
ID: 39217300
vasto I can not use command object, I mentioned it.
 if I can I know how to go around this.
I am using Cristal repot XI R2 that is crysta report version before 2008.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39217302
Yes, CR XI is v11 and CR 2008 is v12

mlmcc
0
 
LVL 18

Accepted Solution

by:
vasto earned 333 total points
ID: 39217346
Then the only other solution which I know  will work for Crystal XI is the 3rd party tool from video link. You can request a free license from here :
http://www.r-tag.com/Pages/FreeCrystalReportsViewer.aspx
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

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. …
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 …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

739 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