Post reply

Deploying Reports - What do I need

  • April 7, 2006 at 11:24 am

    #171165

    Hi,

    I have installed reports on my workstation and I connect to DEvelopment db which is in network. I have created a report which I have to schedule to run and emailed as pdf automatically every month.I know I can use report manager to do this but I want this done on prodn site.

    My question is... what I need to do if i want to deploy this report to production db server (installing of reports on prodn db system is not an option as ppl wont agree to this) plus I need a simple solution like placing this report i.e xyz.rdl somewhere on prodn db so that I dont have to reinvent the wheel.

    Do I have to install reports on prodn sql server machine???

    thanks in advance...

    Thanks...

  • April 10, 2006 at 7:02 am

    #631698

    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

  • April 10, 2006 at 8:44 am

    #631756

    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 3 posts - 1 through 2 (of 2 total)

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