Execution ID Is Lost After Pressing The Back Button (drill-through Reports)

Dec 12, 2006

Hi there,

I'm using the reportviewer control to display a drill-through serverreport. Here is the code in my code-behind file:

Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init

Dim strReportPath As String = "/Public Reports/adfront/dealermodel/myreportname"

Dim paramUniqueID As New ReportParameter()

If Not Page.IsPostBack And Me.ReportViewer1.ServerReport.IsDrillthroughReport = False Then

Session("uniqueid") = Request.QueryString("uniqueid").ToString

'Set the report server URL and report path

Me.ReportViewer1.ServerReport.ReportServerUrl = New Uri("http://localhost/reportserver")

Me.ReportViewer1.ServerReport.ReportPath = strReportPath

Me.ReportViewer1.SizeToReportContent = True

Me.ReportViewer1.AsyncRendering = False

Me.ReportViewer1.ShowBackButton = True

Me.ReportViewer1.ShowFindControls = False

Me.ReportViewer1.ShowPageNavigationControls = False

Me.ReportViewer1.ShowParameterPrompts = False

Me.ReportViewer1.ShowPromptAreaButton = False

Me.ReportViewer1.ShowZoomControl = True

Me.ReportViewer1.ZoomMode = ZoomMode.FullPage

'Set the processing mode for the ReportViewer to Remote

Me.ReportViewer1.ProcessingMode = ProcessingMode.Remote

'Set the report parameters for the report

paramUniqueID.Name = "uniqueid"

paramUniqueID.Values.Add(Session("uniqueid"))

Dim parameters() As ReportParameter = {paramUniqueID}

Me.ReportViewer1.ServerReport.SetParameters(parameters)

End If

Me.ReportViewer1.ServerReport.Refresh()

End Sub



Protected Sub ReportViewer1_Drillthrough(ByVal sender As Object, ByVal e As Microsoft.Reporting.WebForms.DrillthroughEventArgs) Handles ReportViewer1.Drillthrough

While (Me.ReportViewer1.ServerReport.IsDrillthroughReport)

Me.ReportViewer1.PerformBack()

End While

'Me.ReportViewer1.ServerReport.ReportPath = e.ReportPath

'Me.ReportViewer1.ServerReport.GetParameters()

Me.Label1.Text = Me.ReportViewer1.ServerReport.ReportPath

End Sub

When I drill-through the report and hit the (browser) back button and try to drill-trough again I get the following error:

The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)

When I hit back again and try to export the report to eg. PDF, I get this error:
Execution 'mly2yj555oen0o45oowe1e55' cannot be found

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: Execution 'mly2yj555oen0o45oowe1e55' cannot be found

Source Error:





An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:





[Exception: Execution 'mly2yj555oen0o45oowe1e55' cannot be found]
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +553
Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +941
Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection urlAccessParameters, String& mimeType, String& fileNameExtension) +97
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +126
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +153
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +202
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64





Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

It looks like my executionid is lost on the reportserver. Does anybody knows how to fix this, so my users can use the browser back button?

Many thanx!

Ralph

View 1 Replies


ADVERTISEMENT

Back Button For Drill Down Reports

May 12, 2007

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,

View 2 Replies View Related

Reporting Services :: ReportViewer 10.0 - Pressing Browser Back Button

Jan 31, 2011

We recently upgraded from ReportViewer 9.0 to 10.0 Control in our ASP.NET application, and face some strange issues after the upgrade. When we press the Back button to go to a page that was rendering a report with one or more single-select drop down lists, the selected index in the drop down is reduced by 1, and the report doesn't render until I press "View Report". I verified that exact same setup works well with ReportViewer 9.0.

View 2 Replies View Related

Reporting Services :: SSRS Drill Through Back Button In Web Page

Oct 1, 2015

I have integrated my SSRS Drill though report in Web page and i could not able to find back button to go back to the original report. Unfortunately, i am not controlling the report viewer tool bar.Do we need to write some code to get it working.

View 2 Replies View Related

Crystal Reports - Drill Down Lost

Dec 1, 2006

I've been able to insert a graph in my reports which automatically allow drill down (into the graph). This has stopped working on new reports and I can't see why, or how to allow drill down (in graphs) again. Anyone help? I'm using Crystal Developer Ver9.2. Thanks

View 1 Replies View Related

DB Engine :: Server Service Did Not Start After Pressing Restart Button

Aug 20, 2015

we had activity last night we need to truncate Transactional Logs we pressed Restart button to initiate service , but it stopped successfully and failed to start the SQL Server service.We did not find anything find anything unusual in log file. Please confirm are we facing any bug or needing any fixes to installed on the server.Windows Server 2008 R2 Standard Service Pack 1  ( 64bit)

View 6 Replies View Related

Drill-down Button Shows Wrong Image

Jan 10, 2008

