Solved

Crystal Report Cascading Parameter and Null value.

Posted on 2013-06-03
8
1,004 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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

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…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

762 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