I have designed a few reports in VS2005 with multi-parameter controls. When I
view these reports in VS they look fine, however once deployed and viewed in
the webbrowser (MS Internet Explorer) the drop-down boxes are too small (or
the font size is too big).
Is there a way to adjust (resize) the control boxes so you can make them
larger so it's easier for people to actually read where they can choose
between?
thanks,
mischaOn Jul 17, 3:54 am, mischa <mis...@.discussions.microsoft.com> wrote:
> I have designed a few reports in VS2005 with multi-parameter controls. When I
> view these reports in VS they look fine, however once deployed and viewed in
> the webbrowser (MS Internet Explorer) the drop-down boxes are too small (or
> the font size is too big).
> Is there a way to adjust (resize) the control boxes so you can make them
> larger so it's easier for people to actually read where they can choose
> between?
> thanks,
> mischa
As far as I know, there is not. This has been a common request on this
news group. Hopefully, this will be addressed in SSRS 2008. Otherwise,
you could try to inject CSS; however, I think that styling is only
allowed at the Report Manager page and report border level (though I'm
not sure). Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Jul 17, 3:54 am, mischa <mis...@.discussions.microsoft.com> wrote:
> I have designed a few reports in VS2005 with multi-parameter controls. When I
> view these reports in VS they look fine, however once deployed and viewed in
> the webbrowser (MS Internet Explorer) the drop-down boxes are too small (or
> the font size is too big).
> Is there a way to adjust (resize) the control boxes so you can make them
> larger so it's easier for people to actually read where they can choose
> between?
> thanks,
> mischa
It doesn't appear that my last reply posted; so, here it goes again.
As far as I know, this not possible. It has been a common request in
this newsgroup. Hopefully, a resolution for this will be provided in
SSRS 2008. The only other thing I can think of is to try and inject or
reference a CSS/stylesheet (but, I think this is limited to styling
the Report Mgr page, etc). Sorry that I could not be of greater
assistance.
Regards,
Enrique Martinez
Sr. Software Consultantsql
Showing posts with label parameters. Show all posts
Showing posts with label parameters. Show all posts
Wednesday, March 28, 2012
Resetting Email Queue
Hi
I have a the database mail system parameters set to retry sending failed
emails every ten minutes. I want to leave these settings as is.
How can I reset the queue ? that is delete all items in the queue - even if
they have failed! I need to refresh/delete them because we send out the
emails manually if they failed tooo many times - and then eventually sql 2005
alse sends them - i have to prevent this.
Answered my quesiton myself!
One can look at the default system stored procedure and modify it to accept
a subject for example as a parameter.
Then just tweak the rest of the stored procedure to make it select only mail
items with similar subjects and delete those!
done!
"I.W Coetzer" wrote:
> Hi
> I have a the database mail system parameters set to retry sending failed
> emails every ten minutes. I want to leave these settings as is.
> How can I reset the queue ? that is delete all items in the queue - even if
> they have failed! I need to refresh/delete them because we send out the
> emails manually if they failed tooo many times - and then eventually sql 2005
> alse sends them - i have to prevent this.
sql
I have a the database mail system parameters set to retry sending failed
emails every ten minutes. I want to leave these settings as is.
How can I reset the queue ? that is delete all items in the queue - even if
they have failed! I need to refresh/delete them because we send out the
emails manually if they failed tooo many times - and then eventually sql 2005
alse sends them - i have to prevent this.
Answered my quesiton myself!
One can look at the default system stored procedure and modify it to accept
a subject for example as a parameter.
Then just tweak the rest of the stored procedure to make it select only mail
items with similar subjects and delete those!
done!
"I.W Coetzer" wrote:
> Hi
> I have a the database mail system parameters set to retry sending failed
> emails every ten minutes. I want to leave these settings as is.
> How can I reset the queue ? that is delete all items in the queue - even if
> they have failed! I need to refresh/delete them because we send out the
> emails manually if they failed tooo many times - and then eventually sql 2005
> alse sends them - i have to prevent this.
sql
Resetting Email Queue
Hi
I have a the database mail system parameters set to retry sending failed
emails every ten minutes. I want to leave these settings as is.
How can I reset the queue ? that is delete all items in the queue - even if
they have failed! I need to refresh/delete them because we send out the
emails manually if they failed tooo many times - and then eventually sql 200
5
alse sends them - i have to prevent this.Answered my quesiton myself!
One can look at the default system stored procedure and modify it to accept
a subject for example as a parameter.
Then just tweak the rest of the stored procedure to make it select only mail
items with similar subjects and delete those!
done!
"I.W Coetzer" wrote:
> Hi
> I have a the database mail system parameters set to retry sending failed
> emails every ten minutes. I want to leave these settings as is.
> How can I reset the queue ? that is delete all items in the queue - even i
f
> they have failed! I need to refresh/delete them because we send out the
> emails manually if they failed tooo many times - and then eventually sql 2
005
> alse sends them - i have to prevent this.
I have a the database mail system parameters set to retry sending failed
emails every ten minutes. I want to leave these settings as is.
How can I reset the queue ? that is delete all items in the queue - even if
they have failed! I need to refresh/delete them because we send out the
emails manually if they failed tooo many times - and then eventually sql 200
5
alse sends them - i have to prevent this.Answered my quesiton myself!
One can look at the default system stored procedure and modify it to accept
a subject for example as a parameter.
Then just tweak the rest of the stored procedure to make it select only mail
items with similar subjects and delete those!
done!
"I.W Coetzer" wrote:
> Hi
> I have a the database mail system parameters set to retry sending failed
> emails every ten minutes. I want to leave these settings as is.
> How can I reset the queue ? that is delete all items in the queue - even i
f
> they have failed! I need to refresh/delete them because we send out the
> emails manually if they failed tooo many times - and then eventually sql 2
005
> alse sends them - i have to prevent this.
Resetting Email Queue
Hi
I have a the database mail system parameters set to retry sending failed
emails every ten minutes. I want to leave these settings as is.
How can I reset the queue ? that is delete all items in the queue - even if
they have failed! I need to refresh/delete them because we send out the
emails manually if they failed tooo many times - and then eventually sql 2005
alse sends them - i have to prevent this.Answered my quesiton myself!
One can look at the default system stored procedure and modify it to accept
a subject for example as a parameter.
Then just tweak the rest of the stored procedure to make it select only mail
items with similar subjects and delete those!
done!
"I.W Coetzer" wrote:
> Hi
> I have a the database mail system parameters set to retry sending failed
> emails every ten minutes. I want to leave these settings as is.
> How can I reset the queue ? that is delete all items in the queue - even if
> they have failed! I need to refresh/delete them because we send out the
> emails manually if they failed tooo many times - and then eventually sql 2005
> alse sends them - i have to prevent this.
I have a the database mail system parameters set to retry sending failed
emails every ten minutes. I want to leave these settings as is.
How can I reset the queue ? that is delete all items in the queue - even if
they have failed! I need to refresh/delete them because we send out the
emails manually if they failed tooo many times - and then eventually sql 2005
alse sends them - i have to prevent this.Answered my quesiton myself!
One can look at the default system stored procedure and modify it to accept
a subject for example as a parameter.
Then just tweak the rest of the stored procedure to make it select only mail
items with similar subjects and delete those!
done!
"I.W Coetzer" wrote:
> Hi
> I have a the database mail system parameters set to retry sending failed
> emails every ten minutes. I want to leave these settings as is.
> How can I reset the queue ? that is delete all items in the queue - even if
> they have failed! I need to refresh/delete them because we send out the
> emails manually if they failed tooo many times - and then eventually sql 2005
> alse sends them - i have to prevent this.
Friday, March 23, 2012
reset report parameters back to defaults
I am running SQL 2005 Reporting Services and designing reports via Visual
Studio.
Is there an easy way to reset/clear the report parameters back to the
defaults while viewing the report in IE.
Right now I have create a hyperlink which will re-direct to the URL of the
report which thus sets the paramaters back to their defaults, but it seems
that there must be a better way to do this.Hello,
Reporting Services did not provide the method to reset the parameters back
to the default.
Your solution is the best way I think to achieve your requirement.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.sql
Studio.
Is there an easy way to reset/clear the report parameters back to the
defaults while viewing the report in IE.
Right now I have create a hyperlink which will re-direct to the URL of the
report which thus sets the paramaters back to their defaults, but it seems
that there must be a better way to do this.Hello,
Reporting Services did not provide the method to reset the parameters back
to the default.
Your solution is the best way I think to achieve your requirement.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.sql
Reset Report Parameters
Hi
I am creating a report which have 10 different parameter. User needs a button or any functionality using which he/she can reset all the parameter at once and view unfiltered report.
How can I achieve that?
Regards
You can add a textbox that has an action set to "Jump to Report" and set the report to itself.
This will reset the parameters back to their default values or you can specify specific parameters to reset by setting the parameter values that you want to persist to their current value in the Actions dialog.
HTH, Jason
|||Thanks Jason.
That will do.
Regards
Monday, March 12, 2012
Request only the required parameters
Hello,
I have a rdl document with 1 DataSource and many dataSets (all MDX
type). For each dataSet I have one or more parameters (any of them
optional).
This rdl is clean in design terms (in layout mode there aren't any
objects). The goal is to give this file to other user(client) and he
will decide what data he want to see.
The problem that I have, simulating what the end user will do, is
after choosing some columns of data, when previewing, the Visual
Studio asks for all parameters of the rdl, even if I'm only asking to
see data of a particular dataset.
Is there a way to request only the required parameters for the data
that I want to see?
I already thought to divide this rdl document in many documents (one
for each dataset) but the client doesn't want that.
Thanks,
Sidhartagive each parameter a default value in report
"Sidharta" wrote:
> Hello,
> I have a rdl document with 1 DataSource and many dataSets (all MDX
> type). For each dataSet I have one or more parameters (any of them
> optional).
> This rdl is clean in design terms (in layout mode there aren't any
> objects). The goal is to give this file to other user(client) and he
> will decide what data he want to see.
> The problem that I have, simulating what the end user will do, is
> after choosing some columns of data, when previewing, the Visual
> Studio asks for all parameters of the rdl, even if I'm only asking to
> see data of a particular dataset.
> Is there a way to request only the required parameters for the data
> that I want to see?
> I already thought to divide this rdl document in many documents (one
> for each dataset) but the client doesn't want that.
> Thanks,
> Sidharta
>
I have a rdl document with 1 DataSource and many dataSets (all MDX
type). For each dataSet I have one or more parameters (any of them
optional).
This rdl is clean in design terms (in layout mode there aren't any
objects). The goal is to give this file to other user(client) and he
will decide what data he want to see.
The problem that I have, simulating what the end user will do, is
after choosing some columns of data, when previewing, the Visual
Studio asks for all parameters of the rdl, even if I'm only asking to
see data of a particular dataset.
Is there a way to request only the required parameters for the data
that I want to see?
I already thought to divide this rdl document in many documents (one
for each dataset) but the client doesn't want that.
Thanks,
Sidhartagive each parameter a default value in report
"Sidharta" wrote:
> Hello,
> I have a rdl document with 1 DataSource and many dataSets (all MDX
> type). For each dataSet I have one or more parameters (any of them
> optional).
> This rdl is clean in design terms (in layout mode there aren't any
> objects). The goal is to give this file to other user(client) and he
> will decide what data he want to see.
> The problem that I have, simulating what the end user will do, is
> after choosing some columns of data, when previewing, the Visual
> Studio asks for all parameters of the rdl, even if I'm only asking to
> see data of a particular dataset.
> Is there a way to request only the required parameters for the data
> that I want to see?
> I already thought to divide this rdl document in many documents (one
> for each dataset) but the client doesn't want that.
> Thanks,
> Sidharta
>
Friday, March 9, 2012
Request for extension
I would like to take full control of the entering of parameters, providing my
own UI for that, and would like to somehow extend the reporting framework.
Could you add an extension point for gathering of parameters? Is ther some
other way to do it?There is no way to extend or override the report server controls, but
you could make a web service call to GetReportParameters to find the
parameters for a report, thier type, thier dependencies, and thier
valid values. This would give you enough information to dynamically
build a UI to gather parameter information.
Once you have the parameter values you can pass them along in a URL to
the report server, or in the web service method Render to get the
report displayed.
HTH,
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Sat, 23 Oct 2004 10:09:04 -0700, "John Waters"
<JohnWaters@.discussions.microsoft.com> wrote:
>I would like to take full control of the entering of parameters, providing my
>own UI for that, and would like to somehow extend the reporting framework.
>Could you add an extension point for gathering of parameters? Is ther some
>other way to do it?
own UI for that, and would like to somehow extend the reporting framework.
Could you add an extension point for gathering of parameters? Is ther some
other way to do it?There is no way to extend or override the report server controls, but
you could make a web service call to GetReportParameters to find the
parameters for a report, thier type, thier dependencies, and thier
valid values. This would give you enough information to dynamically
build a UI to gather parameter information.
Once you have the parameter values you can pass them along in a URL to
the report server, or in the web service method Render to get the
report displayed.
HTH,
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Sat, 23 Oct 2004 10:09:04 -0700, "John Waters"
<JohnWaters@.discussions.microsoft.com> wrote:
>I would like to take full control of the entering of parameters, providing my
>own UI for that, and would like to somehow extend the reporting framework.
>Could you add an extension point for gathering of parameters? Is ther some
>other way to do it?
Wednesday, March 7, 2012
Repostition Parameters
I would like to know if it's possible and, if it is, how to reposition
parameters when viewing reports accessed through URL reporting and using the
Report Viewer. For example, we have 5 parameters on a report. One is a drop
down dynamic list of customer names, two are dates (start and end) and 2 are
radio buttons. We would like the list of customer names to be first with
nothing to the right of it. Then the two date parameters on the next line.
And lastly, the 2 radio button parameters displayed on the last line. I
cannot find a way to do this within SSRS or by using CSS. I fear it may be
totally controlled by SSRS with no chance for reformating or customization.
Thank you
--
Jeff Loebick
SQL Developer
ProformaOn Mar 14, 12:52 pm, Jeff Loebick
<JeffLoeb...@.discussions.microsoft.com> wrote:
> I would like to know if it's possible and, if it is, how to reposition
> parameters when viewing reports accessed through URL reporting and using the
> Report Viewer. For example, we have 5 parameters on a report. One is a drop
> down dynamic list of customer names, two are dates (start and end) and 2 are
> radio buttons. We would like the list of customer names to be first with
> nothing to the right of it. Then the two date parameters on the next line.
> And lastly, the 2 radio button parameters displayed on the last line. I
> cannot find a way to do this within SSRS or by using CSS. I fear it may be
> totally controlled by SSRS with no chance for reformating or customization.
> Thank you
> --
> Jeff Loebick
> SQL Developer
> Proforma
As far as I know, you are correct. That said, you can change ordering
of the parameters (i.e., which one is 1st, 2nd, and so on). That would
be done from the Report tab (at the top) -> Report Parameters dialog w/
the up and down arrows. Sorry that I could not be of further
assistance.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||If time permits, you can write your custom screen for all your entry needs
and integrate with reports using web services. Having said that, its not so
easy to write on the fly, but pretty simple if you have some time to write, I
have been using this web services for long and believe me its good. To start
with you can go through some samples available in BOl and pickup the same pgm
and change according to your needs, that will make your development faster.
Amarnath, MCTS
"Jeff Loebick" wrote:
> I would like to know if it's possible and, if it is, how to reposition
> parameters when viewing reports accessed through URL reporting and using the
> Report Viewer. For example, we have 5 parameters on a report. One is a drop
> down dynamic list of customer names, two are dates (start and end) and 2 are
> radio buttons. We would like the list of customer names to be first with
> nothing to the right of it. Then the two date parameters on the next line.
> And lastly, the 2 radio button parameters displayed on the last line. I
> cannot find a way to do this within SSRS or by using CSS. I fear it may be
> totally controlled by SSRS with no chance for reformating or customization.
> Thank you
> --
> Jeff Loebick
> SQL Developer
> Proforma
parameters when viewing reports accessed through URL reporting and using the
Report Viewer. For example, we have 5 parameters on a report. One is a drop
down dynamic list of customer names, two are dates (start and end) and 2 are
radio buttons. We would like the list of customer names to be first with
nothing to the right of it. Then the two date parameters on the next line.
And lastly, the 2 radio button parameters displayed on the last line. I
cannot find a way to do this within SSRS or by using CSS. I fear it may be
totally controlled by SSRS with no chance for reformating or customization.
Thank you
--
Jeff Loebick
SQL Developer
ProformaOn Mar 14, 12:52 pm, Jeff Loebick
<JeffLoeb...@.discussions.microsoft.com> wrote:
> I would like to know if it's possible and, if it is, how to reposition
> parameters when viewing reports accessed through URL reporting and using the
> Report Viewer. For example, we have 5 parameters on a report. One is a drop
> down dynamic list of customer names, two are dates (start and end) and 2 are
> radio buttons. We would like the list of customer names to be first with
> nothing to the right of it. Then the two date parameters on the next line.
> And lastly, the 2 radio button parameters displayed on the last line. I
> cannot find a way to do this within SSRS or by using CSS. I fear it may be
> totally controlled by SSRS with no chance for reformating or customization.
> Thank you
> --
> Jeff Loebick
> SQL Developer
> Proforma
As far as I know, you are correct. That said, you can change ordering
of the parameters (i.e., which one is 1st, 2nd, and so on). That would
be done from the Report tab (at the top) -> Report Parameters dialog w/
the up and down arrows. Sorry that I could not be of further
assistance.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||If time permits, you can write your custom screen for all your entry needs
and integrate with reports using web services. Having said that, its not so
easy to write on the fly, but pretty simple if you have some time to write, I
have been using this web services for long and believe me its good. To start
with you can go through some samples available in BOl and pickup the same pgm
and change according to your needs, that will make your development faster.
Amarnath, MCTS
"Jeff Loebick" wrote:
> I would like to know if it's possible and, if it is, how to reposition
> parameters when viewing reports accessed through URL reporting and using the
> Report Viewer. For example, we have 5 parameters on a report. One is a drop
> down dynamic list of customer names, two are dates (start and end) and 2 are
> radio buttons. We would like the list of customer names to be first with
> nothing to the right of it. Then the two date parameters on the next line.
> And lastly, the 2 radio button parameters displayed on the last line. I
> cannot find a way to do this within SSRS or by using CSS. I fear it may be
> totally controlled by SSRS with no chance for reformating or customization.
> Thank you
> --
> Jeff Loebick
> SQL Developer
> Proforma
Reposting: attempting to overcome cascading parameter refresh - with two sets of parameter
Let's say I have three cascading parameters. I make the selections in
P1, P2, P3. Now I change the selection in P2 in the next round.
Is there a way to 'remember' the previously selected parameter value -
somewhere... anywhere...'No responses... so I guess this is not possible.
Or is it because no one understood my question?
I want to somehow 'hold' the value of the selected parameter. And when
the user changes the parameter, I just want to be able to refrence his
previous selection.
Do I do this with another report behind the scenes?|||If you are still asking. The question is do you want a default or just the
user selection to stay?
"Harsh" wrote:
> No responses... so I guess this is not possible.
> Or is it because no one understood my question?
> I want to somehow 'hold' the value of the selected parameter. And when
> the user changes the parameter, I just want to be able to refrence his
> previous selection.
> Do I do this with another report behind the scenes?
>
P1, P2, P3. Now I change the selection in P2 in the next round.
Is there a way to 'remember' the previously selected parameter value -
somewhere... anywhere...'No responses... so I guess this is not possible.
Or is it because no one understood my question?
I want to somehow 'hold' the value of the selected parameter. And when
the user changes the parameter, I just want to be able to refrence his
previous selection.
Do I do this with another report behind the scenes?|||If you are still asking. The question is do you want a default or just the
user selection to stay?
"Harsh" wrote:
> No responses... so I guess this is not possible.
> Or is it because no one understood my question?
> I want to somehow 'hold' the value of the selected parameter. And when
> the user changes the parameter, I just want to be able to refrence his
> previous selection.
> Do I do this with another report behind the scenes?
>
Saturday, February 25, 2012
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
|
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
|
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!
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!
Tuesday, February 21, 2012
ReportViewer.ServerReport and using Parameters
I finally have figured out how to pass my UserName and Password to the reportserver and be able to run a report in my app.
NOW when I run a report that has parameters and select them then click on View Report it just returns a blank page and never shows the generating report message. When I run reports WITHOUT parameters they generate fine...
Am I missing something?
you probably use the paramters with a wrong format.if you have parameters and the report does nothing ,its because you didn't give the parameters the expected values or format...
Subscribe to:
Posts (Atom)