I've got a drill-down report in a table. There's a group set to hidden = false, and a textbox set as its toggle. When I view the report, the data in the group displays properly (it's not hidden), but the toggle icon is a "+", when it should be a "-". When I click the toggle, the group is hidden and the toggle icon changes to a "-".

I'm left clicking "+" to get less information and "-" to get more information, it's all backwards!

Has this bug been fixed? Is there a work-around?

View 7 Replies View Related

Reporting Services :: Run Two Reports Back To Back Without Page Eject?

Jun 9, 2015

I need to run two reports each of A5 Size to run back to page and print on single A4 paper means in 1st half Sale bill will be printed and in second half Gate Pass Will Be Printed both report will be on same page and size and shape should be maintained. How to do it.

View 4 Replies View Related

Back Button

Jun 2, 2008

Hello.
When I'm useing a report in reportViewer I have a "back button" in the the viewer which let me go back to my parent report after jumping to another report.

I wanted to make a bigger button like that on the report so I tried to simulate it by creating my own textback and use a javascript to go back one page.

This doesn't work since the javascript doesn't work as well as the built in bottun.
Is there a way to simulate this button any way?

Thanks.

View 2 Replies View Related

What Are The Limitations Of Using The Browser's Back Button?

Dec 27, 2007

I've noticed on SSRS 2000, 2005 and 2008 that the browser's back button does not always render the report. It will sometimes hang with the rendering icon spinning essentially forever. Is there a limitation that can be tuned which would allow my users to return to the previous report or 'view' they were looking at using the back button?


Thanks

View 2 Replies View Related

How Can I Get Back The Lost View?

Dec 25, 2006

Hi,

I am a newbie working on MS Sql Server 2000 for a while. I accidentally deleted a view through Query Analyzer and want to get it back. All data are backed-up every day but there are a lot of red tapes I have to go through in order to draw the lost view from the backup. Indeed, a different division is taking care of backups in our organization and they don't want to spend time on my issue.

I'm wondering if there is an automatic logging capability of sql server showing modified/ deleted/ updated data objects on daily basis with their contents that can be accessed later on. Or is there another recovery mechanism that can be used to get back the lost view?

Thanks for your attention to this matter,

Batuhan

View 5 Replies View Related

Back To Parent Report Button Not Visible

Jun 8, 2006

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

View 23 Replies View Related

Back Button Does Not Regenerate Original Report

Feb 28, 2007

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.

View 12 Replies View Related

Using Back Button In PrintLayout Mode Causes Crash

Feb 26, 2007

I'm using a number of drill-through reports, which are working great. However, if I have drilled through to another report (enabling the back button) and then go into print layout mode, and click the back button while in print layout mode, the report viewer becomes completely unresponsive.

It's easy enough for me to simply not push the button, but if users encounter this error they'll have no choice but to end-task (crashing the viewer and the application that called it), which could result in loss of unsaved data.

Has anyone else run into this problem/discovered a fix for it?

Thank you,

Jeff

View 1 Replies View Related

Back Button Does Not Regenerate Original Report

Feb 27, 2007

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.

View 2 Replies View Related

Reporting Services Add (browser) Back Button

Jun 7, 2007

Dear all,



I have a client that has 4 reports; 1 main, and 3 that are rendered when the user clicks the report data on the main report (which passes parameters to generate the other 3).



They would like to have a back button in the report header of the 3 reports (they don't want to use the browser back button).



Is this possible using a text box, then editing the navigation properties and does anyone have an example? Or am I missing something quite obvious?


Any help would be gratefully received!!



Dan

View 6 Replies View Related

About Drill Down Reports(on 7th)

Mar 7, 2008



Hi all,What is Drill Down Reports in Reporting Servies.How can i design Drill Down Reports.
Give me any example to desing Drill Down Reports.
Regards.

View 5 Replies View Related

Drill Through Reports

Feb 21, 2007

Any way to have the drill through report open in a new window on the web?

View 4 Replies View Related

Drill Down Reports

Sep 11, 2007



Hi all

is it possible make drill down reports in crystal
my requirement is like
i have n rows in my report
if am clicking the first column in first row it will list details of that row in between first and second row
Same for all the rows

Quick reply is appreciated

Regards
Rameez

View 2 Replies View Related

How To Create Drill Down Reports?

Nov 21, 2007

Hi All,
Am new to Reporting Services. I need to create some drill down reports. Am unable to find any guidance or tutorials. Anyone please help me to create drill down reports

Thanks in advance

Regards
Nataraj.C

View 3 Replies View Related

Help Me To Create Drill Down Reports

Nov 21, 2007

Hi all,
Am new to SQL Server Reporting services. I need to create some Drill down reports. Am unable to find any guidance or tutorials for that. Please help me to create variety of drill down reports.

Thanks in advance.
Regards
Nataraj.C

View 2 Replies View Related

Drill Through Reports In RS2005

Jul 23, 2007

How do I drill through to a report from a report that's in a different directory? In the designer I can only drill through to reports that are in that project. I'm sure that there is a simple solution (hopefully!).

View 1 Replies View Related

Collapse Button In SQL Reports

Jun 23, 2007

I am working with SQL reporting services, I am getting the data dispalyed...

the only problem is that I am not able to collapse, ie (+) button next to the row header and the cloum header.

Can any one let me know, how to get that....

Thnks in adv.

View 1 Replies View Related

StreamNotFoundException In Reports With Drill And Images

Feb 28, 2007

Hi,

I always have this exception:

w3wp!library!1!02/28/2007-13:50:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database.

When i try to drill in a report that have images.

The weird is that i only have this error when i view this report in ReportViewer in a .aspx page. When i try to enter in this report directly by using the ReportServer ( http://server/Reports ) i dont have this error.


what is wrong ?

cya

View 9 Replies View Related

How To Make Drill Through Reports In SSRS

May 20, 2008



Hi All,

I want to know How to make Drill Through Reports in SSRS ?

Please Suggest.

Ritesh Kumar

View 5 Replies View Related

Can We Drill Down Reports In A Another Different Pages With Different Layouts?

Apr 16, 2007

Hi, all experts here,

Thank you for your kind attention.

I am wondering if we can drill down reports in a different page with different layouts and columns? e.g. I have too many columns desired to see in a report, so I want to direct the users to another page with different layouts and columns, so the first view in the report wont display so many columns in a page. Is it possible to make it in SQL Server 2005 Reporting Services? And if it is possible then how? Hope my question is clear for your help.

Thanks a lot in advance and I am looking forward to hearing from you.

With best regards,

Yours sincerely,

View 5 Replies View Related

Steps To Create Drill Through Reports(on 11th)

Mar 11, 2008



Hi all.
Any body give me one example,how to create drill Through reports in Reporting Services.

Regards.

View 5 Replies View Related

Drill Through To Reports Located In Multiple Folders

Feb 28, 2008

Report A contains a textbox that should navigate to Report B using the Jump To option. Report A and Report B are located in separated folders on the Reporting Server.

SSRS looks for the rdl file within the same folder when using the Jump To option. Is there away to navigate to a report located in a different folder on the same server?

Thanks

View 1 Replies View Related

Adding Interactive Sort In Drill Down Reports.

Dec 20, 2007



Hello,

I have a drill down report and would like to add interactive sort on two columns:- column 1 & column 2. These two columns should be in descending order. By adding this, when user's click on column 1 they will see the data based on the sorted order.
Does anyone help me on this issue.

Thanks,
BL

View 5 Replies View Related

Drill Down Reports In Reporing Services 2005(on 10th)

Mar 10, 2008



Any body pls tell me steps to create Drill Down reports in Sql Server 2005 Reporing Services.

If possible give me one example to create Drill down Reports.

Regards.

Naren

View 5 Replies View Related

Reports Containing Drill Through Interactive Bar Charts Not Working Properly When Deployed

Feb 9, 2006

Hi all,

Drill through bar charts work great in the report designer preview, but as soon as I deploy the report, and view the report in a webpage, drill through does not work smoothly.

I have to move the mouse around to be able to find a place on the bar to click through to the next report. Sometimes, I am able to click on the bar to go to next report, but then sometimes I have to click on the label, and other times somewhere in the vicinity of the label.

Any help will be much appreciated.

Thanks,

Kanwal

View 1 Replies View Related

Enabling Automatic ClickThrough/ Drill Into For Report Builder Reports Against A Model

Apr 4, 2007

Hello - I am having difficulty enabling the automatic click-through functionality for my model. I have two entities - Customer & Incident. Incident is a role/FK/OptionalMany relationship to customer.



I've read through earlier postings on this subject (below) and have verified that the #Incidents attribute in my incident entity has the EnableDrillThrough=true.



My test report is simple - Customer Name (from customer) and #Incidents (from incident). When I run it, the click-through option is not available (the cursor stays as an arrow and doesn't change to a finger).



Are there other properties or settings that I need to be working with? I have SP2 (9.0.3042) installed on our Standard edition of SQL 2005. I know Infinite Click-Through is not in Std edition, but a few levels should be, correct?



Thanks in Advance,

Toni



Other related postings -

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1260819&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=657279&SiteID=1

View 4 Replies View Related

Reporting Services :: Interactive Sorting With Drill Down Reports In Report Builder 3.0

Aug 20, 2015

I am using Report Builder 3.0 and i have report which has a drill down group. The report opens in a collapsed form.This report has interactive sorting on a column. But,when we drill down and sort the column, the group collapses and the details disappear.

In some posts, i have seen that instead of interactive sorting, people recommended a parameter. But i have to do interactive sorting only.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved