Report Builder Error - Novice please suggest !!

I created report model based of three relational tables(SQL Db). When I try to run it gives me error 'cannot run this report - A filter must be specified'. When I supply filter it will go head and run.

Basically I have three relational tables from SQL database. one is the Master say A and other two are related tables say B and C. I joined with id1 to B from A and id2 to C from A.

A(id1) -> B(id1)

A(id2) -> C(id2)

1.Why is it asking me the enter filter?

2.Also, when I created a report based on fields from A,B and C I tried to do the click through.

I can able to click through to table B by clicking on the fields of B but similarly I am unable to do for the fields from the C.

3.Can I create a report model based on tables from different databases rather than from single database.?

I am novice to the Reporting Services arena. Your suggestions/help is greatly appreciated.

Thanks in advance.

Prakash

1. Report Builder requires you to specify a filter if Entity.InstanceSelection=MandatoryFilter in the report model. The model generation wizard will set this value if the underlying table has a very large number of rows in it. If you don't like the setting, you can change it in Model Designer.

2. Only certain fields have EnableDrillthrough=True by default. I believe the model generation wizard sets this only for highly unique fields and/or fields that are part of the primary key in the underyling table. If you want Report Builder to create Clickthrough links for more fields, you can change this property in Model Designer.

3. The DSV that describes the database over which the report model is built can only have one datasource. However, you can use linked servers to access data on other servers.

Hope that helps!

|||

Thanks for your response.

Please tell me where I can find these properties. I am unable to find them(I guess I am dumb). Your help is greatly appreciated.

Thanks !!