Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    45

    Unanswered: Using variables instead of table to source report...

    I need to generate a report using vba variables as the data, as opposed to a table. Is there a way I can open a report and assign variables to the report's fields at the same time, or do I need to copy the values to a table and use that as the report source?

    Thanks!

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    i do see the word 'need'
    ...and i have to ask if you are really sure?

    apart from that minor reservation, yes.

    look at the report's detail_format event: treat the report like a form - make a box, fill it with whatever you like, done.

    izy
    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •