AR2 Grouping Issue

Posted by: ewalker-dd on 4 August 2017, 3:21 pm EST

  • Posted 4 August 2017, 3:21 pm EST

    I recently had a user report to me that an old report had begun to exhibit strange grouping behavior when only one group was selected to report on.

    It turns out that it's only one group in particular that does this, as other groups, reported alongside the problem group or alone, don't do this.

    In the past it would work like so:

    GroupName:
    detail
    ...
    detail
    GroupFooter and Totals

    Now it does this:

    GroupName:
    detail
    GroupFooter and Totals
    GroupName:
    detail
    ...
    detail
    GroupFooter and Totals
    GroupName:
    detail
    GroupFooter and Totals

    I've reviewed the code to make sure nothing changed as well as verifying the properties of the groupheader:
    DataField: Building
    GrpKeepTogether: ddGrpNone
    KeepTogether: True
    NewColumn: ddNPNone
    NewPage: ddNPNone
    Repeat: ddRepeatNone

    I've verified the DataField has only one value in all the records returned by the source query for the offending group.

    I've even recreated the report from scratch as the original was an upgraded AR1 report.

    It seems no matter what I do, when Building has a value of 15, the grouping breaks completely.  Any assistance would be greatly appreciated.

    Thanks in advance,
    Eric

  • Replied 4 August 2017, 3:21 pm EST

    Eric,

    Could you please post a reproducible sample here? You could use a simple recordset with some test data that would demonstrate the issue.

    Regards,
    Prantik
  • Replied 4 August 2017, 3:21 pm EST

    Prantik:  Here's a small sample of the data

    S00000235200    2011-12-22 00:00:00.000    2011-12-15 13:31:31.000    7338    306    70    15    1/2 POP 1C&BTR RGH         14'    Kiln Dried Sticks
    S00000235201    2011-12-22 00:00:00.000    2011-12-15 13:34:55.000    7340    280    56    15    1/2 POP 1C&BTR RGH         16'    Kiln Dried Sticks
    S00000233212    2011-12-14 00:00:00.000    2011-11-01 11:11:34.000    7282    656    210    15    1/2 RO 1C&BTR RGH          10'    Kiln Dried Sticks
    S00000233213    2011-12-14 00:00:00.000    2011-11-01 11:14:30.000    7282    131    42    15    1/2 RO 1C&BTR RGH          10'    Kiln Dried Sticks
    S00000233851    NULL    2011-11-11 13:12:36.000    7282    131    42    15    1/2 RO 1C&BTR RGH          10'    Kiln Dried Sticks
    S00000234225    NULL    2011-11-21 07:47:13.000    7282    350    112    15    1/2 RO 1C&BTR RGH          10'    Kiln Dried Sticks
    S00000234303    2012-01-19 00:00:00.000    2011-11-21 14:26:45.000    7282    175    56    15    1/2 RO 1C&BTR RGH          10'    Kiln Dried Sticks
    S00000234662    2012-01-19 00:00:00.000    2011-12-07 06:33:55.000    7282    919    294    15    1/2 RO 1C&BTR RGH          10'    Kiln Dried Sticks
    S00000234982    2012-01-19 00:00:00.000    2011-12-13 11:16:57.000    7282    612    196    15    1/2 RO 1C&BTR RGH          10'    Kiln Dried Sticks
    S00000234302    2012-01-19 00:00:00.000    2011-11-21 14:24:37.000    7284    158    42    15    1/2 RO 1C&BTR RGH          12'    Kiln Dried Sticks
    S00000233215    2011-12-14 00:00:00.000    2011-11-01 11:19:19.000    7286    796    182    15    1/2 RO 1C&BTR RGH          14'    Kiln Dried Sticks
    S00000232773    2011-12-14 00:00:00.000    2011-10-20 13:00:41.000    7288    630    126    15    1/2 RO 1C&BTR RGH          16'    Kiln Dried Sticks
    S00000234301    2012-01-19 00:00:00.000    2011-11-21 14:22:20.000    7288    210    42    15    1/2 RO 1C&BTR RGH          16'    Kiln Dried Sticks
    S00000234663    2012-01-19 00:00:00.000    2011-12-07 06:49:46.000    7288    1050    210    15    1/2 RO 1C&BTR RGH          16'    Kiln Dried Sticks
    S00000233211    2011-12-14 00:00:00.000    2011-11-01 11:10:28.000    7308    481    154    15    1/2 WO 1C&BTR RGH          10'    Kiln Dried Sticks
    S00000233853    NULL    2011-11-11 13:14:17.000    7308    262    84    15    1/2 WO 1C&BTR RGH          10'    Kiln Dried Sticks
    S00000234304    2012-01-19 00:00:00.000    2011-11-21 14:29:48.000    7308    438    140    15    1/2 WO 1C&BTR RGH          10'    Kiln Dried Sticks
    S00000234956    NULL    2011-12-09 09:14:29.000    7308    306    98    15      1/2 WO 1C&BTR RGH          10'    Kiln Dried Sticks
    S00000234983    2012-01-19 00:00:00.000    2011-12-13 11:20:04.000    7308    262    84    15    1/2 WO 1C&BTR RGH          10'    Kiln Dried Sticks
    S00000232774    2011-12-14 00:00:00.000    2011-10-20 13:03:32.000    7310    158    42    15    1/2 WO 1C&BTR RGH          12'    Kiln Dried Sticks

    As you can see the 7th column for each of these records shows 15 (which is the Building code for Kiln Dried Sticks).  I've verified there's no difference in the value coming from the db and this is the .DataField for GroupHeader1 on this report.

    I'm also attaching a .pdf copy of the output of this report.

    Thanks for your assistance and please let me know if you need anything else,
    Eric
  • Replied 4 August 2017, 3:21 pm EST

    Eric,

    Please attach the RPX or DSR,DSX of the report.Also, the PDF did not seem to get attached.

    Regards,
    Prantik
  • Replied 4 August 2017, 3:21 pm EST

    Here's another attempt at the .pdf, report .DSR to follow.
  • Replied 4 August 2017, 3:21 pm EST

    Prantik:  Not getting any errors, but still not seeing anything attached.

    Trying to attach DSR here.
  • Replied 4 August 2017, 3:21 pm EST

    PDF attempt from another browser.



    Prantik: Have tried attaching both the .pdf and .dsr file for the report to the several posts here and I'm neither getting any errors, nor seeing anything actually attached.



    Should I email these to you instead?
  • Replied 4 August 2017, 3:21 pm EST

    Prantik:  Any update on this?  I have your email address from previous correspondence and can email you the files you requested.  I've got to get this taken care of ASAP.

    Please let me know at your earliest convenience.
  • Replied 4 August 2017, 3:21 pm EST

    Hello,

    I have sent you an email from our support email address. Could you please take a look and reply back to it?

    Regards,
    Prantik
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels