Cascading Parameter issues

Hi all,
SSRS 2005
I have a Time Range parameter that has values
1 - This Week
2 - This Month
3 - This Quarter
4 - This Year
5 - Previous Week
6 - Previous Month
7 - Previous Quarter
8 - Previoous Year
I have 2 other parameters (Start and End Date) that are dependant upon what
they select in the Time Range.
TimeRange "1" is the default and is selected and StartDate shows "3/18/2007"
and EndDate shows "3/24/2007".
The problem is that I want the user to be able to override the dates that
are displayed in the Start and End Date parameters.
To do this, I have Set Start end End Data parameters with "Available Values"
set to Non-Queried and the "Default Values" set to "From Query".
When I first go to run the query, everything looks fine.
If I change the TimeRange to "2" ("This Month"), the Default Start and End
Dates do not update and stay at the dates initially loaded.
Thanks in advance for all your help.
Chris E.On Mar 23, 10:39 am, "Chris" <cex...@.enableconsulting.com> wrote:
> Hi all,
> SSRS 2005
> I have a Time Range parameter that has values
> 1 - This Week
> 2 - This Month
> 3 - This Quarter
> 4 - This Year
> 5 - Previous Week
> 6 - Previous Month
> 7 - Previous Quarter
> 8 - Previoous Year
> I have 2 other parameters (Start and End Date) that are dependant upon what
> they select in the Time Range.
> TimeRange "1" is the default and is selected and StartDate shows "3/18/2007"
> and EndDate shows "3/24/2007".
> The problem is that I want the user to be able to override the dates that
> are displayed in the Start and End Date parameters.
> To do this, I have Set Start end End Data parameters with "Available Values"
> set to Non-Queried and the "Default Values" set to "From Query".
> When I first go to run the query, everything looks fine.
> If I change the TimeRange to "2" ("This Month"), the Default Start and End
> Dates do not update and stay at the dates initially loaded.
> Thanks in advance for all your help.
> Chris E.
It seems like once you change the Time Range parameter value, you are
now using the Available Values/Non-Queried option for the Start and
End Date parameters. I would suggest having 2 additional parameter
options for the user to be allowed to enter in their own values for
Start Date and End Date, defaulting to empty strings; and control the
overriding at the database level (in the stored procedure or query
that is sourcing the report). Hope this is helpful.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Try instead of non queried, if possible, put the date range in a query so it
will refresh, whenever you select the time range.
Amarnath, MCTS
"Chris" wrote:
> Hi all,
> SSRS 2005
> I have a Time Range parameter that has values
> 1 - This Week
> 2 - This Month
> 3 - This Quarter
> 4 - This Year
> 5 - Previous Week
> 6 - Previous Month
> 7 - Previous Quarter
> 8 - Previoous Year
> I have 2 other parameters (Start and End Date) that are dependant upon what
> they select in the Time Range.
> TimeRange "1" is the default and is selected and StartDate shows "3/18/2007"
> and EndDate shows "3/24/2007".
> The problem is that I want the user to be able to override the dates that
> are displayed in the Start and End Date parameters.
> To do this, I have Set Start end End Data parameters with "Available Values"
> set to Non-Queried and the "Default Values" set to "From Query".
> When I first go to run the query, everything looks fine.
> If I change the TimeRange to "2" ("This Month"), the Default Start and End
> Dates do not update and stay at the dates initially loaded.
> Thanks in advance for all your help.
> Chris E.
>
>

Cascading Multivalue Parameters fail to populate in subscription view

SSRS - SP2

We have many reports with cascading multivalue parameters. The reports and the parameters work as expected within the BI development and when deployed to the RS server. The issue we are having is that when we go to the Report Manager webpage for one of these reports and create a New Subscription the report parameters in the subscription field fail to populate. The first one or two parameters may properly populate but the 3rd, 4th, and 5th fail to populate. As a result we can not select the parameters to submit the subscription.

We have two example reports where one report uses only sql (text) and the other report uses only stored procedures. Both reports have 2 or more cascading parameters.

Any known issues with cascading multivalue parameters in the Report Manager subscription view?

