Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Report runs in BIDS / Not in SharePoint Expand / Collapse
Author
Message
Posted Thursday, July 25, 2013 5:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668

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.
Post #1477432
Posted Thursday, July 25, 2013 5:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:27 PM
Points: 12,185, Visits: 9,134
Maybe a permission issue.
Any errors?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1477435
Posted Thursday, July 25, 2013 5:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668

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.
Post #1477441
Posted Friday, July 26, 2013 4:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:43 PM
Points: 234, Visits: 2,614
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.
Post #1477933
Posted Friday, July 26, 2013 5:12 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, March 15, 2014 4:31 AM
Points: 2,808, Visits: 7,173
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.

Post #1477941
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse