I've created a report with Report Builder using a Model. I want to keep the same report, but I have to use another model (this model is almost the same as previous one, except that it has some extra tables).
I tried to change my report's model from Report Manager (Report_Name -> Properties -> Data Sources), but it didn't work.
Any suggestions?
Best regards.
One way I could change it was to open the report in Designer. On the data tab you can change the report model here. If your report was built in designer then you are all set. The problem is when your report was done in builder. Then there is no going back.
If any suggestion on a better way to do while still keeping the report as a report builder version I would love to hear it.
Thanks,
Rahul
|||You can download the RDL file for a report builder report by looking at the properties for that report in Report Manager and clicking the Edit link. Then you can manually edit the RDL and change out the GUID for the old report model to be the GUID for the new report model. (Create a report with the new report model and then look at the RDL to see the GUID of the new report model.) Then you can click the Update link on the report properties and upload the modified RDL.
The only thing to be aware of is that if you're using a relational report model, the IDs for entities and fields are GUIDs. So if you built the new report model from scratch, the GUIDs for common entities and fields may be different.
|||That worked great. I guess we still need to keep with our Visual Notepad stills.
Thanks,
Rahul
No comments:
Post a Comment