|
|
You're in the
sql server reporting services
group:Urgent: How to filter data for each user
sql server reporting services:
We are using reporting services on a server (B), but the data are on an another server (B). I have applied security for different type of report, but i would like to know how could i for one report filter data for each user. Example: I have a report on Sales USA, only people in the groupe SALES_USA can access to the report, but when a rep of NY is opening the report i would like to filter for this rep, on the same way for the rep of LA. So each rep will only see data concerning his city.
Capture the user login, use that to lookup your own security table to
determine what they can/cannot see - use this data to filter your report. [quoted text, click to view] "MIB" wrote:
> Thanks for your help. > We are using reporting services on a server (B), but the data are on an > another server (B). I have applied security for different type of report, > but i would like to know how could i for one report filter data for each user. > Example: I have a report on Sales USA, only people in the groupe SALES_USA > can access to the report, but when a rep of NY is opening the report i would > like to filter for this rep, on the same way for the rep of LA. So each rep > will only see data concerning his city.
There is a global variable for userid. In the expression builder you will
see it. It returns the domain\userid. Have a table that you have in your join that used this value. Have a query parameter that you map to an expression instead of to a report parameter. It will automatically create a report parameter for you. In the dataset click on the ..., parameters tab and map to the expression. Then go to layout, Report Menu, Report Parameters and delete the unneeded report parameter. RS blurs query parameters and report parameters but they are two different things. Being able to map a query parameter to an expression is very useful. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Jimbo" <Jimbo@discussions.microsoft.com> wrote in message news:5AAEF3B2-0212-42EF-AF86-271583B6A073@microsoft.com... > Capture the user login, use that to lookup your own security table to > determine what they can/cannot see - use this data to filter your report. > > > > "MIB" wrote: > >> Thanks for your help. >> We are using reporting services on a server (B), but the data are on an >> another server (B). I have applied security for different type of >> report, >> but i would like to know how could i for one report filter data for each >> user. >> Example: I have a report on Sales USA, only people in the groupe >> SALES_USA >> can access to the report, but when a rep of NY is opening the report i >> would >> like to filter for this rep, on the same way for the rep of LA. So each >> rep >> will only see data concerning his city. >> Again thank you
Sorry, I really don't know much about Report model. I suggest you repost
with that in your title. Also, if you don't get an answer here then I suggest using the web forums. The other RS MVP hangs out there and it is the only place MS people hang out. http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1 -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Ryan" <Ryan@discussions.microsoft.com> wrote in message news:7B2897D6-5F5C-4065-9A7F-1609AEDCC668@microsoft.com... > Bruce, > > I have done this in report desinger for my regular reports. now i am > trying > to do something similar with my report model, but I can't get it to work > right. how do i apply an lookup table to the report model, so that it > filters > out the data not assigned to that userid? > > "Bruce L-C [MVP]" wrote: > >> There is a global variable for userid. In the expression builder you will >> see it. It returns the domain\userid. Have a table that you have in your >> join that used this value. Have a query parameter that you map to an >> expression instead of to a report parameter. It will automatically create >> a >> report parameter for you. In the dataset click on the ..., parameters tab >> and map to the expression. Then go to layout, Report Menu, Report >> Parameters >> and delete the unneeded report parameter. RS blurs query parameters and >> report parameters but they are two different things. Being able to map a >> query parameter to an expression is very useful. >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "Jimbo" <Jimbo@discussions.microsoft.com> wrote in message >> news:5AAEF3B2-0212-42EF-AF86-271583B6A073@microsoft.com... >> > Capture the user login, use that to lookup your own security table to >> > determine what they can/cannot see - use this data to filter your >> > report. >> > >> > >> > >> > "MIB" wrote: >> > >> >> Thanks for your help. >> >> We are using reporting services on a server (B), but the data are on >> >> an >> >> another server (B). I have applied security for different type of >> >> report, >> >> but i would like to know how could i for one report filter data for >> >> each >> >> user. >> >> Example: I have a report on Sales USA, only people in the groupe >> >> SALES_USA >> >> can access to the report, but when a rep of NY is opening the report i >> >> would >> >> like to filter for this rep, on the same way for the rep of LA. So >> >> each >> >> rep >> >> will only see data concerning his city. >> >> Again thank you >> >> >>
Bruce,
I have done this in report desinger for my regular reports. now i am trying to do something similar with my report model, but I can't get it to work right. how do i apply an lookup table to the report model, so that it filters out the data not assigned to that userid? [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> There is a global variable for userid. In the expression builder you will > see it. It returns the domain\userid. Have a table that you have in your > join that used this value. Have a query parameter that you map to an > expression instead of to a report parameter. It will automatically create a > report parameter for you. In the dataset click on the ..., parameters tab > and map to the expression. Then go to layout, Report Menu, Report Parameters > and delete the unneeded report parameter. RS blurs query parameters and > report parameters but they are two different things. Being able to map a > query parameter to an expression is very useful. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Jimbo" <Jimbo@discussions.microsoft.com> wrote in message > news:5AAEF3B2-0212-42EF-AF86-271583B6A073@microsoft.com... > > Capture the user login, use that to lookup your own security table to > > determine what they can/cannot see - use this data to filter your report. > > > > > > > > "MIB" wrote: > > > >> Thanks for your help. > >> We are using reporting services on a server (B), but the data are on an > >> another server (B). I have applied security for different type of > >> report, > >> but i would like to know how could i for one report filter data for each > >> user. > >> Example: I have a report on Sales USA, only people in the groupe > >> SALES_USA > >> can access to the report, but when a rep of NY is opening the report i > >> would > >> like to filter for this rep, on the same way for the rep of LA. So each > >> rep > >> will only see data concerning his city. > >> Again thank you > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |