report design question

rbuser

I am new to report builder. I have some questions on how to design reports.

For example,
I need to design reports from a customer table.
I have a form that asks questions like:
group by State or SalesRep
order by CompanyName or State+Company
detail - multiple line ( full address ) or list - one line per record

Do I need to use multiple tppReport components and call the right tppReport?
( One for group by State, one for group by SalesRep, one for detail .... )
What is a good approach?

I also want to save the report template to a database table. Then, how does
that work?

My problem is I need to write a lot of reports and I try to use fewer forms
if possible.

Thank you.

nardmoseley

1. See the Templates of the Tech Tips newsgroup for information on
loading/saving reports to a database.

2. You can either create one report template for each user option or you
can dynamically modify the report template after asking the user
questions. See the articles in the Code Based thread of the Tech Tips
newsgroup for more information on creating reports/objects in code.