sorry, yes I see your point on protecting those reports.

instead of giving reportmanager access to the users, give them the reportviewer links (use reportviewer control in asp.net, or HTML page with reportviewer links, sharepoint etc). But still if your...

in that case best way is to use reportviewer instead of reportmanager

if the field values to be concatenated are coming from dataset, create a hidden parameter and assign this field (the one which you want to concatenate) as default values to...

I use RSScripter.exe

http://weblogs.asp.net/akjoshi/archive/2009/01/29/using-rs-scripter-to-create-deployment-script-for-reporting-services.aspx

Totally Agreed. I worked in Bangalore, Chennai, Kentucky & now in New Jersey. The reason jobs are outsourced is because of cost of labor since labor is cheap in India....

oh ya Power-Pivot, when our users are still struggling to use excel 😛

Try using the DB tuning advisor.. it will suggest what indexes/statistics are missing. But dont blindly apply the recommendations. Those recommendations will help in fine tuning your query.

WORK FOR A LIVING.. DON'T LIVE FOR WORKING 🙂 ENJOY LIFE! IT WONT LAST FOR LONG!!

thanks Dave, will try this out. will try with 2 test servers.

Hi Dave, can you please let me know how you use DNS entries to point to correct server or change server? We currently hardcode the url's with server name which...

Nice article! Quick question, sorry if its silly. If use is accessing reports from a front end application using url's like http://SQLTEST01/ReportServer/Report1 or http://SQLTEST01/Reports/Report1, then if...

I agree to a certain extent that nothing is free in this world.. but not everything is about money.. how about wikipedia I think they survive on donations & user...

I am sorry but isn't Java free? and isn't it a career path?

nice tip.. I have played around updating the subscriptions table also.. because we needed to email the same report to 70 users, by just changing one user parameter on the...