Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Grouping Bug?

edited March 2008 in General
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,

Comments

  • edited March 2008
    the quickest way to resolve this would be to send a demo reproducing the
    issue to support@digital-metaphors.com

    Ed Dressel
    Team DM

  • edited March 2008

    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
This discussion has been closed.