Back to Parent Report button not visible

When I preview a report that has a link to a details report page in VS a "Back to Parent Report" button is displayed. However, when I publish the report to the Report Server, the .aspx page doesnt display the "Back to Parent Report" button. Is there a setting I need to make to have the button displayed?

thanks, lance

The "back to parent" functionality in the HTML report viewer is achieved by clicking the browser's back button.

-- Robert

|||

Well, this isnt the same functionality. Yes, the browser back button goes 1 page back. But the back to parent report, jumps back to the parent report no matter how many pages you have paged through in the child report. If I have a child report that has 20 pages and I scroll through all the pages by clicking next page, the UI you're suggesting requires me to click the back button in the browser 20 times. I could add links in every child report back to the parent report, but this requires embedded links. A "back to parent" report button should automate this process.

Is it possible to add the "back to parent report" button?

Thanks, lance

|||I concur. I need to add the back to parent report button as well.|||What do you think MSFT? Can this functionality be added easily and quickly (anytime before June 23, 2006 would be great)

?

Thanks, -lance|||

Are you talking about viewing a report through report manager? In this case, the browser's back button will always return to the parent report, even if you clicked next page multiple times in the child report.

-- Robert

|||Yes, but thats a non standard UI. Most users are used to having a back to parent button (just as VS has) in order to automatically jump back to the original list page. When paging through a list of records, the back button usually takes you back a list page (see google).

thanks, -lance|||

Ok. So it sounds like you want the browser back button to take you to the previous page (when paging through reports), and you want a separate "back to parent" button.

Once you jump back to parent, I guess you would expect that the brower's back button would then take you back to the previous page on the parent report (basically keeping the browser's pagination history information in sync with drillthroughs / back to parent jumps)?

Well, this kind of functionality is under consideration for a future release - but definitely not available in two days (by June 23rd) as you have asked earlier in this thread.

-- Robert

|||That doesn't appear to be the case when you add "interactive sorting" to the child report. One the table is re-sorted a number of times, the user shouldn't need to hit back n+1 times.|||

Thanks for your help on this. I know there was a lot of back and forth about the behavior.

I know that people in my organization have asked for a back to parent report feature (i had to embed links to jump back to the parent report into all the reports) and it would be a beneficial feature.

-lance

|||

Robert,

From what I am seeing, the back button works well in IE6 to navigate up from a dill down in reports.

However, in IE7rc1 this is not the case. The back button does not work.

Is this a known issue?

thanks.

Chris

|||

You have to click the back button twice with IE7 RC1 - this is a known issue.

-- Robert

|||Was this functionality released? Or is it still coming.|||

I would just like to register that I am still interested in having a back to parent button available on the standard report viewer web page. It does not seem to have come with SQL 2005 SP2.

There is however the oprion to make such a button appear when you create a web page using aspx:

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Enabled="true"
OnDrillthrough = "ReportViewer1_Drillthrough" OnBack = "ReportViewer1_Back"
AsyncRendering=false SizeToReportContent=true >

.in .cs

...

ReportViewer1.PromptAreaCollapsed = true;
ReportViewer1.ShowBackButton = true;
ReportViewer1.HyperlinkTarget = "_self";
...

Can Microsoft make this button available as an option as part of the standard report viewer?(http://MyServer/ReportServer/Pages/ReportViewer.aspx)

Back to Parent Report button not visible

When I preview a report that has a link to a details report page in VS a "Back to Parent Report" button is displayed. However, when I publish the report to the Report Server, the .aspx page doesnt display the "Back to Parent Report" button. Is there a setting I need to make to have the button displayed?

thanks, lance

The "back to parent" functionality in the HTML report viewer is achieved by clicking the browser's back button.

-- Robert

|||

Well, this isnt the same functionality. Yes, the browser back button goes 1 page back. But the back to parent report, jumps back to the parent report no matter how many pages you have paged through in the child report. If I have a child report that has 20 pages and I scroll through all the pages by clicking next page, the UI you're suggesting requires me to click the back button in the browser 20 times. I could add links in every child report back to the parent report, but this requires embedded links. A "back to parent" report button should automate this process.

Is it possible to add the "back to parent report" button?

Thanks, lance

|||I concur. I need to add the back to parent report button as well.|||What do you think MSFT? Can this functionality be added easily and quickly (anytime before June 23, 2006 would be great)

?

Thanks, -lance|||

Are you talking about viewing a report through report manager? In this case, the browser's back button will always return to the parent report, even if you clicked next page multiple times in the child report.

-- Robert

|||Yes, but thats a non standard UI. Most users are used to having a back to parent button (just as VS has) in order to automatically jump back to the original list page. When paging through a list of records, the back button usually takes you back a list page (see google).

thanks, -lance|||

Ok. So it sounds like you want the browser back button to take you to the previous page (when paging through reports), and you want a separate "back to parent" button.

Once you jump back to parent, I guess you would expect that the brower's back button would then take you back to the previous page on the parent report (basically keeping the browser's pagination history information in sync with drillthroughs / back to parent jumps)?

Well, this kind of functionality is under consideration for a future release - but definitely not available in two days (by June 23rd) as you have asked earlier in this thread.

-- Robert

|||That doesn't appear to be the case when you add "interactive sorting" to the child report. One the table is re-sorted a number of times, the user shouldn't need to hit back n+1 times.|||

Thanks for your help on this. I know there was a lot of back and forth about the behavior.

I know that people in my organization have asked for a back to parent report feature (i had to embed links to jump back to the parent report into all the reports) and it would be a beneficial feature.

-lance

|||

Robert,

From what I am seeing, the back button works well in IE6 to navigate up from a dill down in reports.

However, in IE7rc1 this is not the case. The back button does not work.

Is this a known issue?

thanks.

Chris

|||

You have to click the back button twice with IE7 RC1 - this is a known issue.

-- Robert

|||Was this functionality released? Or is it still coming.|||

I would just like to register that I am still interested in having a back to parent button available on the standard report viewer web page. It does not seem to have come with SQL 2005 SP2.

There is however the oprion to make such a button appear when you create a web page using aspx:

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Enabled="true"
OnDrillthrough = "ReportViewer1_Drillthrough" OnBack = "ReportViewer1_Back"
AsyncRendering=false SizeToReportContent=true >

.in .cs

...

ReportViewer1.PromptAreaCollapsed = true;
ReportViewer1.ShowBackButton = true;
ReportViewer1.HyperlinkTarget = "_self";
...

Can Microsoft make this button available as an option as part of the standard report viewer?(http://MyServer/ReportServer/Pages/ReportViewer.aspx)

Back to Parent Report button not visible

When I preview a report that has a link to a details report page in VS a "Back to Parent Report" button is displayed. However, when I publish the report to the Report Server, the .aspx page doesnt display the "Back to Parent Report" button. Is there a setting I need to make to have the button displayed?

thanks, lance

The "back to parent" functionality in the HTML report viewer is achieved by clicking the browser's back button.

-- Robert

|||

Well, this isnt the same functionality. Yes, the browser back button goes 1 page back. But the back to parent report, jumps back to the parent report no matter how many pages you have paged through in the child report. If I have a child report that has 20 pages and I scroll through all the pages by clicking next page, the UI you're suggesting requires me to click the back button in the browser 20 times. I could add links in every child report back to the parent report, but this requires embedded links. A "back to parent" report button should automate this process.

Is it possible to add the "back to parent report" button?

Thanks, lance

|||I concur. I need to add the back to parent report button as well.|||What do you think MSFT? Can this functionality be added easily and quickly (anytime before June 23, 2006 would be great)

?

Thanks, -lance|||

Are you talking about viewing a report through report manager? In this case, the browser's back button will always return to the parent report, even if you clicked next page multiple times in the child report.

-- Robert

|||Yes, but thats a non standard UI. Most users are used to having a back to parent button (just as VS has) in order to automatically jump back to the original list page. When paging through a list of records, the back button usually takes you back a list page (see google).

thanks, -lance|||

Ok. So it sounds like you want the browser back button to take you to the previous page (when paging through reports), and you want a separate "back to parent" button.

Once you jump back to parent, I guess you would expect that the brower's back button would then take you back to the previous page on the parent report (basically keeping the browser's pagination history information in sync with drillthroughs / back to parent jumps)?

Well, this kind of functionality is under consideration for a future release - but definitely not available in two days (by June 23rd) as you have asked earlier in this thread.

-- Robert

|||That doesn't appear to be the case when you add "interactive sorting" to the child report. One the table is re-sorted a number of times, the user shouldn't need to hit back n+1 times.|||

Thanks for your help on this. I know there was a lot of back and forth about the behavior.

