How to Create a FROM and TO Date Prompts

[v2k4u]

Hi I need some help with creating FROM and TO date prompts for the users to select the dates based on a Report_Date parameter.

[Lynn]

At what point are you getting stuck?

Sounds to me like you need two parameters such as DateFrom and DateTo. You could use a calendar prompt control for each.

Then set the filter in your query something like [YourQueryItemDate] between ?DateFrom? and ?DateTo?

[v2k4u]

How can we display them in a single page and do the DateFrom and DateTo parameters need to be created based on a Report_date data item that we already have?

Pardon my questions if they sound silly as i am new in designing these kind of propmpts....

[BigChris]

Hi,

You can create a new prompt page (go to the Pages navigator and drag in a prompt page). On there you can drop two date prompts, and call them BeginDate and EndDate respectively. In your query you'd then create a filter which would look something like [Report_Date] between ?BeginDate? and ?EndDate?

[Lynn]

Take a look at chapter 12 of the Report Studio User Guide. The advice given so far is assuming you have a relational package. Dimensional is another kettle of fish entirely.

[v2k4u]

Thanks Chirs and Lynn on your suggestions, it helped me a lot and chris i was able to incorporate the prompt page with the date prompts as you have suggested and it works fine for me.... :)

[willg]

This can also be achieved with a single prompt, if, in the prompt's properties the Range is set to 'Yes' and Multi-select to 'No'.

[harishikon]

Yoy could use in_range function .


[Date] in_range ?Date?

Thank you