I'm having the exact same problem. Did you get a fix or an answer?

Cascading Multivalue Parameters fail to populate in subscription view

SSRS - SP2

We have many reports with cascading multivalue parameters. The reports and the parameters work as expected within the BI development and when deployed to the RS server. The issue we are having is that when we go to the Report Manager webpage for one of these reports and create a New Subscription the report parameters in the subscription field fail to populate. The first one or two parameters may properly populate but the 3rd, 4th, and 5th fail to populate. As a result we can not select the parameters to submit the subscription.

We have two example reports where one report uses only sql (text) and the other report uses only stored procedures. Both reports have 2 or more cascading parameters.

Any known issues with cascading multivalue parameters in the Report Manager subscription view?

I'm having the exact same problem. Did you get a fix or an answer?

carry over values to next page

hi, all.
is it possible to carry-over a subtotal of a page to the page header of the
next page?
we use ssrs 2005.
thx,
Carstenhi, all.
no idea? am i the one and only who needs a carry-forward value?
pls help.

Capture Referrer URL within a report.

I have a situation where my best solution is to capture the full Referrer URL in my SSRS 2005 Report to facilitate "Back" links within my reports. I have looked but don't see a way to capture this information natively in a report.

Any help is appreciated.

We don't expose the referrer URL to the processing engine, so there is no way to embed it into the report. In many cases, there is no referrer URL (consider all of the cases where you are not rendering to HTML).

What is wrong with the browser's back button?

|||

John Gallardo - MSFT wrote:

What is wrong with the browser's back button?

That is the same question I posed, but we are using a series of drill through reports and some reports have many pages. When clicking through from one report to another and they click the Back button, it returns them to the first page of the previous report. This can get tedious if they are looking at the detail on several rows from the first report.

Therefore, if I could capture the full URL from the previous report, I would be able to return them to the previous report with a link and they would be on the same page.

Otherwise, it will require trapping the full URL in the code environment which will not be easy to deal with on an infinity basis. I want to have unlimited drill throughs and unlimited Back links, maintining state.

If you have any ideas, I appreciate it.

|||How are you displaying the report? If you are using the HTML viewer control then it should be doing this already.|||

It would make my life easier if I had an ASP.NET solution using report viewer but that is not my situation. My reports are being viewed through JSP pages where the code is posting the request URL string to report server and integrating the returning HTML into the web page. It has posed many challenges, but this is the first one we haven't found a solution for.

If it can't be done, just let me know and I'll deliver the news. I know the JSP code environment should be able to capture this info, and if nothing native will work, I'll probalby setup a named variable placedholder in the Report Server reports that the JSP code will replace with the URL. That might work, but I'd rather keep it in the reports so it works when we internally browse to it directly through the report server web as well.

|||Yes, since you are not directly using the viewer control you will probably have to roll your own solution into your application.|||Thanks for your help John. For the benefit of anyone else in the same boat, the reason the back button doesn't work for me is that it is running under an SSL so the pages aren't cached locally. It works fine if I try it from a standard HTTP insecure address. For those browsing on the company intranet it should be ok.|||Hey,

Can you please share the information on how you are trying to integrate JSP and SSRS 2005. That will be helpful.

Regards,

Raj

Capture Referrer URL within a report.

I have a situation where my best solution is to capture the full Referrer URL in my SSRS 2005 Report to facilitate "Back" links within my reports. I have looked but don't see a way to capture this information natively in a report.

Any help is appreciated.

We don't expose the referrer URL to the processing engine, so there is no way to embed it into the report. In many cases, there is no referrer URL (consider all of the cases where you are not rendering to HTML).

What is wrong with the browser's back button?

|||

John Gallardo - MSFT wrote:

What is wrong with the browser's back button?

That is the same question I posed, but we are using a series of drill through reports and some reports have many pages. When clicking through from one report to another and they click the Back button, it returns them to the first page of the previous report. This can get tedious if they are looking at the detail on several rows from the first report.

Therefore, if I could capture the full URL from the previous report, I would be able to return them to the previous report with a link and they would be on the same page.

