Solved

Crystal Report Cascading Parameter and Null value.

Posted on 2013-06-03
8
1,013 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 101

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 101

Expert Comment

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

mlmcc
0
Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

 
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 101

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

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…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

623 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