Lev's WebLog

Report Designer : editing reports produced by Report Bulder

Report Designer can be used to edit/preview reports produced by Report Builder.

Here is how to do it:

1. In Report Builder, save report to file.
2. Launch Visual Studio
3. Create new Report Server Project
4. Create new shared data source:
       Set connection string to
           Server=<report server URL>;datasource=<path to model which is used by report>
       For example
           Server=http://myserver/reportserver;datasource=/Models/Adventure Works
5. Add existing report to project
6. Switch to Data view (ignore error message)
7. Click “…” to edit data set properties
8. In Dataset dialog click “…” to edit data source properties
9. Select shared data source created in step 4 using Reference dropdown
10. Hit OK
11. Hit OK
12. Use "Project" -> "Add Existing Item to add report to project

 Now you can execute semantic query, preview and publish report

Do not forget, that report may not be opened in Report Builder after it is changed in Report Designer