Hi all,
I'm using SSRS 2005, VS2005 with the BIDS add-on, and Sharepoint Portal Server 2003.
I need to make a report model available to my users that has a Sharepoint web service as the data source. I've successfully created a regular report project with the SPS data source. But the only option I see in a BIDS report model project is to use SQL for the data source.
Has anyone done this and if so, how did you get it done? I'm guessing that I'll have to create a regular report in BIDS and tweak it somehow, or understand how to add XML data sources as an option in the report model designer.
TIA
Phil H.
-----------
A virtual machine ate my accounting data. I transferred it to a physical box, then I beat it to smithereens with a sledgehammer. I feel better.
I'm using SSRS 2005, VS2005 with the BIDS add-on, and Sharepoint Portal Server 2003.
I need to make a report model available to my users that has a Sharepoint web service as the data source. I've successfully created a regular report project with the SPS data source. But the only option I see in a BIDS report model project is to use SQL for the data source.
Has anyone done this and if so, how did you get it done? I'm guessing that I'll have to create a regular report in BIDS and tweak it somehow, or understand how to add XML data sources as an option in the report model designer.
TIA
Phil H.
-----------
A virtual machine ate my accounting data. I transferred it to a physical box, then I beat it to smithereens with a sledgehammer. I feel better.