asked
SSRS Linked Report Data Source Problem
I have multiple clients accessing one instance of SSRS, which in turn accesses multiple databases. This is managed by .net code changing the Datasource using ReportingService2005.SetItemDataSources based on parameters passed in. The issue is with Linked Reports. The Datasource of the linked report does not reflect the datasource of the main report I have tried using: 1. ="data source=XYZ" & Parameters!Server.Value & ";initial catalog=ABC" &Parameters!Database.Value 2. ReportingService2005.GetReportLink to manipulate the Datasource in code (I got .net errors) None worked. Does anyone know how to set the Linked Report Datasource dynamically, or force inheritance of the Datasource?
