Repost: Calculated default parameters not visible in Web UI

Repost of a question / bug I reported one week ago. As I am an MSDN
universal member, I think I have the right of an MS employee answer.
I want to set report parameters to the first day of the previous month.
In order to do so, I calculate a parameter value by entering the
following into the Report Parameter Dialog (Default Values - Non
Queried): =New Date(Now.Year,Now.Month,1).AddMonths(-1)
This seems to work fine. But the Web UI doesn't display the standard
value if I go to Report Properties - Parameters. Instead, only a check
mark is displayed in the "Has default value" checkbox, the "default
value" textbox is empty. If I click on "apply", I get an error "a value
has to be supported".
If I type in the same calculation function again into the text box, I
get the exception "rsReportParameterTypeMismatch".
What I actually want to do: To create multiple linked reports with
differing calculated standard values, e.g. previous week, previous
month, previous day. If I can't change to calucation formula in the Web
UI interface, it seems there is no way of doing this.
Am I missing something here, or is that a bug? How can I accomplish this?
Thanks for any help
UrsHi, Urs
Please check the list of newsgroups which are supported as part of the MSDN
program at http://msdn.microsoft.com/newsgroups/managed/. This newsgroup
is not currently part of the program and hence posts here are no eligible
for our response commitment.
I hope this clarifies things for you
John Eikanger
Microsoft Developer Support
This posting is provided ?AS IS? with no warranties, and confers no rights.
--
| Date: Wed, 29 Sep 2004 12:18:28 +0200
| From: Urs Eichmann <ursli@.online.nospam>
| Subject: Repost: Calculated default parameters not visible in Web UI
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Repost of a question / bug I reported one week ago. As I am an MSDN
| universal member, I think I have the right of an MS employee answer.
|
| I want to set report parameters to the first day of the previous month.
| In order to do so, I calculate a parameter value by entering the
| following into the Report Parameter Dialog (Default Values - Non
| Queried): =New Date(Now.Year,Now.Month,1).AddMonths(-1)
|
| This seems to work fine. But the Web UI doesn't display the standard
| value if I go to Report Properties - Parameters. Instead, only a check
| mark is displayed in the "Has default value" checkbox, the "default
| value" textbox is empty. If I click on "apply", I get an error "a value
| has to be supported".
|
| If I type in the same calculation function again into the text box, I
| get the exception "rsReportParameterTypeMismatch".
|
| What I actually want to do: To create multiple linked reports with
| differing calculated standard values, e.g. previous week, previous
| month, previous day. If I can't change to calucation formula in the Web
| UI interface, it seems there is no way of doing this.
|
| Am I missing something here, or is that a bug? How can I accomplish this?
|
| Thanks for any help
| Urs
|