Otherwise, it will require trapping the full URL in the code environment which will not be easy to deal with on an infinity basis. I want to have unlimited drill throughs and unlimited Back links, maintining state.

If you have any ideas, I appreciate it.

|||How are you displaying the report? If you are using the HTML viewer control then it should be doing this already.|||

It would make my life easier if I had an ASP.NET solution using report viewer but that is not my situation. My reports are being viewed through JSP pages where the code is posting the request URL string to report server and integrating the returning HTML into the web page. It has posed many challenges, but this is the first one we haven't found a solution for.

If it can't be done, just let me know and I'll deliver the news. I know the JSP code environment should be able to capture this info, and if nothing native will work, I'll probalby setup a named variable placedholder in the Report Server reports that the JSP code will replace with the URL. That might work, but I'd rather keep it in the reports so it works when we internally browse to it directly through the report server web as well.

|||Yes, since you are not directly using the viewer control you will probably have to roll your own solution into your application.|||Thanks for your help John. For the benefit of anyone else in the same boat, the reason the back button doesn't work for me is that it is running under an SSL so the pages aren't cached locally. It works fine if I try it from a standard HTTP insecure address. For those browsing on the company intranet it should be ok.|||Hey,

Can you please share the information on how you are trying to integrate JSP and SSRS 2005. That will be helpful.

Regards,

Raj

Can''t uninstall SSRS 2005 x64

Hi all,

I'm having trouble removing SSRS from a Win 2003 x64 Server. I have searched the forums here and tried different suggestions but to no avail. The problem: I go to Add/Remove Programs and choose to change SQL Server, I select the 3-4 options required to remove Reporting Services and when I get to the screen that has the sub-heading 'The selected components are being configured' nothing happens. I just get a Next button but no other feedback whatsoever and SSRS still resides on the server.

It might be worth mentioning that during the change installation wizard I get a warning that 64 bit SSRS cannot be run when ASP.NET is running in 32 bit mode. This is in fact the reason I am uninstalling SSRS, but I do not know if this has any bearing on being able to remove SSRS.

Any ideas as to what I can do to remove this?

Regards,

Stephen.

Sometimes I enjoy giving obvious answers for kicks. I have a feeling this isn't the answer to your problem, but at least you got a response.

Why are you clicking change in Add/Remove Programs? Shouldn't you be clicking the remove button? And if you are removing SSRS from the server, why not just remove SQL Server completely?

|||

Thanks for the reply ??€?§Q?. Unfortunately I cannot remove SQL Server as this is a production server and SQL Server is host to 10 live DBs. The reason I am using Add/Remove programs is SSRS is a feature of the SQL Server 2005 installation so I am using the installation wizard that is activated from Add/Remove programs to try to remove SSRS from the SQL Server installation.

Regards,

Stephen.

|||

I managed to figure it out. Apparently the ASP.NET version warning was important. I set the used the adsutil admin script to set Enable32BitAppOnWin64 to false and then I was able to uninstall it. I then set Enable32BitAppOnWin64 to true and installed the 32 bit version.

Regards,

Stephen.

Can''t uninstall SSRS 2005 x64

Hi all,

I'm having trouble removing SSRS from a Win 2003 x64 Server. I have searched the forums here and tried different suggestions but to no avail. The problem: I go to Add/Remove Programs and choose to change SQL Server, I select the 3-4 options required to remove Reporting Services and when I get to the screen that has the sub-heading 'The selected components are being configured' nothing happens. I just get a Next button but no other feedback whatsoever and SSRS still resides on the server.

It might be worth mentioning that during the change installation wizard I get a warning that 64 bit SSRS cannot be run when ASP.NET is running in 32 bit mode. This is in fact the reason I am uninstalling SSRS, but I do not know if this has any bearing on being able to remove SSRS.

Any ideas as to what I can do to remove this?

Regards,

Stephen.

Sometimes I enjoy giving obvious answers for kicks. I have a feeling this isn't the answer to your problem, but at least you got a response.

Why are you clicking change in Add/Remove Programs? Shouldn't you be clicking the remove button? And if you are removing SSRS from the server, why not just remove SQL Server completely?

|||

