question

Jambai avatar image
0 Votes"
Jambai asked LukasYu-msft commented

How to get rid of the quoations (") in SSRS Report export

When the column length exceeds 99 character, I am getting an extra double quote around the column value. This is happening while exporting the report into a .csv or text file.
How to get rid of the extra double quote marks?

This happening while rendering the report, not in the query

Any help is highly appreciated.

Thank you

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered

Which version of SSRS are you using ?

Have you ensured that no such quote mark exists in the original datasource ?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Jambai avatar image
0 Votes"
Jambai answered LukasYu-msft converted comment to answer

I am using Microsoft SQL Server Reporting Services Version 14.0.600.1572.

I am absolutely positive there is no quote in the data source.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Last time I do the test with SSRS2019 . I will try to find a SSRS2017 machine see if I can replicate you issue.

But, I am worried this could be an extension issue which we cann't really do something about it. Anyway, we will do some test and see if we get any result. If you made any progress on this , you could also kindly share it with us here.

0 Votes 0 ·
Jambai avatar image
0 Votes"
Jambai answered LukasYu-msft commented

I do not belive its an extension issue, but I may be wrong. The quote (") appears when the column's data limit exceeds 99 character.

I found a work around thru SSIS.
In the Data Flow Task, keep the report (with quotes) as source and import the same in to an another flat file (since i want it in txt file). Adding text qualifier as " in the Flat File Connection Manager would create the file without quotes.

101831-image.png



image.png (22.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for sharing this solution, you may mark this as solution so other viewers could benifit from this !

Cheers!

(Actually I have tested a bit in my 2017 environment and the long string column did not have the quote mark but just disappeared from my csv exported file. I have not understood clearly why this happening. what I meant for extension , it the ssrs export extension. Also I have not found any limitation from the official site aboiut this issue. This is current remaining mysterious for me.)

0 Votes 0 ·