How to Create Grouping report in Temporary Table

RudyHearties

Hi all,
i have data Temporary Table like this:
Category SubCategory Brand Qty
Category1 Sub1 brand1 1
Category1 Sub1 brand2 1
Category2 Subx Brand3 4
Category2 Suby Brandy 5

and i want create report like this :
Category : Category1
SubCategory : Sub1
brand1 1
brand2 1
Total SubCategory Sub1 2
Total Category category1 2
Category : Category2
SubCategory : Subx
Brand3 4
Total SubCategory Subx 4
SubCategory : Suby
Brandy 5
Total SubCategory SubY 5
Total Category Category2 9
GrandTotal 11

how to make create this report using temporary table, i have index (Category,SubCategory)

Thx
Rudy

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV/Navision' forum]

First : this may help you : http://www.mibuso.com/howtoinfo.asp?FileID=6
Second: to make it easier, you might want to create some extra temptables : 1 temptable per group for each combination that exists. This way is it will be easier to create the report.

ssingla

How about this one
http://www.mibuso.com/dlinfo.asp?FileID=403