Creating Dyanmic Reports

Hi,
Iam Using Sql reporting services 2000, I am running a report using a report viewer in a .aspx page every thing works fine except the print button, is is not displayed in the report viewer toolbar. any reason why is behaving so? Another main Issue is I want to create reports dynamically i.e. I'll will only one .rdl file(physical file) in which I want to display employee information, customers info or orders info from the respective table as per the users request. like if he wants to see emp info he'll click a button to load the emp records in the report and vice versa. First I want to know is it possible to do so if yes how can I achive this.
feel free to ask any doubts if you dont understand the scenerio.
Regrads
Adonis

Youcould do it dynamically but strongly suggest against such a design especially for three entities that are some far from each other such as employees, orders and customers. I cannot see a useful purpose.|||ADONIS -
Yes you can do!
But be aware as with any application developed "security" is number 1 -
So if you have a couple of "layers" that ensure authentication of the user - then "go for it" as well as ensuring there is some sort of encryption "over" the fields you do not want anyone to see! And since you are already writing ASP.NET there are a couple of hundred routines that will encrypt you data prior to the write and unencrypt after the select
Also, for your printing problem have you installed SP2 of MSRS?
SP2 of MSRS provides for intranet "wide" printing!
Best Regards
|||Hi,
Thanks for the timely reply, it is very helpfull for me. But you dint mention how do I do itdynamically?
please let me know in detail the procedure for doing itdynamically.
Regards
Adonis