garbage data on first line of SSRS report when exported to CSV

[Glowworm27]

I have an SSRS report, that returns data that we need to send to a main frame.
The main frame will accept a CSV file, so we created a subscription to email the report in CSV format to the main frame.

Problem is when the report runs, and the csv file is generated the first line of the report contains garbage data. "MYDATA". The main frame rejects the file saying it contains bad data.

The next lines of the report are perfect and if you manually delete the first line of garbage, the main frame will accept the file without an error.

Please tell me how to get rid of this crap data from my CSV file export.
THanks


George Oakes
CEO & President
COPS Software, Inc.

http://www.cops2005.com

Programmer & Developer
.Net, WSS 3.0, SQL DBA
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net

 

[Crowley16]

if you're just sending a csv out then do you really need to use SSRS?
From what you've described, it seems like a scheduled job running a t-sql script to do everything would be much more straight forward and give you more control over the csv output.

--------------------
Procrastinate Now!

 

[Glowworm27]

Well its not only sent out as a CSV, others use the data for spreadsheets, and reporting elsewhere, so an SSRS report makes sense here.

George Oakes
CEO & President
COPS Software, Inc.

http://www.cops2005.com

Programmer & Developer
.Net, WSS 3.0, SQL DBA
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net

 

[Crowley16]

If you have to use ssrs, then check the report to see if there are any other data or components.
The export functions try to mimic the actual report in layout, so if you have any extra data say like a header or something, then they may get exported.

Have you tried exporting to other formats to see if it generates the same thing?

--------------------
Procrastinate Now!

 

[Glowworm27]

There are no other data components on the form simply the fields
that are layed out on the page.

All other formats display the data correctly.
with one exception, in Excel the first line is blank(where the headers might be, but there are no headers in the report) the rest of the formats are fine.


George Oakes
CEO & President
COPS Software, Inc.

http://www.cops2005.com

Programmer & Developer
.Net, WSS 3.0, SQL DBA
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net

 

[Crowley16]

It sounds like there's some extra stuff in there somewhere.

Try creating a completely blank new report and then copying the relevant bits across. Only use a single table control on the report...

--------------------
Procrastinate Now!