Post reply

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

  • November 5, 2024 at 4:53 pm

    #4477768

    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

  • November 5, 2024 at 5:32 pm

    #4477785

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

  • November 5, 2024 at 5:59 pm

    #4477786

    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