Category Archives: SSRS 2008

Differences between SSRS 2008 and SSRS 2008 R2 Report Data Sources

If you are running SSRS 2008 SP1 for your reporting needs, here is the quick comparison of SSRS 2008 SP1 and SSRS 2008 R2 report data sources. If you need to access SharePoint Lists and Azure databases from the SSRS … Continue reading

Posted in SP2010 & SSRS, SSRS 2008, SSRS 2008 R2 | Leave a comment

Repeating Table Header on Each Page of the Report in the SSRS 2008

In the SSRS 2008, if a report with a tablix is created without using the wizard feature (Reports -> Add -> New Item -> Report), table headers won’t repeat on every page by default when you print or export or print preview the report. … Continue reading

Posted in SSRS 2008 | Leave a comment

Configure all domain users to browse the SSRS Reports

Every time I had configured the SSRS folder structure and security, one common task I been configuring is adding all the domain users to the SSRS folder, data source, model, or report item. Assign the “Browser” role to the “NT AUTHORITY\Authenticated … Continue reading

Posted in SSRS 2005, SSRS 2008, SSRS 2008 R2 | Leave a comment

Step by Step: Consuming MOSS 2007 Lists Data in the SSRS 2008 Reports

One of the biggest limitations of the SSRS 2005 and SSRS 2008 integration with the MOSS 2007 in the native mode or integrated mode is there are no intuitive ways to report against the SharePoint lists into the Reporting Services … Continue reading

Posted in SSRS 2008 | 1 Comment

Advantages and Disadvantages of SharePoint Integrated SSRS Environment

I have been asked many times whether Native Mode SSRS or SharePoint Integrated SSRS configuration will work in given situation if organization has adpoted both MOSS and SSRS to address their business problems. As with most of all Microsoft technologies, … Continue reading

Posted in SP2007 & SSRS, SP2010 & SSRS, SSRS 2005, SSRS 2008, SSRS 2008 R2 | Leave a comment