Deploying Reports - What do I need

  • ok. Let me understand ur question here. So u will be in charge of run and emailing the reports to the user every month. Also from ur message, u do not want to install RS on production server. If u are only person who is managing in terms of running and emailing the reports, u do not need to install RS on the prod DB. But for u to connect to the prod DB from ur development environment, u need to change the RDS connection in RS from Dev to prod and then run the report.

    However if the you want to empower the user to run their reports and have ur burden moved to theirs, u need to install RS on the production db server. Once that is installed, from your RS, right click on Project -> Properties. Type in http://<proddbserver>/<foldername&gt;. The folder name can be anything. It will create that automatically. Once this is done, again right click on Project and the select Deploy. The report gets published in the prod db server.

    Hope this helps.

    Suresh

  • Yes I will be charge of reports and wanted to make sure I dont have to install anything on prodn db.

    Thanks for the reply... Thats what I was looking for .... It really helped... The advantage is I can email pdf reports if I use sql server reports when compared to other options...

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply