Export SSRS report into Excel w/o formula

  • Hi - I have a report in SSRS and it has a field that captures today's date. But, when I export this into excel, it still carries over '=NOW()' formula and I don't want that to happen. Please suggest how can I do that. Thank you.

  • Set a variable someplace and then have the field use that. Or maybe add a data source that's just SELECT GETDATE() and use that for your value. If RS can't automate it you'll just get data.

    [font="Arial"]Are you lost daddy? I asked tenderly.
    Shut up he explained.
    [/font]
    - Ring Lardner

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

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