I'm using Report Builder 3.0 with an imbedded script to generate a report for client in CSV format for input purpose. The SQL script gathers the desired data, inserted into a temp table and "creates" a new column with is the concatenation of some columns, like this:
SELECT T1.A,T1.B,T1.C,T1.D,[Delimited Row]=CONCAT(T1.A,",",T1.B,",",T1.C,",",T1.D) INTO #T2 FROM T1
. This [Delimited Row] is the only row used in Report Builder, the column header was deleted and works just fine. The problem I'm having is that when exported as CSV and opened in Notepad (example file attached and image below), I'm seeing the textbox's name as first row and each row under it is double quoted. I've tried changing the DataElement Output property to NoOutput at the textbox level, putting the column header back and setting the column header DataElementOutput property to NoOutput and the textbox's property to Output or Auto but still see the Delimited_Row text as first row. I also want to get rid of the double quotes qualifier but no success either. Can anyone help with this?
Thanks in advance!