Post reply

Report subscription with Sysdate as default Parameter

  • June 24, 2008 at 2:08 pm

    #188414

    We are trying to create a report subscription and the report has a date parameter. Instead of hard coding the value, we want to use sysdate as default while creating the subscription.

    the report will run daily based on sysdate and produce output.

    We can do it in the report, but is there a way to specify sysdate as default parameter on subscription page?

    Any help is appreciated..

  • June 25, 2008 at 7:50 am

    #833968

    Are you using stored procedures?

    Try something like this if you are

    create procedure showdate

    @inputdate datetime = '01/01/9999'

    as

    if @inputdate = '01/01/9999' set @inputdate = getdate()

    select @inputdate


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

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

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