Report Builder, Stored Procedures and Views

How can I access recordsets from Stored Procedures and/or views instead of
tables from the database. I need to limit the amount of data a user can
access but the only entities showing up in the Explorer are tables.Hi,
You can access from tables and views, what ever filter criteria you can give
it in views. Go to "Data Source Views" in the Report model project and click
on add existing items from your datasource you should see tables and views.
Amarnath
"SYoung" wrote:
> How can I access recordsets from Stored Procedures and/or views instead of
> tables from the database. I need to limit the amount of data a user can
> access but the only entities showing up in the Explorer are tables.|||You're talking about a Report Project in VS. What I'm talking about is an
add on client development tool accessible via the
http://YourReportServer/Reports page called "Report Builder". This tool
allowes the user to create adhoc reports without having to write 1 line of
SQL.
"Amarnath" wrote:
> Hi,
> You can access from tables and views, what ever filter criteria you can give
> it in views. Go to "Data Source Views" in the Report model project and click
> on add existing items from your datasource you should see tables and views.
> Amarnath
>
> "SYoung" wrote:
> > How can I access recordsets from Stored Procedures and/or views instead of
> > tables from the database. I need to limit the amount of data a user can
> > access but the only entities showing up in the Explorer are tables.