Passing Variables to a Report Recordsource

R

Ryan Langton

Do I need to do this using a stored procedure?
I need to generate a report based on values from global variables
(varStartDate and varEndDate). Whenever I try to use these variables in the
report recordsource query I am getting errors that they cannot be found.

I have not used stored procedures before.
 
A

aaron.kempf

variables like that; i always just store them in a table; and then it
is easy to bind these to the correct fields using subqueries.

i just think that it's more efficient to store all the logic on the
server than pass variables around and things like that

-aaron
 
Top