.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

Subreport Bug in SSRS / SQL?

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :Sql Server
Hello - I've posted about this issue specifically before, but I thought I'd address the issue generally.  The repro steps here are based on using SSRS 2005 reporting out of VS TFS 2005 with all updated Service Packs.

I believe I have come across a bug in my SSRS reports when using a report as a subreport.  Here are the repro steps:

  1. Create a new Report Project with whatever name you desire.
  2. Create a Shared Data Source called "TFSReportDS" of type "Microsoft SQL Server" with the Connection string like "Data Source=[servername];Initial Catalog=TfsWarehouse".  Of course, if you aren't running TFS you'll have to use a different connection string.
  3. Create a new report called "Host".  Within the "Host" report, create a Dataset using "TFSReportDS".  For my purposes, my Query string is "SELECT System_ID from dbo.[Work Item]" just for simplicity.
  4. Create a new report called "Subreport".  Within the "Subreport" report, create a Dataset using "TFSReportDS".  For my purposes, my Query string is "SELECT System_ID from dbo.[Work Item] where System_State is null".  The important part here is the "System_State is null" section.  For your own repro in your

    View Complete Post

More Related Resource Links

Linked Report Subreport- Error: Subreport could not be shown on SSRS 2008r2

I've got 2 folders: /Finance /Japan In the Finance folder I have a Sales report that has 3 subreports, and a salesregion parameter. I created a linked report in /Japan to /Finance/Sales, hide the salesregion parameter, and set the default to Japan, so they can only see their region's sales data. But when a Japan user runs the Sales report, they get Error: Subreport could not be shown because they do not have access to the /Finance folder. Any ideas?

SSRS 2008 Having more than one subreport changes output

I have a master report which has a list control.  The list contains employee header information.  I have ticked the option to have a page break between each instance of a group on the details group properties page as i want each employee on a seperate page. There is no grouping on the list other than the default details.  I have two sub-reports which are linked to the main report by an employeeID.  When i add the first sub-report it displays the header and associated detail without a problem.  When i click on the next record it shows me the correct next employee header and the correct associated details.  However, when i add the second subreport to the list and review it, the first record shows okay, but when i click on next all the header information is gone - when i then click on previous to show the previously ok record - all the header for that record has now gone.  It doesn't matter which subreport i use as the first one on the master - it happens in exactly the same way as soon as i add the second subreport to the list control.  This is a vitally important report and i am now starting to get very frustrated as i cannot easily see a solution.  Your help would be most appreciated.  Barry  

SSRS 2000 reports when upgraded to 2005 report with subreport really really slow


We recently upgraded a report server and corresponding reports from SQL Server 2000 (reports 2003) to SQL Server 2005. After upgrade one of our reports which use two subreport is very very slow.

The sp's used for these all these reports are fast. All the sp's together takes about 40 secs.

Both in the BIDS environment as well as the report site the report is very slow.

We are using a database in which data is inserted through replicatoin. In all our sp's we have given 'with nolock' along with the table names.

Can anyone please help me here?

SSRS 2008 - Subreport passing a value back to the main (master) report



Looking for a way to pass a calcuated value or Sum from a Subreport back to the Main Report.   Is there anyway to do this.  In past posts, with the most recent being 2008, it is said that this feature was not available or included in SSRS.

Using SSRS 2008.



C# Code Call SSRS Subreport from ReportViewer


Any C# Code or any setting in Reportviewer to call SSRS Subreport from ReportViewer

The SSRS Subreport executes properly from report manager.

SSRS 2005 passing Globals!PageNo as a variable into SubReport


I have a sub report which we are using as a generic header for all our reports and one of the requirements is it must have the current page / total pages displayed.

I know the Globals variable for page number and page count are only usable in the header or footer of a page but doing it this way isnt an option for me sadly.

Is there a workaround to this so that I can pass this value to a subreport as a parameter?


SSRS Subreport VS2010 data retrieval failed for the subreport

I am new to the subreport part of ssrs. I have setup some code which works well with the standard tables and matrix and tablix controls but have been unable to get the subreport to load. I keep getting the same

error message "data retrieval failed for the subreport".

Does anyone have any sample code of a subreport working with visual studio 2010?

My code looks like this though I have tried a bunch of different scenarios to try to pass the data into the subreport.

private void LoadReport(string reportName)
    // Set Processing Mode
    reportViewer1.ProcessingMode = ProcessingMode.Local;

    // Set RDL file
    reportViewer1.LocalReport.ReportPath = reportName+".rdlc";


  public void LoadReport(IEnumerable products, string reportName, string dataSourceName)

    ReportParameter myParam = new ReportParameter("ReportParameter1", st.ToString() + " TO " + et.ToString());
      reportViewer1.LocalReport.SetParameters(new ReportParameter[] { myParam });

      new ReportDataSource(dataSour

where can i download from SSRS?


Hi all,

My  machine is alread installed with Sql Server 2005.  I need to install sql server 2005 reporting services as a add-on.

Where can i download this from. Can anyone post the link here..?


Thanks in advance


MDX Query parameter from SSRS


I've a MDX Query that has where clause as shown below.
I'm designing report using SSRS 2008. How can i pass date as parameter ? I tried to setup @from and @to as parameter but not working ?
any ideas....

WHERE ( {[Date Central].[Calendar Date].[2010-04-01 00:00:00]:[Date Central].[Calendar Date].[2010-08-30 00:00:00]} )

need it to work as
WHERE ( {[Date Central].[Calendar Date].[@From]:[Date Central].[Calendar Date].[@To]} )



How to change text in columns in SSRS?


I need to create a complex report and export it to Excel. 

In the first column header, text is displayed as "Hide Daily Columns", but I need the text to change as "Unhide Daily columns" when I click on it and when the text changes the columns under "daily" header (I have 3 columns under this header) present in the report shud be hidden and only weekly columns shud be visible. Any ideas please. I am new to SSRS and tried out many ways but didn't get it.

Is Conditional Subscription possible in SSRS 2005?


Hi Guys,

Is there a way to set up a subscription that will send e-mails based on the contents of a report? For example, I want to schedule a daily subscription that will only send an e-mail if the report contains data, otherwise it will do nothing for that day. i.e If the report has more than one row, it should send the mail otherwise it should not send the mail.....

Is it possible in SSRS 2005 or is there any other way to do it???


SSRS 2005 "Mixed" Authentication Mode


I have a web application where users can authenticate using either SiteMinder or Windows domain accounts.  This is actually configured as two separate virtual directories within IIS 6.  Both applications need to use the same instance of SSRS.  Is it possible to configure the SSRS web application so that if a user is authenticated by SiteMinder it impersonates a Windows account, but if they are already Windows-authenticated that account is used instead?

SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

SQL 2008 servers and MOSS 2007 with SSRS


I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS.  Here is the run down:

  • I currently have MOSS 2007 server with backend on SQL 2005, which also acts as the SSRS server.  In addition I have another SQL 2005 server where business data resides and against which most of the SSRS reports run.
  • Future plan (over which I don't really have a say) is MOSS 2007 with backend on SQL 2008, which will remain to be the SSRS server.  The second SQL server with business data will be migrated to SQL 2008 R2.

Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)?  Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?

Share Point integrated SSRS reports rendering when access from external site


Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

An unexpected error occurred while connecting to the report server. Verify that the report server is avai

SSRS Report viewer + Remove


I am running the report from SSRS report server in the view i am finding that the window title is Report Viewer - Windows Internet Explorer.

How to remove this name and get the name of the report over there.

I am using java at the back end to call the repot through url.

Please help me .

Thanks ,


MOSS 07 Installation Quirks - SSRS Connectivity & SSP Permissions

I'm new to MOSS 07 and am currently learning it.  I've done clean installs and post-install configuration a few times now and I've noticed 2 quirks associated with a fresh install.  I'm not sure what is going on or the best way to "fix" them.

1 - I install SQL 05 with SSRS prior to installing MOSS and I always check to make sure that SSRS is configured and I can connect to it in the SQL Management Studio.  Once the Default port 80 Web App is provisioned, however, I can no longer connect to SSRS via the SQL MS.  I understand that this is related to the fact that the default Web App that hosts the SSRS sites is the Default 80 Web Site and that this port is taken over by the SharePoint 80 portal.  My question is, how to handle this.  I understand that I can configure SSRS to run via SP Integration.  However, when I install SSRS 05 initially and prior to installing/configuring MOSS, should SSRS be installed under a separate Web App and Port than the Default?  Does SP Integration restore the ability to connect to SSRS via the SQL Mang. Studio?

2 - In an attempt to get used to a "production" way of doing things, I create Domain Service accounts for both installing MOSS and running the services.  My problem is with the results of using an installation account.  I call it "spinsta
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