Dynamic Reporting

P

phuser

I am trying to make a Dynamic Report from a Crosstab Query and have tried to
use the VBA code that a couple different websites have provided but I just
cant get it to work.

Page Header contains 15 unbound fields head1 to head15

Detail contains 15 unbound fields col1 to col15

Report Footer 15 unbound fields tot1 to tot15

the 1st 5 Rows of my crosstab are text and the other 5 to 10 fields are
currency or standard (makes no difference if the code would work)

Would like to populate the unbound fields (of course) and hide the fields
not populated.

Any Help would be deeply appreciated...
 
P

phuser

Ok I was able to get it using the Microsoft "How To" but now my issue is
page size, if the report only generates 5 Data columns is there a way to
print to letter size instead of legal?

Pushing my luck right :)
 

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

Need some PWA help 0
Report with conditionnal formatting issue 0
Clearing Fields in a Word Form 5
Converting GPS coordinates to decimal in Report 0
Dynamic form 3
Group totals in dynamic report 3
Insert Index into a Table 1
Problem with unbound fields value 2

Top