Im working on one report , here i need to have three prompts
prompt1 : Program A
Prompt2 : Program B
Prompt3 : Custom Date
When i run that report it has to display the prompt with the above three
values in it.
When i click on the Program A , it has to display the Program A period (i.e 4/1/2005 to 4/20/2005)
When i click on the program B , it has to display the Program B period(i.e 5/1/2005 to 5/20/2005)
When i click on the Custom Dateā¦ it has to prompt me to enter start date and end date.
I was able to get the first two by adding an object in Universeā¦ but i donāt know how to get the third one (custom date)
You can use the following formula to get the custom date if thatās what you are looking forā¦
Tablename.Objectname BETWEEN @variable(ā3. Enter Start Date as āāmm/dd/yyyyāāā) AND @variable(ā4. Enter End Date as āāmm/dd/yyyyāāā)
NOTE: When you Type in prompts with BETWEEN operator it will show up as @variable in SQL.
Looks like you are not clear... let me put it this way
The first two prompts should be predefinedā¦ i donāt need to enter any valuesā¦ if i select āProgram Aā then it should display the specified range
and same with āProgram Bā too.
If iam not intrested in the above two ā¦ then i have to select āCustom Dateāā¦ there it should ask me to enter āStart Dateā and āEnd dateā
I already created first two prompts wtih CASE in Designer but i was not able to create the third oneā¦since when i click on the thirdā¦again it should promt to enter āstart dateā and āend dateā