all groups > sql server reporting services > march 2005 >
You're in the

sql server reporting services

group:

Date parameters: yesterday's date


Date parameters: yesterday's date Jadranka
3/6/2005 2:53:02 PM
sql server reporting services:
I'm having a problem in the report designer with setting yesterday's date as
the default date parameters (Reporting From 'yesterday' To 'yesterday') for a
report. Both the From & To parameters need to default to yesterday, but the
user can enter a different date if they wish.

I've tried using =DateTime.Now().AddDays(-1) as well as =Today.AddDays(-1),
but I always get the following error when trying to preview the report in the
designer:

An unexpected error occurred while compiling expressions. Native compiler
return value: ‘[BC30260] 'EH_ReportingFrom' is already declared as 'Class
EH_ReportingFrom' in this class.’.

I'd appreciate any suggestions on how I can get this to work.

--
Jadranka Krapic
DBA
Stargate Technologies
Re: Date parameters: yesterday's date Robert Bruckner [MSFT]
3/6/2005 3:08:01 PM
Do you have a dataset called "ReportingFrom" in the report? If yes, either
rename the dataset or the parameter to resolve that error. BTW: this won't
happen on RS 2005.

--
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Re: Date parameters: yesterday's date Jadranka
3/6/2005 3:25:01 PM
Thanks for the quick response!

No, I don't have a ReportingFrom dataset in the report. The only dataset on
the report is called UpfrontFeesPayments, which calls a stored procedure.

Any other ideas?

[quoted text, click to view]
Re: Date parameters: yesterday's date Jadranka
3/6/2005 3:49:04 PM
I've gone back and re-created the parameters using different parameter names.
It works now (using both =DateTime.Now().AddDays(-1) and =Today.AddDays(-1)).

Thanks for your help.


[quoted text, click to view]
Re: Date parameters: yesterday's date John
3/7/2005 5:49:31 AM
I've also done this by crating another data set with a single sql query
that returns yesterday, the first of the month, and the end of the
month. That way I can put them in a drop down, or let them be
defaults.

Works like a charm.
AddThis Social Bookmark Button