first group name not included

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
CPL2624
Posts: 6
Joined: Tue Oct 10, 2017 12:44 pm

first group name not included

Post by CPL2624 » Thu Oct 02, 2003 11:24 am

Hi Guys ____I wonder if anyone has seen this issue? have have a simple report, it has one group header (customer account) the purpose of the report is to compaire the cost against the charge and only print if there is a >2% difference.____the report groups fine and prints the right records, however for some reason it will not print out the customer account number and name for the first group,it prints the subsequent ones ? ____Regards____Tim__

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: first group name not included

Post by kfleming » Thu Oct 02, 2003 2:00 pm

What happens if you put the group field on a record band.__Does it then show up?__Kathleen__R&R Support

CPL2624
Posts: 6
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: first group name not included

Post by CPL2624 » Fri Oct 03, 2003 7:37 am

Hi Kathleen____I copied the account no field and placed it on the record line, __the entry shows on the record line but not on the group line.____all other enteries show on the group line as previousley mentioned____Regards____Tim__P.S. did you get my email about Noel?

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: first group name not included

Post by kfleming » Fri Oct 03, 2003 11:57 am

Place a calculated field with expression RECNO() on both the record band and the group band. And make sure that the field that is missing is indeed the same on the group and record band. That way you can see what composite record is being evaluated when the group band prints and compare it to that same record on the records band.____Kathleen__R&R Support

CPL2624
Posts: 6
Joined: Tue Oct 10, 2017 12:44 pm

====> RE: first group name not included

Post by CPL2624 » Fri Oct 03, 2003 12:28 pm

OK did that, record one which is mostley blank in the DBF as it contains a memo of the parameters selected by the user, anyway that record prints twice and record 2 fials to print the report then goes straight on to record 3.____I checked the record no in the DBF and they are correct 1,2,3 etc____there is a logical field associated with the 3 lines in question and is set to print when .T. ____IIF(VAL(Same_del->Variance)>2.00,.T.,IIF(VAL(Same_del->Variance)<-2.00,.T.,IIF(Same_del->BAS_CHAR=0.00,.T.,IIF(Same_del->cost=0.00,.T.,.F.))))____any idea^s ?____regards____Tim__

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=====> RE: first group name not included

Post by kfleming » Fri Oct 03, 2003 2:12 pm

What happens if you take away the logical line condition?____Kathleen__R&R Support

CPL2624
Posts: 6
Joined: Tue Oct 10, 2017 12:44 pm

======> RE: first group name not included

Post by CPL2624 » Mon Oct 06, 2003 6:15 am

[updated:LAST EDITED ON Oct-06-03 AT 06:15 AM (EST)]I took the logical line off the group header but left it in place on the record line, the report prints the group header for the first record, but then prints group headers for accounts that have jobs to display. ____Regards____Tim

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=======> RE: first group name not included

Post by kfleming » Mon Oct 06, 2003 11:59 am

Sounds like you need to revise the logical for that line so that the first group header does not get excluded.____Kathleen__R&R Support

Post Reply