problems in showing all data in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have to names in a table that are identical when producing a report i see
all sales grouped to only 1 name please help : )
 
That is what grouping does. If you are grouping by two names and they are
identical then you need another field to group by. Do you have some unique
value associated with the names?

If so, try
Sorting by the names (to give you the order you desire) and then
Grouping by the unique value.

Use the sorting and grouping dialog of the report. (View: Sorting and
Grouping)
 
if this report is a result of a query, try going into the SQL format of the
query and typing "DistinctRow" after the "SELECT" clause in the sentence.
 
Back
Top