Show some fields but export all

• bindia.wahab

  Say Hey Kid

  Points: 711

  More actions

  February 18, 2010 at 3:06 pm

  #215865

  Hi,

  Is it possible in SSRS reports to show just some fields in the report but export all the fields into the excel.

  For eg: The dataset has fields Name, Age ,Address, Phone, Email. We just show Name, Address, Phone in the report but when we export the data to Excel, all the fields(Name, Age ,Address, Phone, Email) are present in the excel workbook.

  Please advice

  Thanks

• veeren4urs

  SSCrazy

  Points: 2763

  More actions

  February 19, 2010 at 11:17 am

  #1122024

  Hi yes its possible,

  But u need to use the custom code for this .

  Here is my idea: create one parameter as "customExport" and set two default parameters Y and N hide this if u dnt want to show it to the user.

  Then in report code below the Export events

  Set like if export option="Excel"

  Then Set customExport='N'

  i hope it will works.

  Thanks & Regards,
  Veeren.
  Ignore this if you feel i am Wrong. 😉