.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Where are the 2008 SSRS sample reports?

Posted By:      Posted Date: September 04, 2010    Points: 0   Category :Sql Server
All the CodePlex 2008 links now go to the 2008R2 examples. Are the 2008 report samples still around somewhere?

View Complete Post

More Related Resource Links

Schedule reports with integrated authentication SSRS 2008

Hi All,  Having an issue with SSRS 2008 at the moment, trying to setup subscriptions. Our system is configured so that any one of 10 users can login to the SSRS website using their windows domain account, and then launch report builder to design and save reports.  This all works very well, however, they have a problem when trying to setup subscriptions - the famous "Subscriptions cannot be created because the credentials used to run the report are not stored....." What the message says is true - the credentials are not stored as they are supplied by the user when they login to report builder. Is the /any/ workaround at all that doesn't involve storing the credentials?  It seems totally crazy that they cannot be prompted for them when setting up the subscription.  For this application its 100% essential to make the user provide their credentials when running reports, because they each see a filtered subset of the data in the report model (this is controlled DB side depeding on the login account), so their domain account needs to be passed to SQL server to enable this filtering to work.  If we saved their credentials then they would see all the data..and thats nasty. The only workaround I can come up with would be to create  a separate datasource for each user and upload a separate model, but thats really nasty to be hones

SSRS 2008 SP1 - Enabling "My Reports" allows users delete reports in folders they should not be able

Issue: Users that have “My Reports” SSRS Role assigned to them can delete reports in other “shared” folders. My understanding was that they will be able to do the tasks specified only  in the “My Reports” workspace not everywhere. I have “My Reports” enabled via SSMS. Users have “My Reports” role assigned to them at the root level. My SSRS Role “My Reports” has only the following tasks assigned: 1.       View Reports 2.       Manage reports 3.       View Folders 4.       Manage Folders To test, I'm using Development version of SQL Server 2008 SP1. Thanks in advance, Martina

SSRS 2008- redirect to /Reports virtual directory?

We have just configured a new SQL Server Reporting Services 2008 server. So far, everything is going well, with the exception of one thing: we want anyone who hits the root of the webserver to be redirected to the /Reports virtual directory. So, if the user enters http://servername.domain.com/ it would redirect to http://servername.domain.com/reports. In SSRS 2005, it was easy to configure IIS to do this, but with SSRS 2008, I cannot figure out how to make this change. Help?

Are there workarounds for SSRS 2008 Reports that have issues in SSRS 2008 R2

We have some SSRS 2008 reports which have a few issues in SSRS 2008 R2: - Page Numbering: Our reports use [PageNumber] of [TotalPages] however, in R2 [Total Pages] only relates to a particular section.  Do we really need to update every single report in design mode to use [OverallTotalPages]?  Is there a workaround? - Report Rendering: Each page of a report is only rendered when each new page of the report is requested.  How do we prevent this is R2? - Missing Data: If we run a report that should have 50 pages of data, not all pages are shown when viewing the report.  For example, only 2 pages might show.  However, if we export to PDF the whole 50 pages are exported.  Does anyone know why this is happening? Looking for patches, workarounds, etc.  Hoping that we don't need to upgrade desktops to R2 and edit hundreds of reports to fix these issues. Thanks, Howie999

SSRS 2008 Against OLAP Cube reports rendering slow in IE 6 and IE8

We have SSAS cube built on SQL Server 2008 that has multiple parameters that have a default vault on running of all. The first time we run the report it renders the report in less than 30 seconds, but when we change one value on the data cube pull the reports can take up to 5 mins to run. If I do the same report in Firefox 3.6 it renders the report in 30 seconds. I have change changing the cache size in the IE explorer and ave the latest .net frame work on the computer. What would be causing this issue? The company upgrade from SSRS, SSIS, SSAS, SQL 2005 to 2008. Please advice, this is very annoying for our business end users.   Thanks for your help in advance.

Deploying SSRS Reports from Visual Studio 2010 to Report Manager 2008


Our Report server is using Report Manager 2008. Previously I would load reports to it that I created via BIDS. Now I have to use VS 2010. I see that I can build and deploy reports there. Can I send it from VS 2010 to the REport manager 2008 on the other machine? I should add that now i have to develop on laptop only before i was on the server.

If not what are my options? I recall that vs 2005 objects were not taken in Report manager 2008.

SSRS 2008: Multiple Sub-Reports with conditional visibility in one List control


MainReport: a List containing two Sub-Reports. The data of the List only has two rows. Set the visibility of the sub-report based on the data.

SubReport1: a textbox showing "Sub Report 1"

SubReport2: a textbox showing "Sub Report 2"

I expect to see SubReport1 in Page 1 and SubReport2 in Page 2.

But I only see SubReport1 in Page 1 and Page 2 is a blank page.

These reports work in SSRS 2005, but not in SSRS 2008.



Report Definition:



<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner

SSRS 2008 - email subscription - 7 minute delay between two reports emailed out (normally less than


We have a report subscription that emails out through a 3rd / separate smtp server.

I was watching the progress on the report server subscription page (where it shows executing, x of y completed, 0 errors) and noticed a long pause between updates about half way through the subscription.


It sends out around 500 emails and email 475 of 500 was still on screen after a few minutes (it hadn't ticket up to 476, or 479, etc...)


So I quer

Is SSRS 2008 capable enough to be a solution for generating really huge reports?


Hi All,


I have been doing performance analysis for SSRS 2008 for some really huge reports that return between 1 to 5 million records (with single user) and reports that return 100K to 200K records with multiple users. I have observed lot of issues which made me to think that may be SSRS 2008 is not good enough for such a huge reports even less good if there is a multiple users scenario for those big reports(though I wanted to use it). Please go through my points and share your views on this.


Before putting up the points I would like to mention my configuration, Windows Server 2003 Enterprise Edition R2 SP2 64 bit (totally dedicated to SSRS reports as the data source for these reports was SQL Server 2005 Enterprise Edition), Microsoft Reporting Services 2008 R2 64 bit, 8 CPU, 8 GB RAM and the reports are simple tabular reports which are fetching the data from a single table (no joins)

Authenticated, when deploying the reports(SSRS 2008) to a sharepoint site

I created reports in SSRS 2008 for a sharepoint list. But when I tried to deploy it to the report library I used to get an authentication pop-up box again and again. I used all the username and password. But no luck. Does any one knows how to overcome this situation.

ssrs 2008 reports Datasource error in Test server..


Hi ,

 i Have upgraded my Reports from Report server  VS 2005 to  VS 2008 .

My reports works fine in local, development & test server.

After Ugrading to 2008 it works fine in local server & devlopement serverr.

 When i deployed to Test server i am trying to access my reports i am getting below errors,

 An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors ..

i checked the Datasource conncetion properties..its pointing to correct Test database only..

My reports are windows integrated...

Now it works in srs 2005 developement & test server. For same properties it works in dev server,  it  doesn't works in srs 2008 test server.


Why? Can anyone give me some idea...?


Unable to deploy reports from VS 2008 to SSRS 2008

I have a server that has SQL 2005 and SQL 2008 installed.  At one point, I was able to deploy reports from VS 2008 to SQL 2008, but can no longer do so.  Any ideas what could have changed that prevents the deployment?  Should I remove SQL 2005, as it's not being used on this particular server?

merging reports ssrs 2008




how can i display barchart and linechart in a single report by using ssrs 2008

Reports referencing .NET Framework 4.0 fail to upload to SSRS 2008


We are running SSRS 2008 on a 64-bit Windows Server 2008 SP2

When attempting to deploy a report containing a reference to a .NET Framework 4.0 assembly via the Report Manager, we get an error.

For example, when deploying a report referencing System.Xml, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089, we get the following error:

Error while loading code module: ‘System.Xml, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089’. Details: Could not load file or assembly 'System.Xml, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (rsErrorLoadingCodeModule)

The same report deploys correctly in a development environment (Windows 7 64-bit, SSRS 2008).

The Win2k8 server has .NET Framework 4.0 installed and is fully patched.

Is there a strategy for troubleshooting this issue?



Multiple reports straight to pdf (SSRS 2008)

Hello, I have successfully written code to generate a server report straight to a pdf document. I did this using Report.Render(...) and then writing the result with Response.BinaryWrite. This works fine. The thing I would like to do now is this: On the webpage the user sees a tree with about 20-30 reports on it. I would like the user be able to select which reports he wants to see (using the tree check boxes) and then when he hits print one pdf document is generated with all the selected reports on it. Any suggestions? Thanks.

Printing Landscape oriented reports with SSRS 2008 and SQL Server 2008 R2




I am having issues when I print reports with SSRS 2008. We have an web application that uses the Report Viewer control to preview our Reports in a popup window. The preview page shows the report in the correct orientation and so does any report that has been exported to PDF or Excel file.

The problem arises when we print the report. For some reason any report set to landscape is still being printed in Portrait orientation. The reports have their heights and width properly set, i.e., for portrait reports we have the layout set to 8.5in x 11in and for landscape reports we have the layout set to 11in x 8.5in.

I have done some research and I did not get a conclusive answer, it seems that this happens because of a bug or maybe because how my ReportViewer object in the aspx page is being set.

I would deeply appreciate any extra info you guys can provide.  

Issue while migrating reports from SSRS 2005 to SSRS 2008


We developed reports for SSRS 2005 using SQL Server Business Intelligence Development Studio (Visual Studio 2005).


We migrated these reports for SSRS 2008 using SQL Server Business Intelligence Development Studio (Visual Studio 2008) by opening the Reports project folder in SSRS 2008.


After migration when the report is ran without any changes made in the design mode we get the correct output.


The issue arises when we try to edit the report in the Design mode. In design mode, it shows only 1 'Tablix Filter' Value and loses the rest of the 'Tablix Filter' values. Specifically, If we try and edit the Tablix properties (In Design mode) all the values in the 'Filters' property disappear.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend