Problem rendering Reports with sub-reports to CSV

Hi, all.

Hope all is well with you. I have a Q re Reporting Services, hope someone can help me out. My setup: SQL Server Reporting Services 2000 SP 2, running in W2K3, Visual Studio 2003.

I have a report made up of a few sub-reports, stacked on top of each other. When I render the main report in Report Manager (HTML), the sub-reports comes out on top of each other as designed in the Layout, similarly when I export it to PDF.

However, when I export the main report to CSV, all of the sub-reports come out next to each other, rather than on top of each other, as originally designed.

Does anyone know how to overcome this problem?

Thank you very much.

Cliff.

Unfortunately the CSV renderer is not at all a layout renderer -- it just emits the data without too much regard for layout.|||

So, are you saying that there's probably no way around this problem?

Thanks.

Problem Reading .CSV file data from reporting services

Hi,

In our application we are using DTS to import data from .csv file. now they came up with a requirement to compare data in .csv is exact match with imported data in the table using a report.

i had hard time to implement this. we tried two options to do so..

1. reading .csv file with custom extensions and rendering it on report (problem is datasource file name was standard, where a i am planning to read it from a table).

2. We have a separate DTS to read data from .csv but when we are accessing it from reproting services i am getting "Multistep OLE DB access error".

Can some one guide me right way to implement my requirement.

Thanks,
-Geeks..

You can use the XML rendering extension to output just the data in the report. then use an Integration Services (formerly DTS) package to compare the input and output data.

Hope that helps,

-Lukasz

Problem Reading .CSV file data from reporting services

Hi,

In our application we are using DTS to import data from .csv file. now they came up with a requirement to compare data in .csv is exact match with imported data in the table using a report.

i had hard time to implement this. we tried two options to do so..

1. reading .csv file with custom extensions and rendering it on report (problem is datasource file name was standard, where a i am planning to read it from a table).

2. We have a separate DTS to read data from .csv but when we are accessing it from reproting services i am getting "Multistep OLE DB access error".

Can some one guide me right way to implement my requirement.

Thanks,
-Geeks..

You can use the XML rendering extension to output just the data in the report. then use an Integration Services (formerly DTS) package to compare the input and output data.

Hope that helps,

-Lukasz

problem on importing datas from .csv file to sql 2005 database using DTS

Hello,

I'm running into an issue on importing datas from a .csv file to sql 2005 database.
All my datas has been imported successfully but the datas with doublequotes(") are imported along with additional double quotes.
For example, a cell has the data, iron rod - 34" and this has been imported as "iron rod - 34"""

Can anyone please help me to come out of this issue.

Thanks.

Raviraj Danasekaran

If you are using integration services wizard then set the text qualifier to " in the flat file source connection settings