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.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Report Model question

Author  Topic 

sunithavasam
Starting Member

2 Posts

Posted - 2010-03-08 : 13:11:11
I have a question on report model behavior, will explain with small case
I built a model with two tables Contracts and Contract Details linked
on contract id column ( implemented left outer join)
After this model is deployed to server, I tried to create a report
based on this model in report builder.
In the report builder in the left side I see two entities

Contracts
Contract Details

Suppose if I add any column from Contract Details to report, immediately order of entities in left pane changes and now the order is changed as

Contract Details
Contracts

I want to order of entities to remain fixed and I want all the entities to present, so the report developer can move up and down when
selecting report columns.

Can anyone tell me how to achieve this?

Where can I find more information on report models development ?

Thanks,
Sunitha
   

- Advertisement -