Post reply

Using Subscript With dynamic parameters

  • August 4, 2005 at 1:34 am

    #152495

    hi there

    if i want to send a daily,weekly... email with a report which has 2 parameters:

    @FromTime,@ToTime and i want them 2 B=> @FromTime = yesterday 6:30 AM

                                                                 @ToTime=today 6:30 AM

    How can i do it???

  • August 5, 2005 at 5:48 am

    #579955

    If you're using a stored procedure for this, one solution is to check in the procedure if the report is passing through a parameter.  If blank, then manually set the values for the From and To based on the current system date.

    Dave

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

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