How to/is it possible?...
Im new to reporting services,sitting here with the "hitchikers guide" book, and got some unanswered questions.
What im trying to do:
I have finished the report layout, it has a table with 6 columns for holding client specific information. Each client of mine will then get this report emailed to them.
The sending of the report to each client is not a problem, i understand how to fetch the email addresses to send to, from my mssql database. The problem is, how do i do so client A only has information in his report that is relevant him, not anyone else. As of now, every email sent out, holds basicly everyones information.
The information for the whole report is stored in one database table(generated from a scheduled stored procedure). The table has one column, "email" specifiying who the current row information belongs to.
Im thinking it has something to do with report parameters? but im not sure and cant find anything that explains this to me.
Hopefully, someone here with more knowledge than me, can help me out.
regards,
xeno
