Passing Variables to a Report Recordsource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ryan Langton - 26 Jul 2005 15:37 GMT

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.

Reply to this Message

aaron.kempf@gmail.com - 26 Jul 2005 22:40 GMT

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

Reply to this Message