Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Custom SSRS Report not working in CRM 2011 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    HI

    I can see alot of thread with the same issue as mine, but none of the solution works for me :(

    I developed a SSRS report in BIDS. When I run the report in preview everything works. If I try to use the queries from the dataset directly in the database, they work. The DataSource test connection is succesfull.

    BUT if I import the rdl file into my test CRM, and tries to run the report I get the change to insert parameters but afterwards it just show me the first columns headline and no data at all.

    If I instead tries to import the report into my clients enviroment I get the dreaded "Report cannot be displayed
    RsProcessing aborted" .

    I've looked at these threads with out a solution to my problem:

    Report link 1

    Report link 2

    I'm really beginning to stress out here, so any help is welcomed!

    Tuesday, March 25, 2014 8:18 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi

    As mentioned in one of the threads - did you install the SSRS Data Connector?

    Tuesday, March 25, 2014 8:21 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Casper,

    You are referred to the blog post By Ashwani Ashwin and By Donna Edward.

    Hope the above links will work for you.

    Tuesday, March 25, 2014 8:32 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    On the test CRM enviroment the SQL and CRM is on the same server and other custom reports works

    On the clients enviroment, 20 other custom reports works

    Tuesday, March 25, 2014 9:20 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I'll look into this right away
    Tuesday, March 25, 2014 9:21 AM