3 Answers, 1 is accepted
0
Hello Joseph,
The Count aggregate function counts all non-values for a given expression/field.
We are not aware of any problems with it I and therefore I would like to ask you to elaborate a little bit on the issue you are faced with.
Since the aggregate functions work over a set of data we will need to inspect the data you are displaying and the report definition in order to confirm that there is a problem.
I am looking forward to hearing from you. Thank you in advnace.
Greetings,
Svetoslav
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
The Count aggregate function counts all non-values for a given expression/field.
We are not aware of any problems with it I and therefore I would like to ask you to elaborate a little bit on the issue you are faced with.
Since the aggregate functions work over a set of data we will need to inspect the data you are displaying and the report definition in order to confirm that there is a problem.
I am looking forward to hearing from you. Thank you in advnace.
Greetings,
Svetoslav
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
0
Joseph
Top achievements
Rank 1
Rank 1
answered on 20 Nov 2007, 05:27 PM
Sorry to take so long to respond back. I wanted to make sure I could describe the issue correctly.
I am attempting to do a count and sum on a Amount field in a GroupHeader who's Group is an ITEMID. This field only displays once per ITEMID (as desired) in the Group Header. We cannot put this field in the detail, because we need only a description field to appear there (There can be multiple descriptions or the description could be blank for each ITEMID). Effectively we are suppressing duplicate amounts from appearing on the report because the amount field is in the ITEMID group rather than in details.
When I put the totals fields in the ITEMID of the GroupFooter, it appears to provide a sum and count of the Amount field in as if it appears in the details section (the reoccurring Amounts) rather than just the unique Amount values that appear in the ITEMID Group header. This causes our sum and count to be multiplied by the number of description lines, which is an incorrect value.
I am attempting to do a count and sum on a Amount field in a GroupHeader who's Group is an ITEMID. This field only displays once per ITEMID (as desired) in the Group Header. We cannot put this field in the detail, because we need only a description field to appear there (There can be multiple descriptions or the description could be blank for each ITEMID). Effectively we are suppressing duplicate amounts from appearing on the report because the amount field is in the ITEMID group rather than in details.
When I put the totals fields in the ITEMID of the GroupFooter, it appears to provide a sum and count of the Amount field in as if it appears in the details section (the reoccurring Amounts) rather than just the unique Amount values that appear in the ITEMID Group header. This causes our sum and count to be multiplied by the number of description lines, which is an incorrect value.
0
Hello Joseph,
In order to help you in the best possible way I will need some more information regarding your report layout and data. It will be of a great help if you can prepare a simple project with the report you are talking in your post; create a simple object that has only the ITEMID and Amount (since you have trouble with these fields) and bind the report to a list filled with several such objects with the proper data (to be able to group and sum the objects as per your needs).
I am looking forward to hearing from you.
Regards,
Svetoslav
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
In order to help you in the best possible way I will need some more information regarding your report layout and data. It will be of a great help if you can prepare a simple project with the report you are talking in your post; create a simple object that has only the ITEMID and Amount (since you have trouble with these fields) and bind the report to a list filled with several such objects with the proper data (to be able to group and sum the objects as per your needs).
I am looking forward to hearing from you.
Regards,
Svetoslav
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center