Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Static/Cascading Prompts? Post Reply Post New Topic
Author Message
avaj
Newbie
Newbie


Joined: 26 Sep 2007
Online Status: Offline
Posts: 30
Quote avaj Replybullet Topic: Static/Cascading Prompts?
    Posted: 03 Oct 2007 at 7:09am

CR XI - Can I create a cascading prompt off of a static prompt?  What I want to do is this:

Prompt - Grand Totals Only? (Y or N)
                If Y - Prompt - (By Type or All Types)
 
So if they answer Y to my first Prompt, I want to ask the second prompt 
 
Is this possible?  I can only get the cascading part to work if I use a table field for the first prompt.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 04 Oct 2007 at 11:33pm
No, you can't do this. As you discovered, DCPs require tables.

However, Tutorial 4-7 in my new book covers a trick for doing this. You can simulate static prompts by using a Command Object and using creative SQL. I would use a SELECT statement that pulls all the data you need and add a string column that has 'Y' hardcoded with it. Then use the UNION to add a record with 'N' hardcoded in it and just have the key field be "ALL" or something. That way, when 'Y' is selected, it will show all the records. When 'N' is selected it will just say 'ALL" and they can click on that.

I have lots more tricks about DCPs in that tutorial as well that you'll probably find helpful.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
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.016 seconds.