Hey, I have a report that when opened, asks the user to enter a parameter.
Everything is okay except, I want this parameter to also be the header caption for the report. How can i accomplish this?
Thanks in advance!
Hey, I have a report that when opened, asks the user to enter a parameter.
Everything is okay except, I want this parameter to also be the header caption for the report. How can i accomplish this?
Thanks in advance!
does the param come from a query? if so, I don't believe you can use that as a caption too. But, you can make a form that looks like a popup box, throw the input from there to a var and then use that var to change the title of the report before it's opened via a line of code.
Code:reports("report name").caption = "whatever"
Er, Yes is does come from a query. Fair enough, I will try to do it via form and ask if I need help from there. Thanks!
Or you can add a txt box in the header of the report and add a control source - something like this:
="Between" & " " & [Enter Start Date] & " " & "Through" & " " & [Enter End Date]
Only problem is the underlying query asks for start/stop dates and then so does the report. but it works.