If there is a need to add a new column to the table, how would you do it to add it to an EXISTING report using RB? I don't want to create a new RB report. I want to add the new column to an existing RB report.
p.s. Anybody knows how to replace a Report Model on the report server when re-deploying it? Currently I manually delete the Report Model and re-deploy it onto the server. Otherwise, it gives me an error for duplicate IDs. Is there a switch that can be turned on? Thanks.
If there is a need to add a new column to the table, how would you do it to add it to an EXISTING report using RB? I don't want to create a new RB report. I want to add the new column to an existing RB report.
-- You can open an existing report and edit it. Select the Open icon in the upper left corner and navigate to the report in question with Report Builder.
p.s. Anybody knows how to replace a Report Model on the report server when re-deploying it? Currently I manually delete the Report Model and re-deploy it onto the server. Otherwise, it gives me an error for duplicate IDs. Is there a switch that can be turned on? Thanks.
-- If the ID of the model has changed, you cannot overwrite the model because it has the potential to break all existing reports. You would have to delete and replace the model. This is a safe guard for existing reports.
|||This is what I did:
-On the Data Source View, right click on the table and select refresh. The new field will be brought into the DSV
-Right click in the Report Mode atributes, New - Source Field. Bind to the new field in Property.
-Rebuild and redeploy the Report Model.
-Open the report using RB. Then drag the new field onto the report.
-Run it. Voila! The new field is in there!
No comments:
Post a Comment