Hi Rashid, the way to do it is to use unbound controls on the report, and use VBA to change their control sources, field names, label names, etc. when the report opens. More detail is in this forum thread:
This is not a trivial task due to the tricky VBA code and caveats involved. Consider exporting the crosstab query to Excel instead, and print it there.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
