Solved

Crystal Report Cascading Parameter and Null value.

Posted on 2013-06-03
8
992 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
  • 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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 …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

895 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

19 Experts available now in Live!

Get 1:1 Help Now