Reporting Services

Question

Reporting Services

mlbrow5

Valued Member

Points: 57
More actions
September 8, 2008 at 8:20 am

#192627

Could someone please let me know how to add an existing report using Reporting Services 2005? Thanks in advance!:D

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

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

Not sure what you mean by "existing report". Do you mean a report built in some other application?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

mlbrow5 Valued Member Points: 57 More actions · Answer 2

I have an application that was built by another company and we are rebuilding it to suit what we need it to do. The reports included are what the other company uses I would like to add the reports I already have made to the program.

GSquared SSC Guru Points: 260824 More actions · Answer 3

Reports are just XML definitions. You should be able to just add them.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Mark Eytcheson Ten Centuries Points: 1262 More actions · Answer 4

I'm not sure if you are trying to add existing Reporting Services report(s), but if you are, you should be able to add the Report's rdl file to your new Reporting Services project.

Open the Reporting Services project you want to add the report(s) to -> Right-click Reports folder -> Add existing item -> navigate to the rdl file you want to add.

If you are using a shared datasource for the new Project, you'll need to make sure the rdl file you are adding can access that as well.

Brian Burke Mr or Mrs. 500 Points: 590 More actions · Answer 5

If you are trying to add a Reporting Services report, but the rdl file is not available to you, you can recreate/download it from the reportserver.In a browser go to

http://"ReportServerInstance"/reports

and browse to the report in question.

From the "General" tab under the properties menu you can choose "Edit", then save the resulting RDL file to be added to the project.

BTW,I'm presuming you have adequate permissions on the existing company's report server to do the above.

Old SQL Newbie Ten Centuries Points: 1060 More actions · Answer 6

I have also copied reports by opening the report (if you have access to it), View-Code, copy the HTML, and paste that into the code tab of a brand new report. This has fixed reports that suddenly started acting "toasted" for no apparent reason. You may have to fix the data source.