Hi everyone.
I am trying to create a report where the user filters the report based on a date range. Therefore, I am creating two new parameters - "Start date" and "End date".
Setting up the parameter works fine except one minor detail, the "Value type" must be set to "Datetime". However, because of this, the parameter requires an entry for both the date and the time (and I only want them to select a date). If "Value type" is set to "Date", the table does not appear in the "Browse table" drop down list. If I choose "Date" anyway and then type in the table, the parameters will not show up in the Select Expert dialog.
What's weird is that I look at some of the old reports created by the person I replaced. In these reports, the "Value type" is set to "Date", and when I use the Select Expert, the parameters show up. I try and reproduce this exactly and I am unable to get it to work without forcing the users to type in the time. Argh.
It's obviously possible to set up the parameters to only look at the date (and not the time), but I just can't quite figure it out. Any ideas on what I'm missing? Any ideas are appreciated.
Thanks!
I am trying to create a report where the user filters the report based on a date range. Therefore, I am creating two new parameters - "Start date" and "End date".
Setting up the parameter works fine except one minor detail, the "Value type" must be set to "Datetime". However, because of this, the parameter requires an entry for both the date and the time (and I only want them to select a date). If "Value type" is set to "Date", the table does not appear in the "Browse table" drop down list. If I choose "Date" anyway and then type in the table, the parameters will not show up in the Select Expert dialog.
What's weird is that I look at some of the old reports created by the person I replaced. In these reports, the "Value type" is set to "Date", and when I use the Select Expert, the parameters show up. I try and reproduce this exactly and I am unable to get it to work without forcing the users to type in the time. Argh.
It's obviously possible to set up the parameters to only look at the date (and not the time), but I just can't quite figure it out. Any ideas on what I'm missing? Any ideas are appreciated.
Thanks!