Best way to publish 2012 SSRS reports on the web

Question

Best way to publish 2012 SSRS reports on the web

Zososql

Ten Centuries

Points: 1218
More actions
December 31, 2016 at 4:01 pm

#317145

I have created a series of reports via vs2010shell - SSDT - sql2012, wondering whats the best way to publish these on an intranet where other workers can access them. They would be interactive (enter date range, export to excel if necessary)
Thanks in advance
Zo

Viewing 7 posts - 1 through 6 (of 6 total)

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

Alan Burstein SSC Guru Points: 61141 More actions · Answer 1

Zososql (12/31/2016)
I have created a series of reports via vs2010shell - SSDT - sql2012, wondering whats the best way to publish these on an intranet where other workers can access them. They would be interactive (enter date range, export to excel if necessary)
Thanks in advance
Zo

If you have set up an SSRS server correctly the process to deploying reports is pretty straight forward. You specify what server you want to deploy your reports to in Visual Studio (SSDT). When your report is ready you right-click on it and click "Deploy". The report will then be available to people with access to that server.

SSRS reports are interactive so there's nothing special you need to do once the report is deployed.

Does any of this not make sense? Any questions?

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

Thom A SSC Guru Points: 99130 More actions · Answer 2

On the subject of allowing others to view, will they be accessing the report web portal directly (is that your intention, or how you want them to). If so, you will need the ensure the users, or the group they belong to, have access to those reports, or the folder they have been deployed too.

Do you have a "game plan" for how you would like them to view the reports?

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Zososql Ten Centuries Points: 1218 More actions · Answer 3

Thanks for the insights- i will have more of a detailed gameplan after re-testing the series of reports i have generated and could come back for more info.

Zo

Jeff Moden SSC Guru Points: 1004353 More actions · Answer 4

As a bit of a sidebar, it's a real shame that they got rid of sp_MakeWebTask. It was an incredible tool that made SSRS look a bit silly for stuff like this.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ESAT ERKEC SSCertifiable Points: 5661 More actions · Answer 5

If you don t have mobile deploy I used it

smart app.

MMartin1 One Orange Chip Points: 27795 More actions · Answer 6

Right click the solution name at the top of your solution explorer tab. Select properties and under the general configurations node there is on the right window pane a section name Deployment. You set the values here for the server you are deploying to.

For instance the targetServerURL property will have something like : http:\\serverName\reportserver

Another thing you can do is navigate directly to the SSRS reporting site with IE and if you have the proper permissions you should see a link to upload a report there and you navigate to the .rdl file location to select it.

I prefer the first way since you have control over things like shared data sources.

----------------------------------------------------