Post reply

Export to Excel using SSRS 2005 contains formula in a cell

  • 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!

  • January 31, 2010 at 1:32 pm

    #1111362

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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply