How 2 avoid sub-reports?

  • Thread starter Thread starter Faraz A. Qureshi
  • Start date Start date
F

Faraz A. Qureshi

I have a query always calculating the totals of five different products and
the result being:

Product A Total Amount (or 0 in case of null)
Product B Total Amount (or 0 in case of null)
Product C Total Amount (or 0 in case of null)
Product D Total Amount (or 0 in case of null)
Product E Total Amount (or 0 in case of null)

Now I want to make/design a report based upon such a query, however, I want
each of the entry, i.e. the sum of the products be placed manually at
different locations of the page instead of being presented in a tabular form.

In other words, instead of treating these to be treated as TWO fields i.e.
Product & Amount, I want them to be treated as five fields of SumProductA,
SumProductB, SumProductC, SumProductD and SumProductE.

Please HELP!
 
Faraz A. Qureshi said:
I have a query always calculating the totals of five different products and
the result being:

Product A Total Amount (or 0 in case of null)
Product B Total Amount (or 0 in case of null)
Product C Total Amount (or 0 in case of null)
Product D Total Amount (or 0 in case of null)
Product E Total Amount (or 0 in case of null)

Now I want to make/design a report based upon such a query, however, I
want
each of the entry, i.e. the sum of the products be placed manually at
different locations of the page instead of being presented in a tabular
form.

In other words, instead of treating these to be treated as TWO fields i.e.
Product & Amount, I want them to be treated as five fields of SumProductA,
SumProductB, SumProductC, SumProductD and SumProductE.

Please HELP!
Click to expand...
 
Back
Top