Importing report content direct to SQL Server for testing purposes

Hi

I have what seems a simple requirement. We want to import the contents of a SQL Server 2005 Reporting Services report into a SQL Server 2005 database, in order to perform some checks on reports displayed to users. Is there an easy way to achieve this? XML would seem appropriate, but I can't find a step-by-step guide on how to achieve this. Any pointers/suggestions would be appreciated.

Thanks

Neil

Hey Neil,

If you export the report to CSV, it should be fairly easy to import that data back into your database using Integration Services.

Jarret

|||

Hi Jarret

Thanks for the CSV idea. However the reports are fairly complex, with a number of totals, sub-reports, etc, that would be difficult to make sense of with CSV. I guess that XML would enable the meaning of each value to be specified along with the value, and hence loaded more easily for subsequent checking. However, since I simply wanted to integrate two Microsoft products I was hoping there was an easy way to capture Reporting Services output and import into SQL Server. Could well be that I'm missing something obvious though - hence my request!

Thanks

Neil

|||

We have found a workable solution.

Create report subscriptions in Reporting Services to export the report content as XML.sql

Importing RDL from Server to VS

One of my staff members created a report and published it to the server. The
original Visual Studio project has been lost. Is there a way to import the
report definition from the server into Visual Studio for editing?
I realize that we could hand edit the RDL. I just want to try and avoid this.David,
I've found myself in the same situation in the past couple days.
Here's what I did (it may not be the best, most efficient way, but it
worked).
In Report Manager, click Edit on the Properties>General tab for the
given report. You should get a File Download window; select Save and
put the rdl in the folder where you want it.
In VS, create a new report project. Open Solution Explorer and right
click Reports. Select Add>Add new item then pick your rdl. You should
then be able to open it in Designer.
HTH
toolman
David wrote:
> One of my staff members created a report and published it to the server. The
> original Visual Studio project has been lost. Is there a way to import the
> report definition from the server into Visual Studio for editing?
> I realize that we could hand edit the RDL. I just want to try and avoid this.

Importing from Crystal Report 7 to Reporting Services

Dear all,

I was wondering if I can import reports made by crystal report 7 to Reporting Services 2000.

Thank you.This one isn't free, but may be worth a try for $5-$15.
Another consulting company, Hitachi, provides services to do this. See Post.
There is no built-in way to convert reports.

Importing from access

I have an access table with multiple data fields. When I add the fields into my crystal report all of the data fields show data except the date field.

I then imported the same table into a ms querry and the date field pulled the data in excel.

So there is data when I pull it into excel, but none when I pull it into crystal.

Any suggestions?Check the settings for --> File / Options / Fields / DateTimesql

Importing Excel "Reports"

I'm trying to import data which from Excel which has been "prettied up" to make it readable to users. The report has a fixed number of columns and the data itself is well structured, but there are blank lines etc.

The problem I'm having is unless the first row of the spreadsheet contains or headers, SSIS fails with error "External table is not in the expected format." and the exception below is thrown.

So I thought I'd be clever and create a template spreadsheet with the same number of columns and set the first row to strings - I made all columns DT_WSTR thinking I could extract the numeric and datetime data from the actual rows which contain data and convert using a script. But SSIS simply ignores the numeric values from the spreadsheet - all I get is String or Date values and nulls for all numeric cells?

Dave

Error at Monthly Balance [Connection manager "Excel Connection Manager"]: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "External table is not in the expected format.".

Error at Data Flow Task [Excel Source [1]]: The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.

Dave,

You may find the DataDefractor SSIS Data Flow Source useful. It's main purpose is to allow you to extract factual and contextual information from human-readable reports and then flow this data into the SSIS pipeline. You can download a free beta at http://www.datadefractor.com.

Cheers,
Vassil

|||Thanks Vassil, Looks like a useful component.

Importing Access Reports

Hi,
I'm trying to import some access reports into Report Services.
The reports are stored in a .adp file and connect to a MS SQL server database.
I'm using the import from Reporting Services in VS.NET, but am getting the
following error on 90% of the reports.
An error occurred while the report <<report name>> was being imported: The
given path's format is not supported.
Out of about 20 reports, it only successfully imports 4. All of the reports
work in the adp file fine. Have anyone seen this error before, and possibly
provide a fix or workaround to import the reports?
Thanks in advance.Anthony, hello. I'm getting this same error. Did you ever figure this out?
I would love to figure this out.
Thanks!
Shane Eckel
shane.eckel@.seattlesoftware.com
--
Thank You!
"Anthony" wrote:
> Hi,
> I'm trying to import some access reports into Report Services.
> The reports are stored in a .adp file and connect to a MS SQL server database.
> I'm using the import from Reporting Services in VS.NET, but am getting the
> following error on 90% of the reports.
> An error occurred while the report <<report name>> was being imported: The
> given path's format is not supported.
> Out of about 20 reports, it only successfully imports 4. All of the reports
> work in the adp file fine. Have anyone seen this error before, and possibly
> provide a fix or workaround to import the reports?
> Thanks in advance.
>

importing a pdf file

I have a business objects report that I would like to set up in reporting
services. I'm wondering if there is a way to import or display a link to a
.pdf file in reporting services.
Any ideas?
ThanksThere's no way to "import" PDFs, but you can include hyperlinks to external
PDF documents in Reporting Services' reports.
Best,
-Chris
SQL Server Reporting Services
"beeyule" <beeyule@.discussions.microsoft.com> wrote in message
news:82D55264-C23D-41D5-A809-4A838C334518@.microsoft.com...
>I have a business objects report that I would like to set up in reporting
> services. I'm wondering if there is a way to import or display a link to
> a
> .pdf file in reporting services.
> Any ideas?
> Thanks