How can I show %qty in Various bands

venu4sunkris@yahoo.com

I am building a report which has to display qty and % of qty
data fields in master data, Group footer etc. bands.

Let us assume, qty of prod1 = 21 and total qty of all products = 108.
In the master data band,
Product Name Qty %Qty
prod1 21 21 *100/108( = 19.44)
Prod2 5 5 * 100/108( = 4.63)
In group footer
26 26 * 100/108( = 24.07)

Comments

  • edited 12:13PM
    Make your report two-pass. On the first pass, accumulate total products value and use in on the second pass.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.