Multiple query

[tanvirtonu]

I need to show my report the following way-

 

Item____________Amount

Wood____________500

Oil_____________400

Coal____________300

 

Total___________1200

 

Now how should I set the total portion of this report.

Should I use sub report or is there any other way?

Can I use multiple query in a single report? if so how?

[svenn]

1. Set up a variable for the total

 

2. Set the calculation type to sum

 

3. Set the reset type to Report

 

4. Put you amount field in the variable expression

[mhbashar1]

svenn wrote:

1. Set up a variable for the total 2. Set the calculation type to sum 3. Set the reset type to Report 4. Put you amount field in the variable expression

 

Brother I think the most important part to say that the

Total amount field has to be in the summary field.