Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Reporting Services Development
 SRS Newbie
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

64 Posts

Posted - 11/04/2013 :  07:15:14  Show Profile  Reply with Quote
Greetings - Probably a simple question

1. Created a SQL View
2. Used the View as a dataset for a report
3. 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's like the original dataset fields are permanently part of the report.....

Thanks in advance

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 11/04/2013 :  07:23:22  Show Profile  Reply with Quote
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 MVP
Go to Top of Page

Starting Member

1 Posts

Posted - 01/16/2014 :  14:51:24  Show Profile  Reply with Quote
Check how you SELECT View?
SELECT * from your_view or maybe
SELECT column_name, column_name1, and so on from your_view
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000