Thanks for the reply ??€?§Q?. Unfortunately I cannot remove SQL Server as this is a production server and SQL Server is host to 10 live DBs. The reason I am using Add/Remove programs is SSRS is a feature of the SQL Server 2005 installation so I am using the installation wizard that is activated from Add/Remove programs to try to remove SSRS from the SQL Server installation.

Regards,

Stephen.

|||

I managed to figure it out. Apparently the ASP.NET version warning was important. I set the used the adsutil admin script to set Enable32BitAppOnWin64 to false and then I was able to uninstall it. I then set Enable32BitAppOnWin64 to true and installed the 32 bit version.

Regards,

Stephen.

Can''t uninstall SSRS 2005 x64

Hi all,

I'm having trouble removing SSRS from a Win 2003 x64 Server. I have searched the forums here and tried different suggestions but to no avail. The problem: I go to Add/Remove Programs and choose to change SQL Server, I select the 3-4 options required to remove Reporting Services and when I get to the screen that has the sub-heading 'The selected components are being configured' nothing happens. I just get a Next button but no other feedback whatsoever and SSRS still resides on the server.

It might be worth mentioning that during the change installation wizard I get a warning that 64 bit SSRS cannot be run when ASP.NET is running in 32 bit mode. This is in fact the reason I am uninstalling SSRS, but I do not know if this has any bearing on being able to remove SSRS.

Any ideas as to what I can do to remove this?

Regards,

Stephen.

Sometimes I enjoy giving obvious answers for kicks. I have a feeling this isn't the answer to your problem, but at least you got a response.

Why are you clicking change in Add/Remove Programs? Shouldn't you be clicking the remove button? And if you are removing SSRS from the server, why not just remove SQL Server completely?

|||

Thanks for the reply ??€?§Q?. Unfortunately I cannot remove SQL Server as this is a production server and SQL Server is host to 10 live DBs. The reason I am using Add/Remove programs is SSRS is a feature of the SQL Server 2005 installation so I am using the installation wizard that is activated from Add/Remove programs to try to remove SSRS from the SQL Server installation.

Regards,

Stephen.

|||

I managed to figure it out. Apparently the ASP.NET version warning was important. I set the used the adsutil admin script to set Enable32BitAppOnWin64 to false and then I was able to uninstall it. I then set Enable32BitAppOnWin64 to true and installed the 32 bit version.

Regards,

Stephen.

Can''t uninstall SSRS 2005 x64

Hi all,

I'm having trouble removing SSRS from a Win 2003 x64 Server. I have searched the forums here and tried different suggestions but to no avail. The problem: I go to Add/Remove Programs and choose to change SQL Server, I select the 3-4 options required to remove Reporting Services and when I get to the screen that has the sub-heading 'The selected components are being configured' nothing happens. I just get a Next button but no other feedback whatsoever and SSRS still resides on the server.

It might be worth mentioning that during the change installation wizard I get a warning that 64 bit SSRS cannot be run when ASP.NET is running in 32 bit mode. This is in fact the reason I am uninstalling SSRS, but I do not know if this has any bearing on being able to remove SSRS.

Any ideas as to what I can do to remove this?

Regards,

Stephen.

Sometimes I enjoy giving obvious answers for kicks. I have a feeling this isn't the answer to your problem, but at least you got a response.

Why are you clicking change in Add/Remove Programs? Shouldn't you be clicking the remove button? And if you are removing SSRS from the server, why not just remove SQL Server completely?

|||

Thanks for the reply ??€?§Q?. Unfortunately I cannot remove SQL Server as this is a production server and SQL Server is host to 10 live DBs. The reason I am using Add/Remove programs is SSRS is a feature of the SQL Server 2005 installation so I am using the installation wizard that is activated from Add/Remove programs to try to remove SSRS from the SQL Server installation.

Regards,

Stephen.

|||

I managed to figure it out. Apparently the ASP.NET version warning was important. I set the used the adsutil admin script to set Enable32BitAppOnWin64 to false and then I was able to uninstall it. I then set Enable32BitAppOnWin64 to true and installed the 32 bit version.

Regards,

Stephen.