I have a report with two columns as specified below:
Type | Count
A | 20
A | 30
A | 10
B | 5
B | 7
C | 10
C | 15
Total A : 60
Total B : 12
Total C : 25
The detail block will be varying and can have multiple types and the report header should be varying accordingly. As per the requirement there is a main query which is retrieving the data for the detail block. But when i use group expert , it is displaying the group header after each group, but i want those types and the sum of the count in the report footer. Can you please kindly let me know if there is any solution without calling the same query once again to retrieve the count. The query retrieves a huge data and the business is not allowing to call the query twice in the report.
I created a cross tab report with Type and count.
i updated the first column Display String as "Type " + CurrentFieldValue. some of the description in the CurrentFieldValue is coming more than width of the row and it is not getting displayed. And the option that allows a field to grow is disabled which is not allowing a field to grow dynamically.
For Example:
If one of the type is ‘Dcnt’
The report should like
Total A : 60
Total B : 12
Total C : 25
Total Dcnt : 12
and not like as below:
Total A: 60
Total B: 12
Total C: 25
Total Dcnt : 12
When i am trying to display the field Total Dcnt, It is getting truncating and i could not able to display “:” also in a same position for all the records, i.e, the colon should be the last which should be aligned for all the records according to greatest length of the row. In this example Total Dcnt is the maximum length, so the colon should be aligned according to its length.
Can you please kindly let me know how to fix this issue.
(BOB member since 2009-07-30)