Was afraid you where going to say that..:laugh:..the Network Admin and I were thinking on those lines the other day. It is nice to have it confirmed by some one...

Good info, but how are you building the reports? We use SQL Server 2005, which has the BIDevStudio (aka VS2005) and that's were I build. Being self taught all this,...

From my exprience, the .rdls are built in the VS2005/BI (if running SQLServer 2005) and then from there deployed to the Report Server (http://servername/reports) where you access them...

Yes, they use the same data source, with different datasets.

SQL

Data Source=joesqldata;Initial Catalog=dbname

False

False

Integrated

True

...

At the moment it is just their Active Directory creds for the network, I belive, our network admin has set up all that. I just control the Report Server.

Kerry,

Can you elaborate on this process? I am a BDA in training and can create SSRS reports with parameters(which is really fun) but am lost as a deveploper (boss loves...

And 'Thank You, Vijaya" for your help!!!!!

Karen

Ok, I am not sure if I am following you here. I am using a shared data source. This is based off a table that has something like 20 columns...

The end user will access the Reporting Server with preset premissions. From their folder/report group/home page they will pick "Report A", it opens and then they pick form each parameter...