reporting services sql server 2005 service pack 2
what i wanna do is a bit like a data driven subsription but then on the report manager with a snapshot
1) i create a report with let us say all the account managers, customers, amount sold this for one month
so if i run this begin april i see the details from march and they wont change anymore
thats why i want to make a snapshot of it
so this is simple and it works
2) now a bit more complicated
i want that if a account manager go look on site, he only sees his customers, and the boss all the
customers from the account managers where he is boss from
3) so i wanna do this by a filter
4) i create another dataset with two output fields first is the one who logs on and sec is which
account managers he may see on the report
like account manager 1 account manager 1
account manager 2 account manager 2
boss 1 account manager 1
boss 1 account manager 2
5) so the data stays the same for the two datasets once it has run, so i want it as snapshot
6) but now it comes
i want a filter on my report so if account manager one goes look at snapshot that he only see
his data and if boss 1 goes look at snapshot that he see data from account manager 1 and 2
how i can make this filter ?
or is there another method to do this ?
important ! a report that refreshes everytime and give the same output as i want, i know how to do that
i really want to do this with a snapshot if possible so when the report is viewed hundred times
in a month it doesnt refresh hundred times, only once to make the snapshot
rest should be done by the filter
greetings
kvdi765
Start Free Trial
