Dynamically building and swapping out of columns, how?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Actually, what I need is to ask how can I build a report allowing for
the Dynamically building and Naming and swapping out of columns with their
header labels as they contain no values for those with values. Of course,
there will come a time when all columns will have a value, then, I'll need to
print the data result another way.

Suggestion need for that too!

Any suggestions out there? Thanks again for taking the time to read this
modified post. Is this even possible?
 
Jay said:
Actually, what I need is to ask how can I build a report allowing for
the Dynamically building and Naming and swapping out of columns with their
header labels as they contain no values for those with values. Of course,
there will come a time when all columns will have a value, then, I'll need to
print the data result another way.
Click to expand...


First create the report with all the controls and
sorting/grouping levels you'll ever need. Then write a
bunch of code in the report's Open event procedure to
manipulate the control's Visible property. For those that
you do want to appear, use more code to manipulate their
other properties (position, Caption, ControSource, etc) to
get the right values to appear in the desired locations.

This requires a significant amount of VBA code, are you
ready for that? And please don't come back with another
generalized question such as "could you get me started".
Newsgroups are most appropriate for specific questions.

Play around with a simple test report, gradually making it
more complex until you understand all these issues.
 
Back
Top