SQL Server 2005 Report Builder

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

Development Tools

Reporting Services Development

SQL Server 2005 Report Builder

Author

Topic

urpalshu
Starting Member

21 Posts

Posted - 2006-04-24 : 12:39:41

Hello,

Reporting Services Report Builder is includid with SQL Server 2005

These forms of report are generated by end users. They do not have to write queries. Just by simple add and drop technology., they could create Groups and Joins, between tables.

There Report Builder Reports use Report Model, in order to create such reports.

Report Model is created in VS2005.

Here we create a Data Source, Data Source View, Data Model.

>> The Wizard allows us to make Table or view selections, in order to build the Model.

Questions: Please could somebody tell me if I could use Stored Procedures in the Report Model.

Thank you,

snktheone
Starting Member

20 Posts

Posted - 2006-04-25 : 07:21:58

yeah u can select stored procedure from the dataset drop down and then write the name of the stored procedure which is created in the same database
would help u i guess

urpalshu
Starting Member

21 Posts

Posted - 2006-04-25 : 15:43:02

quote:
Originally posted by snktheone

yeah u can select stored procedure from the dataset drop down and then write the name of the stored procedure which is created in the same database
would help u i guess

Thank you,

I am not clear with where I could find the dataset drop down,
These are the steps I did
>>Start VS 2005
>> New Project...Select Business Intelligence Project...Select Report Model Project
>> In the Report Model Project I created a new data source, a connection to my local server
>> Create a new Data Source View... I went thru the wizard, but did not select any tables, there were no options for selecting a Stored Procedure Though.
>> Then Double clicked the Data Source View,
>> Then Clicked on New Named Query
>> Here I can write only select statements, it does not accept Stored Proc.

Please could you give me detailed steps , in using the Stored Procedure in my Report Model Project
Thank you,

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2006-04-26 : 01:27:05

You can't. You can use views though. Just include the views in the DSV.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources