Hi friends
we created report model for our clients to create reports using report builder which works fine.
we have a situation now , as we've different clients for e.g.,individual doctors, hospitals etc.,
so we need to have smart report model which hides some entities/attributes if client is individual doctors or hospitals.
what i mean some entities and attributes are unique to a particular type of client. so we want to hide some entities/attributes based on client type .
is it possible.
Thanks for ur help.
we are using sql server 2005 standard edition.
customizable report model ?
Hot Topic
- SCD component in SQL2005
- Reporting services website
- xp_cmdshell and passing data to a web service
- unzip file using C# code and asp.net
- Calculating date/time from Unix time
- MDAC and SQL Server 2005
- SQL Server 2000 & Reporting Services (Report Manager)
- Authentication, windows or custom
- ODBC Destination in SSIS
- Performance difference
SQL Server
- How to upload rdl programmatically
- How to get started on custom Merge Join component?
- problem with panda antivirus and olap cubes
- Proglem creating index
- Out-of-Memory error on Sort Transformation
- Failed to generate a user instance of SQL Server
- Problems creating full-text population schedule via Management Studio
- Resolving
- How to run DTS package/upgrade in SQL 2005.
- Retrieving DefaultConstraint property of a Table column is too slow
customizable report model ?
Marsan001
easan
You can use model item security to control the visibility of various entities and attributes to different sets of users.
I have an article on my blog that goes into some depth on how to do this.