Error "Operation is not valid due to the current state of the object"

Question

I'm trying to use the ReportViewer control (in remote mode) in a winform app. Everything works great until I try and change the ReportPath of the control (in response to a TreevIew after select event ) when the currently visible report is a report that has been drilled into from the original report specified in ReportPath e.g.

ReportViewer rv = new ReportViewer();
/* other code */
rv.ServerReport.ReportPath = "/Report1";
rv.RefreshReport();

User then clicks on a link in Report 1 that jumps to Report 2 (still within the same control).

Now if you try and set the ReportPath to anything you get an "Operation is not valid due to the current state of the object" being thrown by the internal set_ReportPath method. As long as the ReportViewer control is showing Report1 all is well (for example if the user drilled down and them navigated back to the top level report). Is there something I should be doing differently? The only way round this at the moment is to create a new ReportViewer control everytime a different node is selected in the treeview which seems wrong as all I want to do is change the report path and parameters for the existing control.

Answer 1

While you are in a drillthrough report, the LocalReport object represents the drillthrough report - the value of the report path, parameters, etc.  Conceptually, you can't change this report, it was defined by the parent report.  If you could, it would leave the back button enabled on the toolbar, which doesn't really make sense.  The correct thing to do is first call ReportViewer.Reset().  This will reset the report stacks and allow you to set a new definition.

Answer 2

Thanks Brian, that worked perfectly

 

Answer 3

For the webform control there doesn't seem to be a Reset method but what I have done is just called the PerformBack method recursively to get back to the top level before modifying the report path. Is that the correct approach ? e.g.

    private void GetBack()
    {
        if (rv.ServerReport.IsDrillthroughReport)
        {
            rv.PerformBack();
            GetBack();
        }
    }

    private void ShowReport(String instance)
    {
        GetBack();
        rv.ServerReport.ReportPath = RPT_INSTANCE_SUMMARY;
        ReportParameter rp = new ReportParameter("instance", instance, false);
        rv.ServerReport.SetParameters(new ReportParameter[] { rp });
    }

 

Answer 4

That approach will work.  You could also swap out instances of the report viewer on the form, though it will require you to set property values on the viewer control again:

ControlCollection coll = oldViewer.Parent.Controls;
int oldIndex = coll.IndexOf(oldViewer);
ReportViewer newViewer = new ReportViewer();
coll.AddAt(oldIndex, newViewer);
coll.Remove(oldViewer);

Answer 5

Thanks Brian, just wanted to make sure I wasn't missing something (again)

Answer 6

I'm sorry, but why in the world is there no .Reset() method on the WebForms viewer?  Having to do this is ridiculous, especially given the fact that this method exists on the WinForms viewer.

Answer 7

I'm having the same problem as well.  The GetBack() method is working about 95% of the time, however i still will get an error occasionally, it would be nice if there was a reset() method to call and solve all my problems.

Answer 8

We are aware of this limitation and the problems it is causing people.  We hope to address this soon in an update.

Answer 9

We were using the following code to get back to the parent report in the web application.

But if we keep the session idle for more than 6 min(if we do with in that time period it works perfectly), SSRSReportViewer.PerformBack(); will throw an error

"This operation can only be performed on drillthrough report".

protected void btnBack_Click(object sender, EventArgs e)

{

GetParentReport();

SSRSReportViewer.ServerReport.ReportPath = "/" + ReportFolder + "/" + this.ReportName.ToString();

SSRSReportViewer.ServerReport.Refresh();

}

private void GetParentReport()

{

if (SSRSReportViewer.ServerReport.IsDrillthroughReport)

{

SSRSReportViewer.PerformBack();

GetParentReport();

}

}

Answer 10

Any update on when this method will be added to the web version of the Report Control? 

The hack works OK, but as Thambu states, the PerformBack method will throw an exception ("This operation can only be performed on a drillthrough report" - even when it is a drillthrow report and the IsDrillthroughReport property is true), if the page is idle for a couple of minutes...

Answer 11

The method is added in Visual Studio 2005 SP1.

Answer 12

When will SP1 be released?

Answer 13

Here is the hacky way I worked around this shortcoming.  If setting the report path fails I call PerformBack() and then try setting the report path again.  If I'm 5 levels deep this still works.  I will rip this code out as soon as .Reset() is availiable.

bool l_bRetry = true;

   while (l_bRetry)
   {
    try
    {
     m_viewer.ServerReport.ReportPath = m_reports.SelectedItem.Value;
     l_bRetry = false;
    }
    catch
    {
     m_viewer.PerformBack();
    }
   }

Answer 14

A more elegant way to do that is:

while (m_reportViewer.ServerReport.IsDrillthroughReport)
 m_reportViewer.PerformBack();

Answer 15

The latest information on SP1 is available at: http://msdn.microsoft.com/vstudio/support/servicing/

Answer 16

Hi Brian,

I'm able to view sample AdventureWork reports in Report Designer Preview mode but not over the browser when I deploy the same. The error that I get is:
Operation is not valid due to the current state of the object.

Appreciate any help on this.

Thanks.

Answer 17

 

Hi,

       I am praveen. I am new to .net.I am designing a website which needs to displays reports . I used Report Viewer which is in Update Panel control to display Reports.We have many some Reports with child reports.

      The navigation from Parent Report to Child Report and vice-versa is working fine only through the BACK button provided by report viewer.As this button navigates us to only the previous page but not the previous report its a flaw to our functionality.

 In the child report we added a functionality, by adding a 'Back ' link button, to return to parent report as per the requirement .  

On navigating through this 'Back' link button I am getting this error "Operation is not valid due to the current state of the object." while re-running the same report again or running other reports i am facing this problem .Can any one help me out in this problem. 

  

Answer 18

 

Works like a champ, Thanks Brian.

 

Bhushan