Hi, I have a report server project which gets its information from a storesd
prodedure. Occasionally that stored procedure changes, some columns may be
added or removed but as I see it now that only way to have my report reflect
those changes is to start a whole new report server project.
is there a way to have my current project re-bind to the updated (changed)
stored procedure or better yet just bind to it so it detects those changes
on its own
thanks!
Updating report from stored procedure
Hot Topic
- Cannot Open User Default Database (error 4064)
- Configuration Files
- No TRIM function in 2005 - are you serious!?
- Crashing, Dumping, and restarting RS WebServices
- Could anyone attach the AdventureWorksDW to their SQL Server database engine?
- SSIS Requests...
- Can't precompile script
- A probably simple question
- Alter table Question in Sql 2000
- SSIS Portability
SQL Server
- How can i get the first day of the month and the last day of the month?
- CPU to slow for SQL Server 2005 express???
- Why is the DisableEventHandlers property not accessible for eventhandler containers
- Memory Error
- SQLExpress Problems
- Replication Error
- Business Scorecard Manager 2005 Data Sources
- Script Task TimeOut
- Inserting non english values using jdbc
- Excel Pivot Table and Time Dimension
Updating report from stored procedure
kishoremsn
Yes - open the report in report designer, go to the data tab,
Click the refresh button (little green arrows going in a circle). This should refresh the list of fields for you. If this doesn't work, try running the query and then going to the layout tab. That should also update the fields list.
-Lukasz
Ivan Martinez
any ideas
JasonSD
The report definition RDL is just XML, if you believe your SP is going to change often, you could create a little script to add/remove columns as needed.
There is no tools support for this kind of edit.
-Lukasz