Grouping Bug?
Hi
I have a flat table of information that I am supplying via a JIT. I'm
creating a report that groups the data based on a string field (Category)
and summing a double filed (Time). Unfortunately the text on the last
category group item is not displayed (some of the time).
eg: with data (sorted by category)...
Category Time
One 1.5
One 3.0
Three 1.5
Two 2.0
grouping by category, placing a DBText - "Category" and a DBCalc -
"Sum(Hours)" in the Group Footer[1]: Category section I get...
One 4.5
Three 1.5
2.0
where the text Two is missing.
If I do not group it all category labels show their correct data. Do you
have any ideas what I should look for?
I am using report builder version 10.07.
Regards,
I have a flat table of information that I am supplying via a JIT. I'm
creating a report that groups the data based on a string field (Category)
and summing a double filed (Time). Unfortunately the text on the last
category group item is not displayed (some of the time).
eg: with data (sorted by category)...
Category Time
One 1.5
One 3.0
Three 1.5
Two 2.0
grouping by category, placing a DBText - "Category" and a DBCalc -
"Sum(Hours)" in the Group Footer[1]: Category section I get...
One 4.5
Three 1.5
2.0
where the text Two is missing.
If I do not group it all category labels show their correct data. Do you
have any ideas what I should look for?
I am using report builder version 10.07.
Regards,
This discussion has been closed.
Comments
issue to support@digital-metaphors.com
Ed Dressel
Team DM
For others reading this thread, an example project was submitted to
support@digital-metaphors.com. The issue was improper implementation of
JITPipeline event-handler. Proper implementation is covered in the
Developers Guide tutorials and examples installed to
RBulder\Demos\Reports\Demo.dpr.
Basics of JITPipeline impelementation:
1. Use the DataPipeline Field editor to define the JITPipeline Fields
2. Set JITPipeline.RecordCount (either via the object inspector or via code
at runtime).
3. Implement the JITPipeline.OnGetFieldValue event. Use the
JITPipeline.RecordIndex to index into your data structure and the aFieldName
parameter to return the appropriate value.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com