Class Wise Sum in Report (Crosstab Query) (1 Viewer)

[Akhlaq.bkr]

Hi Dear Sir,

I have create a report from a crosstab query that works perfect now I want to sum of these fields (class wise) in text box using formula. Kindly help me in this regard. Thanks

Note: Details are on attachment.

 

[MajP]

Since crosstab query transposes the data, I would think you go back to the original source. And either show that as another subreport.
Do an aggregate query on the original data and group by class. That should give you a table like

5th 4700
6th 14400
...
11th

If you wanted you could do a xtab on that and get

5th 6th
4700 14400

 

[arnelgp]

you can also use DSum() function in your report:

say for "Total of class 5th:"
add an Unbound textbox (to the right of "Total of class 5th") (name it txt5thTotal)
on its ControlSource property:

=DSum("theFieldToSum", "yourTableName", "Active_Class = '5th'")

 

[Akhlaq.bkr]

you can also use DSum() function in your report:

say for "Total of class 5th:"
add an Unbound textbox (to the right of "Total of class 5th") (name it txt5thTotal)
on its ControlSource property:

=DSum("theFieldToSum", "yourTableName", "Active_Class = '5th'")

Thanks for answer but problem not solved yet. Kindly tell me any other way.

 

[Akhlaq.bkr]

you can also use DSum() function in your report:

say for "Total of class 5th:"
add an Unbound textbox (to the right of "Total of class 5th") (name it txt5thTotal)
on its ControlSource property:

=DSum("theFieldToSum", "yourTableName", "Active_Class = '5th'")

Thank you I will try this method.

 

[Akhlaq.bkr]

Since crosstab query transposes the data, I would think you go back to the original source. And either show that as another subreport.
Do an aggregate query on the original data and group by class. That should give you a table like

5th 4700
6th 14400
...
11th

If you wanted you could do a xtab on that and get

5th 6th
4700 14400

Thank you I will try this method.