Showing posts with label relational. Show all posts
Showing posts with label relational. Show all posts

Tuesday, March 20, 2012

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 !!

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 !!

Friday, March 9, 2012

Report Builder / Report Models

We would like to support Report Builder / Report Models in our application,
and we know that Report models are generated from SQL Server relational or
Analysis Services multidimensional databases. Based on our superficial
understandings of report models, it seems that we should be able to create an
entity based on more than one source table/view with or without security
filters and even give it a friendly name. Is this correct? If so, is it
possible to create a report model programmatically?
If not programmatically, we would want more help with how to create a report
model in details. The current tutorial in the SQL Server Books online is
actually not detailed enough (most of the time it guides us to accept the
defaults).Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you would like to whether it is
possible to create a report model programmatically. If I have misunderstood
your concern, please feel free to point it out.
I think BOL contains two useful articles for your reference
How to: Create a Model Using Report Manager
http://msdn2.microsoft.com/en-us/library/ms159118.aspx
How to: Create a Report Model Using the Model Designer Wizard
http://msdn2.microsoft.com/en-us/library/ms156284.aspx
Also, this article explains the major components of Microsoft Reporting
Services' ad-hoc architecture and semantic model, and walks you through an
end-to-end example that demonstrates how to author, manage, and deliver
ad-hoc reports.
Generate Ad-hoc Reports with Microsoft Reporting Services 2005
http://www.devx.com/dbzone/Article/28047
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.