I too get this error. These are not reports that have been created in Report Builder by us, but are part of the MSF Agile process template with Team Foundation Server.
A range of standard reports are loaded when a new Team Project is created. It seems impossible to edit these using Report Builder.
There are two data sources defined in the standard TFS installation: TfsOlapReportDS and TfsReportDS. These both seem present in the reports if you go in to Properties -> Data Sources.
If this is the problem, and Report Builder has this limitation, how are we meant to amend the Team Foundation Server default reports?
This is obvious "as intended" from the TFS guys, and obviously SQL Reporting Services copes with multiple data sources as viewing the reports are fine.
But editing these without resorting to getting highly confused in manually editing the RDL is achieved how?
Many thanks,
Jonathan
|||We resorted to writing our own reports based on creating a model from TFSReportDS using the basic report builder. It isn't too difficult but take some getting used to. My boss has messed around with the more elaborate report editing that you can use via IDE extensions and was able to open the pre-baked report though he couldn't really make heads or tails of the underlying queries (and there are usually many) needed for what seemed to be a basic report. So far the feeling we have, is keep it basic or you need an incredible amount of OLAP related querying understanding to extend the reports.