Thanks for the reply..so it means either I have create Schema specific Stored Procedure..For example : Tenant1.usp_GetCustomer and Tenant2.usp_GetCustomer or Create dynamic sql which will take Schema name as Parameter...right?

I am sorry for the confusion. Each User will only access their own schema and its data, hence no user can access schema of any other user. Whereas the Default...

Yes ,But when running the database script on stroed procedure the 'Go'Statement can create problem,and Without Go statement the Relation ship and other contriants are not created...

Yes ,This miss many tables structures like relationship and othe contriants ,Can you tell any other way..........

that means only the group\user are added in report manager who belong to active directory,

I have on group 'SuperUser' and 'Out side sales group' in active directory

Super user group are...

How to create new group and how to add user in that group who need to access report

Hi ,

reportserver secuirty was integrated windows,

and report manager have also integrated windows secuirty,

datasource connection string with SQL server secuirty

Hi ,

you can Used this

=Format(Fields!myDate.Value, “MM/dd/yyyy”)