CSV export displays grouping field text in every row
Hi everyone,
I need your help please.
Everytime I export a report as CSV, a grouping field that is displayed (correctly) in the report is replicated in each row of the CSV. For example:
Column,Value,Count
Column1,Column_1_Value,Total: 2
Column2,Column_2_Value,Total: 2
Column1,Column_1_Value,Total: 2
Column2,Column_2_Value,Total: 2
The report structure is stored in a RDL file. The question is, is it possible, and how, not to show the last column, and rather show it at the end?
I know that is not
much information, but since this is
a business project can not display
much more information such as source code.
Any hint is welcome.
Thank you
January 12th, 2012 12:48pm
Hi
CSV is free format file ,there is no way to have the same format
you can have it in Excel
Sanjeewan
Hope this will help you !!!
Free Windows Admin Tool Kit Click here and download it now
January 12th, 2012 12:51pm
Hi Sanjeewan,
Thank you for your reply.
I haven't understood your answer. What do you mean by "there is no way to have the same format"?
The objective, if possible, is to have something like this:
Column,Value
Column1,Column_1_Value
Column2,Column_2_Value
Column1,Column_1_Value
Column2,Column_2_Value
Count, Total: 2
January 12th, 2012 12:57pm
Hi,
why did'nt you try Excel
In csv we can not have specific format,
there was same quetion in fourm please go through the link
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/a14da95f-b3e0-44b7-ab5f-ed04e0d90817
Sanjeewan Hope this will help you !!!
Free Windows Admin Tool Kit Click here and download it now
January 12th, 2012 12:59pm
Hi Sanjewan
It have to go through a
company's decision, but yes, Excel is
a good solution. I will pass the information
I could gather.
Thank you very much for your help.
Regards
January 12th, 2012 1:04pm