Parameterized report help

General information about Medisoft
Post Reply
drk
Posts: 155
Joined: Sat Oct 11, 2014 11:40 am
Location: Boston, MA

Parameterized report help

Post by drk » Wed Sep 06, 2017 10:37 am

I am trying to generate a report where the user enters a random date and it is matched to "Date Created" or "Date Modified" in the Transactions table. Using the built-in query designer, I can have the user enter the date twice during report generation. I would like the user to pick the date only once, and have that date matched to other dates in the Transactions Table.

Stated differently, how do I go about building a parameterized query where the parameter is not a field in the database? That is, gather user input for a new variable and use that to match specific fields in the database at run-time?

Post Reply