I know that people in my organization have asked for a back to parent report feature (i had to embed links to jump back to the parent report into all the reports) and it would be a beneficial feature.

-lance

|||

Robert,

From what I am seeing, the back button works well in IE6 to navigate up from a dill down in reports.

However, in IE7rc1 this is not the case. The back button does not work.

Is this a known issue?

thanks.

Chris

|||

You have to click the back button twice with IE7 RC1 - this is a known issue.

-- Robert

|||Was this functionality released? Or is it still coming.|||

I would just like to register that I am still interested in having a back to parent button available on the standard report viewer web page. It does not seem to have come with SQL 2005 SP2.

There is however the oprion to make such a button appear when you create a web page using aspx:

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Enabled="true"
OnDrillthrough = "ReportViewer1_Drillthrough" OnBack = "ReportViewer1_Back"
AsyncRendering=false SizeToReportContent=true >

.in .cs

...

ReportViewer1.PromptAreaCollapsed = true;
ReportViewer1.ShowBackButton = true;
ReportViewer1.HyperlinkTarget = "_self";
...

Can Microsoft make this button available as an option as part of the standard report viewer?(http://MyServer/ReportServer/Pages/ReportViewer.aspx)

Back to Parent Report button not visible

When I preview a report that has a link to a details report page in VS a "Back to Parent Report" button is displayed. However, when I publish the report to the Report Server, the .aspx page doesnt display the "Back to Parent Report" button. Is there a setting I need to make to have the button displayed?

thanks, lance

The "back to parent" functionality in the HTML report viewer is achieved by clicking the browser's back button.

-- Robert

|||

Well, this isnt the same functionality. Yes, the browser back button goes 1 page back. But the back to parent report, jumps back to the parent report no matter how many pages you have paged through in the child report. If I have a child report that has 20 pages and I scroll through all the pages by clicking next page, the UI you're suggesting requires me to click the back button in the browser 20 times. I could add links in every child report back to the parent report, but this requires embedded links. A "back to parent" report button should automate this process.

Is it possible to add the "back to parent report" button?

Thanks, lance

|||I concur. I need to add the back to parent report button as well.|||What do you think MSFT? Can this functionality be added easily and quickly (anytime before June 23, 2006 would be great)

?

Thanks, -lance|||

Are you talking about viewing a report through report manager? In this case, the browser's back button will always return to the parent report, even if you clicked next page multiple times in the child report.

-- Robert

|||Yes, but thats a non standard UI. Most users are used to having a back to parent button (just as VS has) in order to automatically jump back to the original list page. When paging through a list of records, the back button usually takes you back a list page (see google).

thanks, -lance|||

Ok. So it sounds like you want the browser back button to take you to the previous page (when paging through reports), and you want a separate "back to parent" button.

Once you jump back to parent, I guess you would expect that the brower's back button would then take you back to the previous page on the parent report (basically keeping the browser's pagination history information in sync with drillthroughs / back to parent jumps)?

Well, this kind of functionality is under consideration for a future release - but definitely not available in two days (by June 23rd) as you have asked earlier in this thread.

-- Robert

|||That doesn't appear to be the case when you add "interactive sorting" to the child report. One the table is re-sorted a number of times, the user shouldn't need to hit back n+1 times.|||

Thanks for your help on this. I know there was a lot of back and forth about the behavior.

I know that people in my organization have asked for a back to parent report feature (i had to embed links to jump back to the parent report into all the reports) and it would be a beneficial feature.

-lance

|||

Robert,

From what I am seeing, the back button works well in IE6 to navigate up from a dill down in reports.

However, in IE7rc1 this is not the case. The back button does not work.

Is this a known issue?

thanks.

Chris

|||

You have to click the back button twice with IE7 RC1 - this is a known issue.

-- Robert

|||Was this functionality released? Or is it still coming.|||

I would just like to register that I am still interested in having a back to parent button available on the standard report viewer web page. It does not seem to have come with SQL 2005 SP2.

There is however the oprion to make such a button appear when you create a web page using aspx:

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Enabled="true"
OnDrillthrough = "ReportViewer1_Drillthrough" OnBack = "ReportViewer1_Back"
AsyncRendering=false SizeToReportContent=true >

.in .cs

...

ReportViewer1.PromptAreaCollapsed = true;
ReportViewer1.ShowBackButton = true;
ReportViewer1.HyperlinkTarget = "_self";
...

Can Microsoft make this button available as an option as part of the standard report viewer?(http://MyServer/ReportServer/Pages/ReportViewer.aspx)

Back Button in RS 2000?

Hello.
I'm developing reports in Reporting Services 2000 and Visual Studio 2003. I
have a "drill-through" report. Upon drilling through to the report, and then
clicking the back button to return to the main report, the report doesn't
even render. However, while developing the report and previewing it in VS
2003, there is a back button supplied there that works perfectly every time.
My question is this: is there a way to tell Reporting Services to include a
back button like the one in the report designer on the deployed report?
Alternatively, is there a way to provide a hyperlink in the drill-through
report that takes the user back to the original report (with all parameters
included in the link)?
Thanks!
JohnA small Back button is available in 2005. If it is not a parameter report
then it would have been easy, but since the main report is parameter based,
you can have a back button link and once you click; it comes back to the
main page and waits for parameter. So really it doesn;t serves your purpose.
But if the main page can wait for the input then you can use this method.
Amarnath
"JohnJohn" wrote:
> Hello.
> I'm developing reports in Reporting Services 2000 and Visual Studio 2003. I
> have a "drill-through" report. Upon drilling through to the report, and then
> clicking the back button to return to the main report, the report doesn't
> even render. However, while developing the report and previewing it in VS
> 2003, there is a back button supplied there that works perfectly every time.
> My question is this: is there a way to tell Reporting Services to include a
> back button like the one in the report designer on the deployed report?
> Alternatively, is there a way to provide a hyperlink in the drill-through
> report that takes the user back to the original report (with all parameters
> included in the link)?
> Thanks!
> John

Back button for drilldown reports

Hereâ's a good question for the knowledgeable: I have been experimenting with
drilldown reports (where a report item is linked to a â'Jump to Reportâ'
action). In the designer there is a nifty little button that allows me to
move back to the previous report (level). This button does not seem apparent
in the Report Manager.
Am I missing something? I realize that there is IEâ's â'backâ' button however
that does not always return me to the previous report. For example if I
toggle the visibility of an item the browserâ's â'backâ' button will return me
to the previous state (hidden) as opposed to back to the report from which
this one was called.Yeah, there isn't one. I just put a back hyperlink in the header and footer
of each page and made sure when going back it sets the parameters to
whatever the default values are or in some cases whatever they were set to
the last time that report was visited.
bob.
"Herman K" <HermanK@.discussions.microsoft.com> wrote in message
news:D08E3158-FB92-4828-A6A8-ABCAA702AE3A@.microsoft.com...
> Here's a good question for the knowledgeable: I have been experimenting
> with
> drilldown reports (where a report item is linked to a 'Jump to Report'
> action). In the designer there is a nifty little button that allows me to
> move back to the previous report (level). This button does not seem
> apparent
> in the Report Manager.
> Am I missing something? I realize that there is IE's 'back' button
> however
> that does not always return me to the previous report. For example if I
> toggle the visibility of an item the browser's 'back' button will return
> me
> to the previous state (hidden) as opposed to back to the report from which
> this one was called.
>

Back button for drill down reports

Hello,

In the sharepoint site from the main report when i go to my drill down report i see no back button, Is there a way to provide back button in the toolbar. I dont want to use the page back button. or is there any way by which if i click for my drill down report the report will be opened in a new window?

Thanks & Regds,

I don't quite remember doing this .. but i was trying to use the

<a href=" javascript:history.back()" >back</a>

tag in reporting services to create a hyperlink which goes one page back in the page history. That effectively will take you to the previous main report.

Alternative is, use a text box in the drill down report, and in the navigation tab of the text box, choose the main report again. The CONS of this is that the main report is generated rather than just going back to the previous page, additionally if the user had changed the parameters of the main report before drilling down, this would not work, as it would open the report with the default set parameters. You can pass all the params of the main report to the drill down report (whether they are being used there or not) and then pass it back.

This does not seem to be the best solution, as i can see it. I remember doing something of this sort long back in BETA of SQL Server. I shall see if i can come up with an alternate way of doing this.

Back button for drill down reports

Hello,

In the sharepoint site from the main report when i go to my drill down report i see no back button, Is there a way to provide back button in the toolbar. I dont want to use the page back button. or is there any way by which if i click for my drill down report the report will be opened in a new window?

Thanks & Regds,

I don't quite remember doing this .. but i was trying to use the

<a href=" javascript:history.back()" >back</a>

tag in reporting services to create a hyperlink which goes one page back in the page history. That effectively will take you to the previous main report.

Alternative is, use a text box in the drill down report, and in the navigation tab of the text box, choose the main report again. The CONS of this is that the main report is generated rather than just going back to the previous page, additionally if the user had changed the parameters of the main report before drilling down, this would not work, as it would open the report with the default set parameters. You can pass all the params of the main report to the drill down report (whether they are being used there or not) and then pass it back.

This does not seem to be the best solution, as i can see it. I remember doing something of this sort long back in BETA of SQL Server. I shall see if i can come up with an alternate way of doing this.

Back button does not regenerate original report

When I drill down from one report to another and then depress the back button to return to the initial report, the message 'Generating Report" spins forever without actually running. However, if I depress the regenerate button during this time, it will run the report.

I believe that I may have inadvertingly reset a field attribute to have caused this condition. Ironocally, I have the same set of database installed on another server, and the this does not happen.

I forgot to mention that I am using Report Manager to deploy the reports.

Please assist.

Just checking if anyone has any additional info on this. I'm having the same problem. SQL Server 2005 (SP2), Reporting Services 2005 (SP2).

Any help is appreciated as this is a major usability issue.

|||I am also experiencing this issue.|||I think microsoft fixed this. In vista64/sql64 there is no back button......that I can find.|||This thread is talking about the browser (internet explorer) back button.|||

Can someone from Microsoft please chime in on this issue. If you hit the browser back button from IE from a drilled/jump to report, the original report is not shown. The "Report is being generated" screen just sits there. This is a huge usability issue.

Also, can someone from Microsoft point me to where we're supposed to find out when/if an upcoming SP/hotfix is going to come out and what is included. I want to move our reporting system to Reporting Services but the above issue is one of the reasons I can't.

|||

I am also getting this on multiple machines and databases. I can recreate it starting with 2 simple reports, the main report and a drill down report. The browser back button tries to bring up the original report, but never finishes. I noticed there is always an HTML error on the report that goes away if you click refresh. (Note: The error only shows up if your browser is set to show errors). I am using SQL Service Pack 2 and IE7. The error I get is:

Line: 718

Char: 5

Error: 'location' is null or not an object

Code: 0

URL: ......

|||

I am having this problem too, since we moved to SQL 2005 64-bit,sp2.

With certain reports that are hyperlinked to other reports, pressing the IE back button (to return to the previous report) goes into the endless 'Report is being generated, green spin'. Only by clicking on the report's toolbar refresh button does the report re-display.

This appears to be a problem only with the combination of SQL 2005 64-bit and IE 7. Everything works great! with SQL 2005 32-bit and IE 6 or 7 and even using SQL 2005 64-bit with IE 6. The problem seems to be in IE 7 when SQL 2005 64-bit is the backend database. Any help or advice would be greatly appreciated!

Sam

|||

Are all of you using the 64-bit version? I am using the 32 bit version with IE 7 and have never experienced that problem.

I experience a problem with report viewer where I drilldown into a report and click the next page button. Then mysteriously the parent report displays. It's odd, but not too big of a deal to me.

|||We are on the 64-bit version.

Back button does not regenerate original report

When I drill down from one report to another and then depress the back button to return to the initial report, the message 'Generating Report" spins forever without actually running. However, if I depress the regenerate button during this time, it will run the report.

I believe that I may have inadvertingly reset a field attribute to have caused this condition. Ironocally, I have the same set of database installed on another server, and the this does not happen.

I forgot to mention that I am using Report Manager to deploy the reports.

Please assist.

moving to SQL Server Reporting Services forum.

Back button does not regenerate original report

When I drill down from one report to another and then depress the back button to return to the initial report, the message 'Generating Report" spins forever without actually running. However, if I depress the regenerate button during this time, it will run the report.

I believe that I may have inadvertingly reset a field attribute to have caused this condition. Ironocally, I have the same set of database installed on another server, and the this does not happen.

I forgot to mention that I am using Report Manager to deploy the reports.

Please assist.

Just checking if anyone has any additional info on this. I'm having the same problem. SQL Server 2005 (SP2), Reporting Services 2005 (SP2).

Any help is appreciated as this is a major usability issue.

|||I am also experiencing this issue.|||I think microsoft fixed this. In vista64/sql64 there is no back button......that I can find.|||This thread is talking about the browser (internet explorer) back button.|||

Can someone from Microsoft please chime in on this issue. If you hit the browser back button from IE from a drilled/jump to report, the original report is not shown. The "Report is being generated" screen just sits there. This is a huge usability issue.

Also, can someone from Microsoft point me to where we're supposed to find out when/if an upcoming SP/hotfix is going to come out and what is included. I want to move our reporting system to Reporting Services but the above issue is one of the reasons I can't.

|||

I am also getting this on multiple machines and databases. I can recreate it starting with 2 simple reports, the main report and a drill down report. The browser back button tries to bring up the original report, but never finishes. I noticed there is always an HTML error on the report that goes away if you click refresh. (Note: The error only shows up if your browser is set to show errors). I am using SQL Service Pack 2 and IE7. The error I get is:

Line: 718

Char: 5

Error: 'location' is null or not an object

Code: 0

URL: ......

|||

I am having this problem too, since we moved to SQL 2005 64-bit,sp2.

With certain reports that are hyperlinked to other reports, pressing the IE back button (to return to the previous report) goes into the endless 'Report is being generated, green spin'. Only by clicking on the report's toolbar refresh button does the report re-display.

This appears to be a problem only with the combination of SQL 2005 64-bit and IE 7. Everything works great! with SQL 2005 32-bit and IE 6 or 7 and even using SQL 2005 64-bit with IE 6. The problem seems to be in IE 7 when SQL 2005 64-bit is the backend database. Any help or advice would be greatly appreciated!

Sam

|||

Are all of you using the 64-bit version? I am using the 32 bit version with IE 7 and have never experienced that problem.

I experience a problem with report viewer where I drilldown into a report and click the next page button. Then mysteriously the parent report displays. It's odd, but not too big of a deal to me.

|||We are on the 64-bit version.

Back button does not regenerate original report

When I drill down from one report to another and then depress the back button to return to the initial report, the message 'Generating Report" spins forever without actually running. However, if I depress the regenerate button during this time, it will run the report.

I believe that I may have inadvertingly reset a field attribute to have caused this condition. Ironocally, I have the same set of database installed on another server, and the this does not happen.

I forgot to mention that I am using Report Manager to deploy the reports.

Please assist.

Just checking if anyone has any additional info on this. I'm having the same problem. SQL Server 2005 (SP2), Reporting Services 2005 (SP2).

Any help is appreciated as this is a major usability issue.

|||I am also experiencing this issue.|||I think microsoft fixed this. In vista64/sql64 there is no back button......that I can find.|||This thread is talking about the browser (internet explorer) back button.|||

Can someone from Microsoft please chime in on this issue. If you hit the browser back button from IE from a drilled/jump to report, the original report is not shown. The "Report is being generated" screen just sits there. This is a huge usability issue.

Also, can someone from Microsoft point me to where we're supposed to find out when/if an upcoming SP/hotfix is going to come out and what is included. I want to move our reporting system to Reporting Services but the above issue is one of the reasons I can't.

|||

I am also getting this on multiple machines and databases. I can recreate it starting with 2 simple reports, the main report and a drill down report. The browser back button tries to bring up the original report, but never finishes. I noticed there is always an HTML error on the report that goes away if you click refresh. (Note: The error only shows up if your browser is set to show errors). I am using SQL Service Pack 2 and IE7. The error I get is:

Line: 718

Char: 5

Error: 'location' is null or not an object

Code: 0

URL: ......

|||

I am having this problem too, since we moved to SQL 2005 64-bit,sp2.

With certain reports that are hyperlinked to other reports, pressing the IE back button (to return to the previous report) goes into the endless 'Report is being generated, green spin'. Only by clicking on the report's toolbar refresh button does the report re-display.

This appears to be a problem only with the combination of SQL 2005 64-bit and IE 7. Everything works great! with SQL 2005 32-bit and IE 6 or 7 and even using SQL 2005 64-bit with IE 6. The problem seems to be in IE 7 when SQL 2005 64-bit is the backend database. Any help or advice would be greatly appreciated!

Sam

|||

Are all of you using the 64-bit version? I am using the 32 bit version with IE 7 and have never experienced that problem.

I experience a problem with report viewer where I drilldown into a report and click the next page button. Then mysteriously the parent report displays. It's odd, but not too big of a deal to me.

|||We are on the 64-bit version.

Back button does not regenerate original report

When I drill down from one report to another and then depress the back button to return to the initial report, the message 'Generating Report" spins forever without actually running. However, if I depress the regenerate button during this time, it will run the report.

I believe that I may have inadvertingly reset a field attribute to have caused this condition. Ironocally, I have the same set of database installed on another server, and the this does not happen.

I forgot to mention that I am using Report Manager to deploy the reports.

Please assist.

Just checking if anyone has any additional info on this. I'm having the same problem. SQL Server 2005 (SP2), Reporting Services 2005 (SP2).

Any help is appreciated as this is a major usability issue.

|||I am also experiencing this issue.|||I think microsoft fixed this. In vista64/sql64 there is no back button......that I can find.|||This thread is talking about the browser (internet explorer) back button.|||

Can someone from Microsoft please chime in on this issue. If you hit the browser back button from IE from a drilled/jump to report, the original report is not shown. The "Report is being generated" screen just sits there. This is a huge usability issue.

Also, can someone from Microsoft point me to where we're supposed to find out when/if an upcoming SP/hotfix is going to come out and what is included. I want to move our reporting system to Reporting Services but the above issue is one of the reasons I can't.

|||

I am also getting this on multiple machines and databases. I can recreate it starting with 2 simple reports, the main report and a drill down report. The browser back button tries to bring up the original report, but never finishes. I noticed there is always an HTML error on the report that goes away if you click refresh. (Note: The error only shows up if your browser is set to show errors). I am using SQL Service Pack 2 and IE7. The error I get is:

Line: 718

Char: 5

Error: 'location' is null or not an object

Code: 0

URL: ......

|||

I am having this problem too, since we moved to SQL 2005 64-bit,sp2.

With certain reports that are hyperlinked to other reports, pressing the IE back button (to return to the previous report) goes into the endless 'Report is being generated, green spin'. Only by clicking on the report's toolbar refresh button does the report re-display.

This appears to be a problem only with the combination of SQL 2005 64-bit and IE 7. Everything works great! with SQL 2005 32-bit and IE 6 or 7 and even using SQL 2005 64-bit with IE 6. The problem seems to be in IE 7 when SQL 2005 64-bit is the backend database. Any help or advice would be greatly appreciated!

Sam

|||

Are all of you using the 64-bit version? I am using the 32 bit version with IE 7 and have never experienced that problem.

I experience a problem with report viewer where I drilldown into a report and click the next page button. Then mysteriously the parent report displays. It's odd, but not too big of a deal to me.

|||We are on the 64-bit version.

Back button does not regenerate original report

When I drill down from one report to another and then depress the back button to return to the initial report, the message 'Generating Report" spins forever without actually running. However, if I depress the regenerate button during this time, it will run the report.

I believe that I may have inadvertingly reset a field attribute to have caused this condition. Ironocally, I have the same set of database installed on another server, and the this does not happen.

I forgot to mention that I am using Report Manager to deploy the reports.

Please assist.

Just checking if anyone has any additional info on this. I'm having the same problem. SQL Server 2005 (SP2), Reporting Services 2005 (SP2).

Any help is appreciated as this is a major usability issue.

|||I am also experiencing this issue.|||I think microsoft fixed this. In vista64/sql64 there is no back button......that I can find.|||This thread is talking about the browser (internet explorer) back button.|||

Can someone from Microsoft please chime in on this issue. If you hit the browser back button from IE from a drilled/jump to report, the original report is not shown. The "Report is being generated" screen just sits there. This is a huge usability issue.

Also, can someone from Microsoft point me to where we're supposed to find out when/if an upcoming SP/hotfix is going to come out and what is included. I want to move our reporting system to Reporting Services but the above issue is one of the reasons I can't.

|||

I am also getting this on multiple machines and databases. I can recreate it starting with 2 simple reports, the main report and a drill down report. The browser back button tries to bring up the original report, but never finishes. I noticed there is always an HTML error on the report that goes away if you click refresh. (Note: The error only shows up if your browser is set to show errors). I am using SQL Service Pack 2 and IE7. The error I get is:

Line: 718

Char: 5

Error: 'location' is null or not an object

Code: 0

URL: ......

|||

I am having this problem too, since we moved to SQL 2005 64-bit,sp2.

With certain reports that are hyperlinked to other reports, pressing the IE back button (to return to the previous report) goes into the endless 'Report is being generated, green spin'. Only by clicking on the report's toolbar refresh button does the report re-display.

This appears to be a problem only with the combination of SQL 2005 64-bit and IE 7. Everything works great! with SQL 2005 32-bit and IE 6 or 7 and even using SQL 2005 64-bit with IE 6. The problem seems to be in IE 7 when SQL 2005 64-bit is the backend database. Any help or advice would be greatly appreciated!

Sam

|||

Are all of you using the 64-bit version? I am using the 32 bit version with IE 7 and have never experienced that problem.

I experience a problem with report viewer where I drilldown into a report and click the next page button. Then mysteriously the parent report displays. It's odd, but not too big of a deal to me.

|||We are on the 64-bit version.

Back Button : Going back to parent report from the child report in Report Manager screen

Hi,
In my report manager screen, i want to place the back button option by which user can navigate to the parent report?
For example, I am viewing the orders screen(parent report), in that screen i am clicking the orderid column, it navigates to another report(child report), from which i want to go back to parent report..
I am not using the reportviewer control...
i am using only the report manager....
is it possible?
how do we achieve this?

thanks in advance

Have you figured a way to do this? I am trying to do the same thing.

Thanks,

|||It is possible using Jump To Report functionality

Back Button : Going back to parent report from the child report in Report Manager screen

Hi,
In my report manager screen, i want to place the back button option by which user can navigate to the parent report?
For example, I am viewing the orders screen(parent report), in that screen i am clicking the orderid column, it navigates to another report(child report), from which i want to go back to parent report..
I am not using the reportviewer control...
i am using only the report manager....
is it possible?
how do we achieve this?

thanks in advance

Have you figured a way to do this? I am trying to do the same thing.

Thanks,

|||It is possible using Jump To Report functionality

Back button

I have tried to open a report which has a parameter. It renders the report, but when I click the back button
it takes me back to the page where I can enter the parameter value and view the report.
I want to avoid this. When I click the back button it should automatically go back to the page I came from.
Any ideas?
protected void LinkButton1_Click(object sender, EventArgs e)
{
Response.Redirect("http://servername/ReportServer?%2ffolder1%2ffolder2%2fMyReport&empType=2");
}You'd have to hit back twice i'd believe. Since the report results is from postback.|||Thats what I wanted to avoid. I don't want to hit back button twice. Any workaround?|||You could render the report on the server side using the SSRS Web Service and just display the results there. I think that would do the trick. But you probably won't be able to enter other parameters.|||Could you elaborate more on this.. what is SSRS Web Service? Could you please explain.|||You use .net code to render the report and write it to the screen. There is a web service that comes with reporting services that allows you to do this.|||

I think you are talking about the code as below.. But I don't want to specify the format.

I want the users to select the format.

// Render arguments
byte[] result = null;
string reportPath = "/My Reports/ReportSample";
string format = "HTML4.0";
string historyID = null;
string devInfo = @."<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";

// Prepare report parameter.

DataSourceCredentials[] credentials = null;
string showHideToggle = null;
string encoding;
string mimeType;
Warning[] warnings = null;
ParameterValue[] reportHistoryParameters = null;
string[] streamIDs = null;
SessionHeader sh = new SessionHeader();
rs.SessionHeaderValue = sh;

try
{
result = rs.Render(reportPath, format, historyID, devInfo, parameters, credentials,
showHideToggle, out encoding, out mimeType, out reportHistoryParameters, out warnings,
out streamIDs);
sh.SessionId = rs.SessionHeaderValue.SessionId;
Debug.Write("SessionID after call to Render: {0}",
rs.SessionHeaderValue.SessionId);
Debug.Write("Execution date and time: {0}",
rs.SessionHeaderValue.ExecutionDateTime);
Debug.Write("Is new execution: {0}",
rs.SessionHeaderValue.IsNewExecution);
}
catch (SoapException ex)
{
Debug.Write(ex.Detail.OuterXml);
}

|||

You can still achieve that. Just set some sort of variable for the format and pass it in as a parameter.

string format = "HTML4.0";

It can be "PDF", "EXCEL", "CSV", "HTMLOWC", and a few others. Just give the users a drop-down of the various choices and pass it as a parameter to the page that renders the report.

|||

Go here:

http://forums.asp.net/thread/1412563.aspx

For code if you wish.