Dynamic Parameters

Last Post 14 Jun 2004 09:00 PM by oldtang. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
wonderblast
New Member
New Member

--
10 Jun 2004 06:23 AM
I am trying to create a subscription for a report that has a datetime parameter. I was wondering if there was a way to set the parameter to the current date that the report is being executed. I have tried using "@ExecutionTime" and it rejects it since its not in a date format. Would it just be better to create a seperate report just for the subscription and use GetDate() directly in the stored procedure?

(The current report needs to have the date user-entered so they can run it for any date)
oldtang
New Member
New Member

--
14 Jun 2004 09:00 PM
You can use data drive subscription to solve this problem. Just like use Sql command:Select getdate() as GDate.
You are not authorized to post a reply.

Acceptable Use Policy