Hi,
I am using ssrs 2008. I have a report where I need to label same name for multiple columns.For example, the result would be like the below:
ID Fee Fee Fee Fee
123 $45 $30 $20 $65
In sql, I labeled them as Fee1, Fee2, Fee3, Fee4. In SSRS, I call these Fee1 to Fee4 and for report header, I label them with the same name that is Fee for all 4 columns.
I have no problem when exporting to excel or pdf as the header displays same name for me. However, when I export it to csv, the header name display as Fee1, Fee2, Fee3, Fee4. As one of the requirement, I need it to display with same name that is Fee for all 4 columns. Is it doable? Thanks so much.
I am using ssrs 2008. I have a report where I need to label same name for multiple columns.For example, the result would be like the below:
ID Fee Fee Fee Fee
123 $45 $30 $20 $65
In sql, I labeled them as Fee1, Fee2, Fee3, Fee4. In SSRS, I call these Fee1 to Fee4 and for report header, I label them with the same name that is Fee for all 4 columns.
I have no problem when exporting to excel or pdf as the header displays same name for me. However, when I export it to csv, the header name display as Fee1, Fee2, Fee3, Fee4. As one of the requirement, I need it to display with same name that is Fee for all 4 columns. Is it doable? Thanks so much.