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?
-
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