SSRS Report runs in BIDS / Not in SharePoint

  • Hi geniuses

    How come a report runs in BIDS, but not when deployed to SharePoint 2010.

    No problems with the query, the DataSource is configured correctly.

    The report have 6 parameters.

    Have u faced something similar?

    Thanks in advance.

  • Maybe a permission issue.

    Any errors?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Doesn't seem to be a permission error, we already deployed reports before and everything works fine.

    No errors, thats why its weird.

    I'm recreating the stored procedure, along with the report itself.

    I have really no idea what could cause this.

  • What exactly are you seeing? just a blank report? No data being returned? You may want to run a profiler trace to see what is being executed on the backend against the data database.

  • if you have parameters and have deployed the reports previously. Then any changes you make to the parameters such as default values etc.. will not be over-written. Maybe this is why your reports are not showing any data.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply