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:
- Create a new Report Project with whatever name you desire.
- 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.
- 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.
- 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