print layout design
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.
total cost price:Rs104
total cost price:Rs105
i want to have final report as:
total cost price:Rs209.
in 2005 .B version
so please help me out....
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.