Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ismailc
Constraint Violating Yak Guru
290 Posts |
 Posted - 2007-10-22 : 06:13:49
|
| Hi, I need help.I created a report via Rpt services wizard. I can execute the report via Start Debugging. I would like to deploy the report so that i can view it via http://I need to call the report via external app & pass parameters.This is what i selected in wizard. Report server: http://za001b78ad82c4/ReportServerCan anyone please assist or have an example on how to. Regards, |
|
|
Will H
Yak Posting Veteran
56 Posts |
Posted - 2007-10-22 : 13:26:14
|
| Before giving any advice, let me say that deploying reports is not always a straightforward process and you may run into multiple errors at any step. There are a lot of configurations that may not be set up correctly, and figuring out what is wrong isn't exactly straightforward.ON THE SERVER:First, make sure that your host has SQL Server with reporting services installed, IIS, asp.net activated. Go to start--> Programs --> SQL Server 200x --> Configuration Tools --> Reporting Services Configuration. Make sure that the first 6 items on the menu at the left are all green check marked, and initialization is also green. If you see a red X through anything, you are probably going to run into problems. As a quick test, on the host machine, fire up IE and go to http://localhost/reports . Even though you haven't deployed anything, you should be sent to the report manager. If you don't, you *probably* don't have permissions set up in IIS or SQL Server.ON THE DEV MACHINE:Open the report in Vstudio, go to Project --> Project Properties.TargetReportFolder can be anything, but should be a recognizable name for the report. TargetServerURL should be http://<SERVER NAME>/reportserver, In your case http://za001b78ad82c4/ReportServer. Or, just do http://localhost/reportserver to deploy to your local box. Go to Build --> Deploy Project. Cross your fingers, If everything is set up correctly, it will deploy everything to the server and you should be able to access it via http://za001b78ad82c4/ReportServer. ---------------------------------------------------------SSRS Kills Kittens. |
 |
|
|
|
|
|
|
|
Rep Serv, How to Deploy a Rpt http://