Formatting Dynamic Prompt Value List

[rancidtuna]

Hello all,

I'm using Crystal XI on a Pervasive SQL V8 database. I have a report that uses dynamic prompts. The first field that I need to select is a date field, which I want to be decending by value. All of this is no problem. The problem occurs when the list of values is displayed. There are so many dates in the database that it cuts off the list halfway through 2004. I need to be able to access dates in the current year for my report. Is there a way to filter the dynamic list that Crystal generates? Does anyone else have any ideas? Thanks in advance for the help!


-e

 

[lbass]

You could create a command that returns only those dates in the current year. You would then select the field from the command to use for the list of values. You do not need to link the command to other tables.

-LB

 

[rancidtuna]

how do i embed that command into the dynamic prompt group? i ask first for the ship date. (this is where i'm having the problem.) then, you can choose which customer's shipment you're looking for on that day. lastly, you can then choose which shipment that left for that customer on the specified day and it will give you the details of that shipment. how would i link this command to the prompt group?

-e

 

[rancidtuna]

nevermind, i've got it. works great. thanks LB!

-e