I have stored procs on sybase that I want to attach to access reports. I know that I can call the stored proc through a pass-through-query and then attached then name of that pass-through-query to the recordsource of the report. However, the stored proc has date parameters where the user chooses to see a particular cut of data. Since, I want the report to be multiply used i.e. 10 users may choose the same report but with different date ranges. Is there any way to write some code that can dump the data to the report (I know I could write a createquerydef etc.., but I would rather not use this). Does anyone know a way?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Attaching pass through query with parameters
- Thread starter canary
- Start date
See this post that I read that helps with the same thing.
thread702-58272
Create the query without the parameters, use a filter to open the report. Within the report or the query you can access the fields on the form. Just make sure to hide the form instead of closing it, and then when you close the report, you should close the form.
thread702-58272
Create the query without the parameters, use a filter to open the report. Within the report or the query you can access the fields on the form. Just make sure to hide the form instead of closing it, and then when you close the report, you should close the form.
- Status
Similar threads
- Locked
- Question
