Export to Excel using SSRS 2005 contains formula in a cell

• businessintelligence2010

  SSChasing Mays

  Points: 640

  More actions

  January 26, 2010 at 1:08 pm

  #209466

  Hello,

  In my report I have a field '=NOW()' and this captures the current date. But, when I go to export to excel file, it carries over this formula and I do not want that. What do I need to do so that when I export to XLS, the file gets exported w/o formulas. I appreciate your help with it. Thank you again!

• ken_martin

  SSC Journeyman

  Points: 85

  More actions

  January 31, 2010 at 1:32 pm

  #1111362

  Create an internal parameter which as a default value expression set to =NOW()

• rene-500237

  Hall of Fame

  Points: 3769

  More actions

  February 1, 2010 at 12:38 am

  #1111445

  Hi,

  another solution would be to format your date like:

  ="Format(Globals!ExecutionTime,"dd.MM.yyyy")

  Regards