|
|
You're in the
sql server reporting services
group:How do I add a new column to an existing Data Source View in SSRS?
sql server reporting services:
tables in our warehouse, and there are LOTS of relationship lines (Roles) linking to this table. We've just added 6 new columns to this table, and I need to add them to the Data Source View so the new columns will be available to the end users running Report Builder. I am pulling my hair out trying to find the option to add the new columns! Completely removing and re-adding the table is NOT an option, as we have 37
Hello here,
From your description, my understanding of this issue is that, you add some new columns in the source table in database and you want to reflect in the Data Source View. If I am offset, please feel free to let me know. Based on my research, you could not add the new column in the data source view directly. My suggestion is that you could regenerate the model. Since the wizard will generate the relationship automatically, you will not concern about creating many relationships. Sincerely, Wei Lu Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ================================================== (This posting is provided "AS IS", with no warranties, and confers no rights.)
Hi Wei Lu,
Thanks for your post. The wizard does not automatically re-establish all the relationship lines. These 37 relationship lines I had to manually create the very first time when I generated the model, even though most of them already have a foreign key in the database expressing the relationship. I do not want to have to manually re-create all these relationship lines. Also, I have other computed expression columns that would be blown away if I re-generate the entire Data Source View using the Wizard. I would have to manually recreate those as well. [quoted text, click to view] "Wei Lu [MSFT]" wrote:
> Hello here, > > From your description, my understanding of this issue is that, you add some > new columns in the source table in database and you want to reflect in the > Data Source View. If I am offset, please feel free to let me know. > > Based on my research, you could not add the new column in the data source > view directly. My suggestion is that you could regenerate the model. Since > the wizard will generate the relationship automatically, you will not > concern about creating many relationships. > > Sincerely, > > Wei Lu > > Microsoft Online Community Support > > ================================================== > > Get notification to my posts through email? Please refer to > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications. > > Note: The MSDN Managed Newsgroup support offering is for non-urgent issues > where an initial response from the community or a Microsoft Support > Engineer within 1 business day is acceptable. Please note that each follow > up response may take approximately 2 business days as the support > professional working with you may need further investigation to reach the > most efficient resolution. The offering is not appropriate for situations > that require urgent, real-time or phone-based interactions or complex > project analysis and dump analysis issues. Issues of this nature are best > handled working with a dedicated Microsoft Support Engineer by contacting > Microsoft Customer Support Services (CSS) at > http://msdn.microsoft.com/subscriptions/support/default.aspx. > > ================================================== > (This posting is provided "AS IS", with no warranties, and confers no > rights.) >
Hello,
I would like to suggest you use the Refresh button in the DSV designer, then use the Generate option on the corresponding entity in the report model. Please let me know if this resolved your problem. Sincerely, Wei Lu Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ================================================== (This posting is provided "AS IS", with no warranties, and confers no rights.)
Perfect!! The Refresh button did the trick!! Thank you so much!
=Steve= [quoted text, click to view] "Wei Lu [MSFT]" wrote:
> Hello, > > I would like to suggest you use the Refresh button in the DSV designer, > then use the Generate option on the corresponding entity in the report > model. > > Please let me know if this resolved your problem. > > Sincerely, > > Wei Lu > > Microsoft Online Community Support > > ================================================== > > Get notification to my posts through email? Please refer to > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications. > > Note: The MSDN Managed Newsgroup support offering is for non-urgent issues > where an initial response from the community or a Microsoft Support > Engineer within 1 business day is acceptable. Please note that each follow > up response may take approximately 2 business days as the support > professional working with you may need further investigation to reach the > most efficient resolution. The offering is not appropriate for situations > that require urgent, real-time or phone-based interactions or complex > project analysis and dump analysis issues. Issues of this nature are best > handled working with a dedicated Microsoft Support Engineer by contacting > Microsoft Customer Support Services (CSS) at > http://msdn.microsoft.com/subscriptions/support/default.aspx. > > ================================================== > (This posting is provided "AS IS", with no warranties, and confers no > rights.) >
Hello,
Glad to hear that you resolve this issue. If you have any question, please feel free to let me know. Sincerely, Wei Lu Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ================================================== (This posting is provided "AS IS", with no warranties, and confers no rights.)
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |