report builder cant join views?

Hi friends
i have quick question with report builder utility .am using VS2005 and Sql 2005.
When creating report model solution ,when adding field names from a table it loads fields names as it is ,right ? so to make end users life easier i created
Views with lengthy field names.

the issue is ,i'll start with an example ,i've 2 views (ParentView and ChildView) and the tables used by these views have foreign key relation ship .when i use these 2 entities in report builder as soon as i add a column from one view (say ParentView) the other view disappears from list !! I assume Report builder looks FKey to link 2 entities and since am using views which will not have any fkeys on them it removes other entities from list.
is there any way to link these 2 views so that users can add few columns from ParentView and few more from ChildView.
Yes, If i use tables directly everything works fine .
Thanks for your help.
i finally figured out .if any one interested
when we double click on data source view (in report model project you created) it gives graphical representation of objects where we can drag & drop to create relationships just like diagrams in Enterprise Managers

report builder cant join views?

Hi friends
i have quick question with report builder utility .am using VS2005 and Sql 2005.
When creating report model solution ,when adding field names from a table it loads fields names as it is ,right ? so to make end users life easier i created
Views with lengthy field names.

the issue is ,i'll start with an example ,i've 2 views (ParentView and ChildView) and the tables used by these views have foreign key relation ship .when i use these 2 entities in report builder as soon as i add a column from one view (say ParentView) the other view disappears from list !! I assume Report builder looks FKey to link 2 entities and since am using views which will not have any fkeys on them it removes other entities from list.
is there any way to link these 2 views so that users can add few columns from ParentView and few more from ChildView.
Yes, If i use tables directly everything works fine .
Thanks for your help.
i finally figured out .if any one interested
when we double click on data source view (in report model project you created) it gives graphical representation of objects where we can drag & drop to create relationships just like diagrams in Enterprise Managers

Replication: Adding a column

Hi,
I have a table that is being replicated but one the the developers added a
column to the table WITHOUT using sp_repladdcolumn. Now, they are wondering
why this column is not on the subscriber. What is the easiest way to solve
this problem? (I am thinking of changing the subscription and adding the
column to the subscription and doing a snapshot but I hate to do this as it
takes a while on a 15 GB database).
Any fast way of solving this WITHOUT removing the column on the publisher?
--
I saw it work in a cartoon once so I am pretty sure I can do it.I would sp_dropScubscription/ sp_droparticle/
sp_addarticle/ start the snapshot agent.
Make sure that the sp_dropsubscription specifies that
article only. Do this first in Dev.
>--Original Message--
>Hi,
>I have a table that is being replicated but one the the
developers added a
>column to the table WITHOUT using sp_repladdcolumn. Now,
they are wondering
>why this column is not on the subscriber. What is the
easiest way to solve
>this problem? (I am thinking of changing the
subscription and adding the
>column to the subscription and doing a snapshot but I
hate to do this as it
>takes a while on a 15 GB database).
>Any fast way of solving this WITHOUT removing the
column on the publisher?
>--
>I saw it work in a cartoon once so I am pretty sure I
can do it.
>.
>