Report format help

[EjS]

Hi,

I'm trying to build a report with the following format on the same page:

TotalA TotalB TotalC Total D
Name1 $$$ $$$ $$$ $$$
Name2 $$$ $$$ $$$ $$$

Option1 Option2 Option3 Option4
Name1 $$$ $$$ $$$ $$$
Name2 $$$ $$$ $$$ $$$

I can get the first row fine, but I'm not able to make it so the "Option1-4" row will go beneath the first row. Any suggestions? Thanks!

 

[fernin8r]

are you trying to sort them?

right click on the upper left box to bring up the report menu. Click on Sorting a Grouping. Enter in the field that you wish to sort. if you don't have a way to separate the option from the total create a new field in thier table and give total a 1 and option a 2 or somthing like that.

 

[EjS]

I don't think I want to sort them... I would like two page headers. This is the format I have right now:

TotalA TotalB TotalC Total D Option1 Option2 Option3
Name1 $$$ $$$ $$$ $$$ $$$ $$$ $$$
Name2 $$$ $$$ $$$ $$$ $$$ $$$ $$$

So I need to have the Option fields under the Total fields and still have the report sorted by the name field. Adding a header for one of the fields doesn't seem to work. Does this make sense?