I figured it out! The Company name had a comma in it like "My Company*,*Inc."
I added zzz Company and noticed that the new zzz company worked fine but the problem child which used to be the last group in the list still had the problem. I removed the "!" which didn't do it and then I removed the "," which then showed the records under the grouping. Bug identified... Jason On Mon, Apr 30, 2012 at 12:17 PM, LJ LongWing <[email protected]> wrote: > ** > > Sorry I can’t help further….please let us know if you come up with a > solution.**** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Jason Miller > *Sent:* Monday, April 30, 2012 12:37 PM > > *To:* [email protected] > *Subject:* Re: Issue with Grouping on a Table field**** > > ** ** > > ** I am grouping by Company (aka Grouping 1,2,3,4). It has data because I > see the Company name in that last grouping, just not the records for that > Company under the grouping. If I turn off the grouping the missing records > are shown.**** > > ** ** > > The last thing I can think of is the Company column on the table > fields doesn't have same permission as the other columns. The typical user > doesn't see the Company column (they know their company). I may try and > match the column permissions and see if that takes care of it. That or > Phil and Lenny are SOL for that last company :) (I have had only one cup > of coffee so I reject Monday and stay on Friday until the second cup)**** > > ** ** > > Worst case I add Company zzzzz and we'll ignore it or just turn off the > grouping altogether.**** > > ** ** > > [image: Inline image 2]**** > > ** ** > > On Mon, Apr 30, 2012 at 10:09 AM, LJ LongWing <[email protected]> > wrote:**** > > ** **** > > What grouping are you using?...is it possible that the value you are > grouping on is null in that record?**** > > **** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Jason Miller > *Sent:* Monday, April 30, 2012 10:37 AM > *To:* [email protected] > *Subject:* Re: Issue with Grouping on a Table field**** > > **** > > ** **** > > Yes, if I disable the grouping the records show. Thanks for the > suggestion though :)**** > > **** > > Jason**** > > On Mon, Apr 30, 2012 at 9:16 AM, LJ LongWing <[email protected]> > wrote:**** > > ** **** > > Jason,**** > > With the little testing I have done with table grouping, I have found that > it displays all of the groups, regardless of if there is data in the > grouping….have you verified that there is actually data in group 4?**** > > **** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Jason Miller > *Sent:* Friday, April 27, 2012 3:25 PM**** > > > *To:* [email protected] > *Subject:* Issue with Grouping on a Table field**** > > **** > > ** Hello everybody,**** > > **** > > Has anybody seen this issue where the last record in a Table field does > not show when the Table is set to Group on a field?**** > > **** > > In the screen print below you can see there are 4 groupings. The first > three grouping show the lines/records in that group. The last grouping > (#4) does not show the record in that group.**** > > **** > > Any ideas?**** > > **** > > ARS 7.6.04 SP2 on Window with MS SQL**** > > **** > > *Error! Filename not specified.***** > > **** > > Thanks,**** > > Jason**** > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_**** > > **** > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_**** > > ** ** > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
