web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

SSRS report won't export

(0) ShareShare
ReportReport
Posted on by 912

crm 2011 ru 14, sql server 2008 r2 sp1. Crm on server A, sql and ssrs on server B. Running a custom report, fires from crm ok. When i try to export it fails with a 'object variable not set...' erro which when i check on the server is : The report execution xxxx has expired or cannot be found. (rsExecutionNotFound). However when i run the report directly from the ssrs server using the user id and org id guids then i can export ok. The app server and sql server are not running as the same id but i'm still confused as to why that would be a problem as it's using the data connector to make the connection. There's no timeout (its a very simple report) Help!

*This post is locked for comments

I have the same question (0)
  • Mamatha Swamy Profile Picture
    5,426 on at
    RE: SSRS report won't export

    Can you enable remote errors and check for specific error? Refer technet.microsoft.com/.../aa337165(v=sql.105).aspx

  • Community Member Profile Picture
    on at
    RE: SSRS report won't export

    check this blog

    www.ryanjadams.com/.../report-execution-has-expired-rsexecutionnotfound

  • PhilKermeen Profile Picture
    912 on at
    RE: SSRS report won't export

    The reported error is the full error - written to the event viewer and reported back through CRM tracing. You don't see it directly (in ssrs) as  the report viewer redirects to a new page showing the crm error of 'object variable not set...' There's nothing reported in the reporting services log file, beyond the info for the report when it displays correctly in the viewer (RenderForNewSession)

  • PhilKermeen Profile Picture
    912 on at
    RE: SSRS report won't export

    Its a tiny report - it also does this on other standard reports in crm so a timeout is not an issue.

  • Community Member Profile Picture
    on at
    RE: SSRS report won't export

    Goto SSMS -> log into to Report Services -> Right click on the instance and select Property -> Advanced -> Enable Remote Errors to true.

    After setting the above property, you will get more detailed error message

  • PhilKermeen Profile Picture
    912 on at
    RE: SSRS report won't export

    I've made that change and restarted the service - you don't get to see any additional error detail by switching that on, it just shows errors to remote clients.

  • Community Member Profile Picture
    on at
    RE: SSRS report won't export

    can you post your sql statment?

  • PhilKermeen Profile Picture
    912 on at
    RE: SSRS report won't export

    It happens on all reports, sql is not the issue.

  • Community Member Profile Picture
    on at
    RE: SSRS report won't export

    are you using filteredtable or table?

    like crm ssrs will work "filteredcontact" table, if you use "contact" table, then you will get error.

    Check your sql.

  • PhilKermeen Profile Picture
    912 on at
    RE: SSRS report won't export

    Like i mentioned all the reports do it and i'm using the filtered views.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
UllrSki Profile Picture

UllrSki 2

#3
SC-08081331-0 Profile Picture

SC-08081331-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans