CODEWITHSUNDEEP
.netreporting-servicesssrs-2008reportingservices-2005
Sravanti
Sravanti

Reputation: 1407

how to export more column records in excel when click on view report in ssrs?

I want to show limited columns(10 columns) initially while rendering report output and after selecting excel export option ,click on view report then i need to export more columns records (40 columns data) in excel output.anyone give an idea to achieve this

Upvotes: 0

Views: 31

Answers (1)

Hakunamatata
Hakunamatata

Reputation: 1275

Right click on the columns you want to hide and setup Column Visibility as "Show or hide based on condition" and setup below expression as condition.

=Iif(Globals!RenderFormat.Name = "EXCEL", True, False)

Upvotes: 1

Related Questions