August 31, 2010 at 9:17 am
Hi
I have inherited an SSRS server and I want to add a new report to it.
My skills in building reports are decent but administering the server i am not great at.
I really dont know how to start going about adding a new report.
can anyone give me any pointers about what i should be doing or looking for?
thanks in advance
August 31, 2010 at 10:41 am
I suppose it all depends on how you are creating the reports and what your permissions are on the SSRS instance? I deploy (upload) reports directly from a Reporting Services Project from Visual Studio. If you are using the web based report authoring tools (Report Builder) you pretty much just need to save it to the server, but again you need the proper permissions. When you open up the report manager do you see the report builder button in the Reporting Services Toolbar?
-Luke.
September 1, 2010 at 3:36 am
by report manager do you mean the site or location where the reports are to be viewed?
and for instance if i had the permissions i should have a report builder option at the top?
sorry if my questions are basic
thanks for the reply
September 1, 2010 at 6:16 am
Yup, Report manager is the built in application from MS used to view/modify reports and such. By default it's available at http://yourreportservername/reports.
Depending on how you permissions are setup you'll see different things inside of that application. But in the end you'll need the publisher role for the folder you are trying to publish reports into for it to work.
Here's some more from Books Online (SQL Server's help files) dealign with publishing reports... http://msdn.microsoft.com/en-us/library/ms345236.aspx
-Luke.
September 1, 2010 at 6:46 am
another basic question
on the server where the report are kept you would expect some .rdlc files wouldnt you?
i cant find any of the existing reports on the server
September 1, 2010 at 6:54 am
September 1, 2010 at 6:56 am
ahh so how do i find them?
September 1, 2010 at 7:27 am
do i need BIDS installed on the server /machine that i will be editting the reports on?
September 1, 2010 at 7:39 am
hi,
U open Sql server business intelligence studio -> create new project by using wizard as report project.
Now right side of screen there is one solution explorer. You create share data sources by using right click. Then Add new report just below it by same process.
You can use wizard for that. Paste query and follow the instructions.
Its much easy n simple.
If you need any assitance from pl reply.
All the best.
Chintesh
it.development
September 1, 2010 at 7:40 am
It all depends on how it was created. Do you know if they used the Report Builder application or BIDS/Visual Studio? If it was report builder than there may not be any files, just someone opened it via the web browser, created the report and uploaded it to the server...
If it was created with BIDS or Visual Studio then there should be a report solution/project that has all of the original source files. I take it there's no documentation or way to contact your predecessor?
If nothing else and you want to use BIDS/VS to edit the reports, and/or recreate the source .RDl's from the report server you can use the reporting services scripter available http://www.sqldbatips.com/showarticle.asp?ID=62.
-Luke.
September 1, 2010 at 7:40 am
dunne.neal (9/1/2010)
do i need BIDS installed on the server /machine that i will be editting the reports on?
How good are you at editing xml directly?
I don't think it is necessary to have BIDS, but it is really useful to have a front end tool like BIDS to do reporting work. Although it is not really something that is typically installed on a server. Having a front end like BIDS also makes deploying the reports easy.
September 1, 2010 at 7:42 am
dunne.neal (9/1/2010)
another basic questionon the server where the report are kept you would expect some .rdlc files wouldnt you?
i cant find any of the existing reports on the server
You can't really see them from the server side since it's all contained in a few tables.
Assuming you are using the basic web interface in ssrs you can see a list of the reports there, but then again you need to have read permission to see them.
If you want to poke around, open SSMS, then connect to ssrs server (not the database engine).
Search for a database named reportserver or something similar. From there the table structure is pretty simple to decyher.
September 1, 2010 at 8:34 am
thanks again for the reply
the home page of the site that the reports can be accessed from is
from what you are saying it doesnt look like the reports were built in BIDS
so would you say that I need some publication rites in the folder <server>\ReportServer\Pages?
and then I should be able to edit reports through the home page browser through report builder? does reportBuilder need to be installed on the machine i am working on?
sorry for all the questions?
September 1, 2010 at 8:38 am
How can the reports not have been built in BIDS (or anything similar)? There's no way in hell that someone touched typed all that code in XML, in notepad from scratch.
As far as I know you can redownload the reports from the adress you just gave us (it's somewhere in the properties).
September 1, 2010 at 8:39 am
You can always search the network or dev computer for *.rdl* files.
The last star is important because there's a slim chance that the extension is rdlc which would mean an asp.net web application to show the reports.
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply