Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Cascading prompt ?? Post Reply Post New Topic
Page  of 2 Next >>
Author Message
flazaro28
Newbie
Newbie


Joined: 30 Apr 2009
Location: Poland
Online Status: Offline
Posts: 35
Quote flazaro28 Replybullet Topic: Cascading prompt ??
    Posted: 11 Jun 2010 at 11:49am
I have created Dynamic Cascaded  prompt display in the Business view Manager.
 
FOr example:
 
Deleted is the Top prompt (values --> *ALL/Deleted/Not deleted)
Program is its child   prompt
   Rotation is its sub-Child  prompt to program
 
Based on my selection *ALL or Deleted or Not-Deleted, it would populated the LOV's in my report.
 
Now , how can I write a formula in record selection box in crystal report, such that when I select appropriate LOV's it would display the corresponding data?
 
 
I used this formula, but its not working
 
 
 
 
If {?Program} = ' *ALL' then true
else if {?Rotation} = ' *ALL' then true
else if {?Deletion} = ' *ALL'  then

{Command.PROGRAMTITLE} = {?Program}
else ( {Command.PROGRAMTITLE} = {?Program}
 
and  {Command.ROTATIONTITLE} = {?Rotation} )
     


Edited by flazaro28 - 11 Jun 2010 at 11:50am
IP IP Logged
flazaro28
Newbie
Newbie


Joined: 30 Apr 2009
Location: Poland
Online Status: Offline
Posts: 35
Quote flazaro28 Replybullet Posted: 14 Jun 2010 at 4:35am
Can anyone help me out?
IP IP Logged
flazaro28
Newbie
Newbie


Joined: 30 Apr 2009
Location: Poland
Online Status: Offline
Posts: 35
Quote flazaro28 Replybullet Posted: 15 Jun 2010 at 9:24am
Can someone help me out?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 15 Jun 2010 at 9:45am
Sorry, As far as I know you will not be able to do this.
Cascading priompts require the data to exist before the report is generated so your formula will not help.
Selecting a value of ALL (assuming it actually existing in your DB values) will likely make your lower level LOVS null as their is no related fields for ALL.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 15 Jun 2010 at 9:46am
You can use ALL options in your select statement but not in cascading params.
IP IP Logged
flazaro28
Newbie
Newbie


Joined: 30 Apr 2009
Location: Poland
Online Status: Offline
Posts: 35
Quote flazaro28 Replybullet Posted: 15 Jun 2010 at 10:42am
Originally posted by DBlank

You can use ALL options in your select statement but not in cascading params.
 
 
Thanks DBLANK...Is there any other way we can implement CASCADING "ALL" ?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 15 Jun 2010 at 10:46am
What exactly do you want your report to do for your end users?
IP IP Logged
flazaro28
Newbie
Newbie


Joined: 30 Apr 2009
Location: Poland
Online Status: Offline
Posts: 35
Quote flazaro28 Replybullet Posted: 15 Jun 2010 at 10:51am
Originally posted by DBlank

What exactly do you want your report to do for your end users?
 
Here is the scenario:
 
Master prompt 1 --> "DELETION_STATUS" has the following Static values
  ALL
  Deleted
  Not-Deleted
 
When users select ALL, it populates the LOV's in its child parameter "program"
eg: ALL,prog1,prog2,prog3,prog4,prog5
 
 
Now, When users select any LOV's listed in Program parameter, it populates the LOV"s in its child parameter "ROTATION"
eg: ALL,Rot1,ROt2,ROt3,ROt4,Rot5,ROt6,ROt7,Rot8,Rot9.
 
 
 
The report should filter the data based on the user selection on the Parameter screen.
 
 
 
 
 
 


Edited by flazaro28 - 15 Jun 2010 at 10:53am
IP IP Logged
flazaro28
Newbie
Newbie


Joined: 30 Apr 2009
Location: Poland
Online Status: Offline
Posts: 35
Quote flazaro28 Replybullet Posted: 15 Jun 2010 at 10:53am
I have already written command SQL in my Union statement.
 
Now, I want to use some sort of  record selection formula to filter the data.
 
I can't get the formula to work correctly
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 15 Jun 2010 at 11:23am
The record selection is pretty easy using actual cascading prompts is not in this case. If you just use regular params (not a cascading one) it would be easy fairly straight foreward.
Her is what your select statement would look like:
({?Deletion status}='All' or {?Deletion status}={table.deletion_status})
and
({?program}='All' or {?program}={table.Programfield})
and
({?Rotation}='All' or {?Rotation}={table.Rotationfield})
 
IP IP Logged
Page  of 2 Next >>
Post Reply Post New Topic
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



This page was generated in 0.030 seconds.