Hi all,
I have a datasheet with over 20000 records and for generating various
reports I created a userform with a combobox that contain my report names. I
would like for each selection and press the button a "program" automatically
create a previwe report.
But,as I am ignorace in reporting I kindly ask you to help me about these
questions:
1.what is the best and fast way to generate reports?
2.Is it necessary I create a pivot table for each report?
3.How can I have a report preview in the word?
Thanks in advance
Bijan

Hi,

1.what is the best and fast way to generate reports? - that depends on what
your data looks like and what you want the report to look like
2.Is it necessary I create a pivot table for each report? - its never
"necessary" to create a pivot table, although it may be a good idea, but that
depend on the same things I mentioned in question 1.
3.How can I have a report preview in the word? Why preview in Word? Do you
want to print it in Word. I hope it's a little report, Word may not be the
best place to print a large report. And Excel has Print Preview.

Cheers,
Shane Devenshire


"bijan" wrote:

Hi all,
I have a datasheet with over 20000 records and for generating various
reports I created a userform with a combobox that contain my report names. I
would like for each selection and press the button a "program" automatically
create a previwe report.
But,as I am ignorace in reporting I kindly ask you to help me about these
questions:
1.what is the best and fast way to generate reports?
2.Is it necessary I create a pivot table for each report?
3.How can I have a report preview in the word?
Thanks in advance
Bijan