|
Home > Archive > Getting Started with dBASE > March 2006 > reports with subcategories (groups)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
reports with subcategories (groups)
|
|
| Gabriel 2006-03-12, 3:23 am |
| How does one make decent subcategories on reports when some categories don't have subcategories?
To illustrate, I want a sales report (totals left off)
Womens Department
Shoes
Pumps
Sandals
Swimwear
Accessories
Bags
Jewelry
Men's Department
Shirts
Pants
In the example, Shoes and Accessories are just the agsum() of Pumps and Sandals, and Bags and Jewelry respectively, and the subcategories of Pumps, Sandals, Bags and Jewelry contain the agsum() individual transactions in the detailband (invisible). Howev
er, the categories Swimwear, Shirts and Pants don’t have subcategories, so the report leaves an annoying blank line between them and their next categories. I tried making the blank lines disappear with suppressIfBlank on the subcategories, but they staye
d.
Maybe someone out there has a different approach?
| |
| Gabriel 2006-03-12, 7:23 am |
| Sorry, posted this in the wrong newsgroup. I copied it into the reports newsgroup.
Gabriel Wrote:
> How does one make decent subcategories on reports when some categories don't have subcategories?
>
> To illustrate, I want a sales report (totals left off)
>
> Womens Department
> Shoes
> Pumps
> Sandals
> Swimwear
>
> Accessories
> Bags
> Jewelry
>
> Men's Department
> Shirts
>
> Pants
>
> In the example, Shoes and Accessories are just the agsum() of Pumps and Sandals, and Bags and Jewelry respectively, and the subcategories of Pumps, Sandals, Bags and Jewelry contain the agsum() individual transactions in the detailband (invisible). How
ever, the categories Swimwear, Shirts and Pants don’t have subcategories, so the report leaves an annoying blank line between them and their next categories. I tried making the blank lines disappear with suppressIfBlank on the subcategories, but they sta
yed.
>
> Maybe someone out there has a different approach?
>
|
|
|
|
|