Repost: Calculated default parameters not visible in Web UI

Repost of a question / bug I reported one month ago. I try it again
since as of 10/13/2004, this is a MSDN Managed newsgroup, so I hope I'll
receive an answer from an MS employee.
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 refer to my response to your post on the 29th:
http://msdn.microsoft.com/newsgroups/managed/default.aspx?&lang=en&cr=US&gui
d=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=290388f9-b
627-4ffe-bb36-a0104a6e62ae&mid=b0ff2328-8f9e-48e9-8466-13d6395c5135
Since then microsoft.public.sqlserver.reportingsvcs has been added to the
newsgroups included in the MSDN managed newsgroups program. I have
forwarded your post to the attention of the support team.
John Eikanger
Microsoft Developer Support
This posting is provided ?AS IS? with no warranties, and confers no rights.
--
| Date: Tue, 19 Oct 2004 12:36:11 +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 month ago. I try it again
| since as of 10/13/2004, this is a MSDN Managed newsgroup, so I hope I'll
| receive an answer from an MS employee.
|
| 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
||||Hi Uri,
Thanks for your post.
From your descriptions, I understood that you cannot set the default value
in the Web UI even you have defined it in Report Designer. Have I
understood you? Correct me if I was wrong.
Based on my knowledge, unfortuantely, this is an known issue of us. It will
only work when set in Report Designer. The latest news from development
team is that they are working on this and no hotfix available now. I am
afraid you will have to do the settings in the Report Designer.
I am sincerely sorry for any inconvenience it may cause for your business
and thank you for your patience and corperation. If you have any questions
or concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Mingqing,
Yes, you understood me correctly. What I want to do is design one report
and use it multiple times with different default values for the selection
i.e.
Report #1 Sales Current Month
report #2 Sales Current Month -1
report #3 Sales Current Month -2
...
report #12 Sales Current Month -11
...
I want to design only one report, and use it with different default
values, using a linked report. With the current implementation it seems
necessary to copy the report 11 times in the Designer and set the
default values there... of course I'll have to redo this every time I
change my report. A nightmare to maintain!
As I understand you, I don't have another option? I hope this will
improve soon!
Regards,
Urs
Mingqing Cheng [MSFT] wrote:
> Hi Uri,
> Thanks for your post.
> From your descriptions, I understood that you cannot set the default value
> in the Web UI even you have defined it in Report Designer. Have I
> understood you? Correct me if I was wrong.
> Based on my knowledge, unfortuantely, this is an known issue of us. It will
> only work when set in Report Designer. The latest news from development
> team is that they are working on this and no hotfix available now. I am
> afraid you will have to do the settings in the Report Designer.
> I am sincerely sorry for any inconvenience it may cause for your business
> and thank you for your patience and corperation. If you have any questions
> or concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Urs,
Hope the development team will fix it and we will announce it as soon as
possible.
For now, I am afraid you will have to use 12 reports with different default
values as workaround or change the business logic.
Thank you for your patience and corperation.
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Urs
I wanted to post a quick note to see if you would like additional
assistance regarding the information MSFT John H. Miller had sent to you on
this particular issue. We appreciate your patience and look forward to
hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!