on 01-28-2009 8:21 AM
Hi
Is it possible to have a default for report parameter that depending on the date.
For instance our customers need now to enter a Begin and Start date to display their data for a particular range.
Wish: When the parameter screen pops up the Start date and the End date are already filled in by default. In the start parameter i want the monday of 1st week of the year. In the end parameter i want the friday of the current week.
Is this possible? Need the date range parameter be of type date, or is String also allowed?
Thanks in advance
Auke Quist.
Hi Auke,
To give parameter default values, we will have two methods, this is either enter values directly or pickup the values from a database field. As per your requirement, we can't define default values to start and end paramenters.
If you are using CR2008 then you have an optional parameter option, using this option we can check with Hasvalue() function whether the user entered values or not.
In your case we can write a formula if Hasvalues(ParameterValues) is empty then assign first week of the year to start and last week friday to end parameters in recored selection and filter the data.
Please note that att any point of time you can't assign formula results to your parameter default values.
Thanks,
Sastry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.