posted yesterday--grouping

[aheath15]

My report will display a list of products. Some products have sub assemblies
within them, some do not. In fact, some of the sub assemblies have further
assemblies within them (so there are 4 leves total, with 3 levels of sub-data
sheets ultimately stemming from the master product table). In my report, I
need to have ALL products listed, whether they are a sub-assembly product or
on the master product table itself, AND I need the format to look as follows:

Product 1
Product 1A
Product 1a
Product 2
Product 3
Product 3A

etc- it needs to be clear which products belong to which assemblies.

My problem is that the report gets messed up since the 'levels' for each
product are not the same (see above that product 2 does not have a product 2A
or 2a level). What is the best way to accomplish this?

Another quick question----after making a report, is there any way to change
the info source?? this would be extremely convenient. i have been trying to
change the 'control source' in the properties window of whatever field i am
trying to change but errors always come up.

thanks for any help!! it is greatly appreciated!!

 

[Duane Hookom]

I would probably use subreports for each of the sub-data levels.

I don't have a clue what you mean by "info source". What are you attempting
to change and why?

 

[aheath15]

Thanks for you suggestion for the first question, I will give that a try. I
will try to clarify my second question...

For example, I have a report that displays Product ID Number, Price, and
Quantity. Is there any quick way that I could just change it to Product
Name, Price and Quantity through some report property? I'm trying to figure
out how you can change the 'fields' that are on a report after you have
already gone through the wizard and specified other (incorrect) fields. Is
this possible without making a new report?
Where does the report store the information that was specified when
selecting fields in the wizard and can that be changed? Can other formatting
information be changed after using the wizard as well--like grouping levels,
etc-?

 

[Duane Hookom]

You can open a report in design view and change lots of stuff including the
Record Source of the report and Control Sources of text boxes.