Hi, I am trying to do exactly what Greg is/was trying to do so any help that you can provide would be greatly appreciated.

e.g.

For a worklog report that uses the following stored procedure (spS_WorkLog_WithNames) how can I access the parameters @FromDate and @ToDate and include those on the report? I need to be able to print the period that the worklow report is for to make it useful.

In the Help file the listed Global Variables are shown as

• rptTitle
• rptSelectedProject
• rptPrintHTMLDetails
• rptSelectedGroupField
  

ALTER  procedure [dbo].[spS_WorkLog_WithNames]
(
    @ItemTypeId int = null,
    @ItemId int = null,
    @FilterByProjectSelection bit = 1,
    @ProjectId int = null,
    @CustomerId int = null,
    @CustomerContactId int = null,
    @UserId int = null,
    @IncludeInactiveProjects bit = 1,
    @IncludeSubProjects bit = 1,
    @WorkLogTypeId int = null,
    @FromDate datetime = null,
    @ToDate datetime = null,
    @IncludeArchived bit = 0,
    @orderby nvarchar(4000) = N'',
    @page int = 0,
    @rowcount int = 0,
    @debug bit = 0
)

 If anyone knows of a way to access that or how to print a min or max date on a report then please please reply. I can build a report from scratch using access but I would prefer to have the report as a part of OnTime.

Cheers,

Chris