1

Topic: SSRS + + MSSQL

I in it very brand new, do not swear
It is necessary to inform people  from a DB. The report rdl arranges initially. Autoformation is not required, everyone comes, sets parameters and pushes the button
Anybody from users to a DB of access has no
Is , already there are folders and access to them by means of groups AD
I think so
To a DB I write procedure of formation of the data
I add in a DB those groups AD and I distribute on these groups of the right to procedure performance
I spread on  the report rdl, and it should be formed
What could I pass, or here  all not so?
Thanks

2

Re: SSRS + + MSSQL

andreymx, well not that that all...
This superfluous

wrote:

I add in a DB those groups AD and I distribute on these groups of the right to procedure performance

3

Re: SSRS + + MSSQL

andreymx, lines - ... You esteem about "regular" integration SSRS and SharePoint and possibilities of this tandem. I will fairly tell - when was not engaged, but there are suspicions that gather  the bicycle...

4

Re: SSRS + + MSSQL

buser wrote:

andreymx, lines - ... You esteem about "regular" integration SSRS and SharePoint and possibilities of this tandem. I will fairly tell - when was not engaged, but there are suspicions that gather  the bicycle...

tomorrow I will communicate to ours , , prompt

5

Re: SSRS + + MSSQL

andreymx;
At you here groups AD what side?
Data in the report will be filtered on win to login or all see all?

6

Re: SSRS + + MSSQL

wrote:

andreymx;
At you here groups AD what side?
Data in the report will be filtered on win to login or all see all?

the rights to procedure formation to distribute
Everyone the part sees

7

Re: SSRS + + MSSQL

andreymx;
There was a business, for the reporting on relational basis did demarcation of data access on the basis of a label-directory in which the list of the allowed categories for each login contains.
In report SSRS login of the one who launches the report, on parameter UserId is defined. On the basis of login and a label-directory the list of the accessible data which is transferred further for a filtration is defined.
(It turned out type of analog of a dynamic role as in multidimensional databases, only I then did not know about them)
Special requirements from the point of view of safety was not, it was supported easily, to pull administrators of a DB and AD it was not necessary.
Groups of safety AD too were used, but for access demarcation to folders/sections of reports on SharePoint, i.e. users depending on entrance in groups could have or not have access to special folders of reports.