Passing Variables to a Report Recordsource

[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.

 

[chakatheapeman]

ACC2000: How to Reference Parameters in Reports

I'm in the process of making my access apps use nothing but server side objects like SPs. I think it is a good practice. I have found that access has allot of futures to help ADP developers use SPs that are not well documented. Unfortunately I was going to do the reports last, so I can't say that I have used this article. I plan to.


http://support.microsoft.com/default.aspx?scid=kb;en-us;208630

 

[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