How to use a date range to open up a report?

  • The report that I want to open has an "ExamDate". I am trying to use the Action property to open a report based on a date range of the ExamDate as well as the two parameters seen in the screen shot. I tried to add a StartDate and EndDate using >=[ExamDate] and <=[ExamDate] but, got an error. Any thoughts?

     

    ActionProperties

  • how can I drop a table if exists in Visual Basic 2017 SQLExpress

  • Normally you use report parameters, kinda like you do in Abscess. Normally, you just include the parameters in your stored procedure...

    CREATE PROC ReportSP 
        @StartDate DATE,
        @EndDate DATE
    AS 
    SELECT [field list]
    FROM [tables]
    WHERE SomeDate >=@StartDate AND SomeDate < @EndDate;

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

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