Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: CAscading paramters 2nd level in record choice? Post Reply Post New Topic
Author Message
jbalbo
Senior Member
Senior Member
Avatar

Joined: 17 Feb 2011
Online Status: Offline
Posts: 219
Quote jbalbo Replybullet Topic: CAscading paramters 2nd level in record choice?
     Posted: 01 Oct 2012 at 9:07am
HI,

I figured out how to do  cascading parameter..FINNALY!!!..lol

But how do I use the levels in my record choice?
Example :
I have a parameter : Center, with Level 1 = Program and Level 2 = Unit.

Unit allows multi select...

Now that I write it down, can I assume it chooses from the last level, since level one choice allows what is seen on level 2 etccc  ???


Thx


 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 01 Oct 2012 at 10:20am
Not sure I understand your question...?
Do you mean how does the report choose what to filter on?
The param has no impact on the select statement unless you manually add it.


Edited by DBlank - 01 Oct 2012 at 10:24am
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 01 Oct 2012 at 10:23am
If you select Program, the unit list should be filtered by program - IF you've correctly set up the query behind the cascading prompt.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
jbalbo
Senior Member
Senior Member
Avatar

Joined: 17 Feb 2011
Online Status: Offline
Posts: 219
Quote jbalbo Replybullet Posted: 01 Oct 2012 at 11:11am
Yes, thank u...

The program is filter by the unit thus on needing to select on unit

Sorry, its my first cascading parameter..:)
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 01 Oct 2012 at 11:14am
so you want to know how to filter the data set by the param?
just add it into the select statement.
{table.field} = {?param}
 
If you mean something else please clarify.
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.