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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics