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.
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?
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....
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?
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.
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.... :)
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'.
Yoy could use in_range function .
[Date] in_range ?Date?
Thank you