Query on Date Prompt

[sg24]

Hi All,

I have two date prompts . One for the Start date and another for the end date.

Start date always show up the current date Jan 27 2011 in my prompt page when i run the report.
But, End date also shows up the current date...

my filter in the report is [Columnname]<=?ENDDATE?

My requirement is i need 31 Dec 2010 to be shown instead of Jan 27 2011 in the date prompt when i run the report.

Please share yr thoughts.

Thanks,
Sg

[Joe Gilvary]

You can force the value to be whatever you like on the prompt page with the Date Prompt's Default Selections property. Is that what you need?

[sg24]

Yes, i applied the same for the time being as the requirement was to show the default value.

Thank you very much for yr response ..   :)

Thanks,
Shilpa

[charlie]

Extract the year from the start date, add 31-Dec to it and show. You wont have to make any changes in the report as the year changes then :)

Cheers
Charlie

[sg24]

Hi ,
Thank you for yr response.
I do not have any query associated with the Date prompt in my report. I have just pulled a date prompt and clicked the finish button. In such a scenario, how would it be possible to achieve ? Please let me know yr thoughts.

Thank u very much.

Thanks,
Sg

[charlie]

then why not use the start date parameter for the deriving the end date result. is this what you are looking for?

Cheers
Charlie

[sg24]

The start date parameter also is not assoiciated with any query ; so when we drag the date prompt , and run the report, we can see the current date in that prompt. Hence for the end date also, it was showing the same. So i have used a default selection in the END Date prompt which has reolved the requirement  :D

Thank u very much for yr response.

Thanks,
Sg