Solved

Crystal Report Cascading Parameter and Null value.

Posted on 2013-06-03
8
999 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

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. …
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…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

803 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