Sunday, March 25, 2012

customizable report model ?

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.

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.

|||Thanks BOB.i'll have a read of this article :)

No comments:

Post a Comment