Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
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>
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