Hi guys..thank u for quick response....i am now using maintenance plan for it..created maintenanace plans for full database backup as well as for transaction log...

Regards,

Abhay

Hi,

I have used protection level "Encrypt sensitive data with password"and set the job step type to "SQL Server Integration Services Package"...but i dont know how to include the decryption...

Redirection can b done on front end...

For example.. i have a site on which user logs in and i have two user groups PM and TM.

I created two aspx pages...

Hi,

we cannot write expressions for visibility of Report parameters.

You can do one thing..create three different reports for sales representatives,area managers and directors group..

n depending on userid redirect to corrosponding report...

Feel...

Hi,

Have u created report parameters year,,month,server,DB?

If yes then pass these report parameters to ur SP in dataset n u should get the desired output.:-)