print layout design

[Former Member]

hi friends,

using print layout design i am getting reports for a purchased item with all types of taxes included.

i want to display the total cost of same purchased items but more than one and each purchased items having different taxes included with it.

Example:

product1:

cost price:Rs100

tax:4%

total cost price:Rs104

Product1:

cost price:Rs100

tax:5%

total cost price:Rs105

i want to have final report as:

product1

total cost price:Rs209.

in 2005 .B version

so please help me out....

regards,

varalakshmi.

[Former Member · Accepted solution]

Hi,

If you want to create a base on tax rate, you can, First, goto to Sort and from the Sort properties, set/sort the Product to by ascending the do not check the summarize, then choose the Field where the tax is then check the Summarize then ok.

In you report proper, make a formula for the rate with Content : Concat(Field_rate) then put from the Group values as '1' then uncheck visible, then create a your report since the rate is not visible it will group according to rate and sort according to product.

regards,

Clint