Report Designer best practice

Hi
When creating a best practice enterprise reporting solution, would you
normally create report models first, use these as datasources in Report
Designer, andd create datasets on top of these? Or would you create datasets
using SQL queries directly from Report Designer?
What is the preferred/best practice way of creating the datasets ?
Kind Regards,
Torkild HagenOn Mar 22, 2:15 am, thagen <tha...@.discussions.microsoft.com> wrote:
> Hi
> When creating a best practice enterprise reporting solution, would you
> normally create report models first, use these as datasources in Report
> Designer, andd create datasets on top of these? Or would you create datasets
> using SQL queries directly from Report Designer?
> What is the preferred/best practice way of creating the datasets ?
> Kind Regards,
> Torkild Hagen
My preference is to create stored procedures first and then create
datasets based on those stored procedures in the Report Designer, etc;
since, stored procedures generally have better performance. Just my
thoughts. Hope this is helpful.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||You can use report model as Datasource but this is meant for RB, for normal
reports, it is advisable to create stored proc and then create dataset. For
queries returning very small no of records, direct query will be good. As a
best Practise use shared datasource as far as possible, so that later if you
want to change any thing related to data source can be changed at one place
instead of many places.
Amarnath, MCTS
"thagen" wrote:
> Hi
> When creating a best practice enterprise reporting solution, would you
> normally create report models first, use these as datasources in Report
> Designer, andd create datasets on top of these? Or would you create datasets
> using SQL queries directly from Report Designer?
> What is the preferred/best practice way of creating the datasets ?
> Kind Regards,
> Torkild Hagen