SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

btamulis
Yak Posting Veteran

USA
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 view..........it's like the original dataset fields are permanently part of the report.....

Thanks in advance

visakh16
Very Important crosS Applying yaK Herder

India
52317 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
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

innap9999
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  
 New 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.09 seconds. Powered By: Snitz Forums 2000