Displaying a user input entry on a report

E

Ernie Sersen

I have an ADP connected to a SQL backend. My SQL back-end creates a
temporary table for me using a Stored Procedure that only pulls records from
a master table based on input parameter prompt @As_Of_Date. Once the temp
table is created, a function is executed that further refines the dataset and
a report is created from the results. I would like to know if there is any
wayt that the @As_Of_Date can be brought forward to the final report. If
not (since the Stored Procedure has already run and is closed) are there
other options? Could I create a prompt from within the report for the user
to re-enter the As_Of date and have this prompt pass the date to the report?
I hope this is not too confusing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Creating a Search using a combo box and then creating a report. 4
Pulldown for Report Input Fields 5
Report Input Parameters 2
Adding a checkbox to an Access 2007 report 1
Confusion over where user templates are stored in Word 1
user input for report 3
Prompt user to input what data to be displayed on Report 3

Top