Report formatting question

[smueller72]

Hi all - My apologies in advance if this is a simple question or has been answered in these forums(I couldn't find an exact match when searching).

I have a table that contains client #/name, invoice count/amount that is grouped by year/quarter.

I will group the report by year and I want the invoice counts/amounts to be displayed by quarter all on the same detail line rather than having to group by quarter also. The resulting report should look something like:

GH1: Year
GH2: Q1 Q2 Q3 Q4
D: Client Count/$Amt Count/$Amt Count/$Amt Count/$Amt

Hopefully this makes sense. Any help would be greatly appreciated.

 

[lbass]

Please don't post the same thread in multiple forums. I responded to your other thread.

-LB