November 5, 2024 at 4:53 pm
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?
November 5, 2024 at 5:32 pm
how can I drop a table if exists in Visual Basic 2017 SQLExpress
November 5, 2024 at 5:59 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy