Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
btamulis
Yak Posting Veteran
64 Posts |
 Posted - 2013-11-04 : 07:15:14
|
| Greetings - Probably a simple question1. Created a SQL View2. Used the View as a dataset for a report3. Modified the SQL View (after creating a report using the view)Problem - My new fields (I relabeled some and added some) do not show up as being available in my report.I've tried refreshing the data source - under server explorer - if I peg to my view - I see all my new fields - however in the body of the report if I choose properties of field and look to see - I see only the original fields of the original view. When I created the report I think I just used 'dataset1' and a simple select statement for my view..........it's like the original dataset fields are permanently part of the report.....Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-04 : 07:23:22
|
| you just need to refersh the dataset and it will automtically take latest columns from the view, so far as you've executed latest view code with changed columns in your database.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
innap9999
Starting Member
1 Post |
Posted - 2014-01-16 : 14:51:24
|
| Check how you SELECT View? SELECT * from your_view or maybe SELECT column_name, column_name1, and so on from your_view |
|
|
|
|
|
|
SRS Newbie