Page 1 of 1
first group name not included
Posted: Thu Oct 02, 2003 11:24 am
by CPL2624
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__
=> RE: first group name not included
Posted: Thu Oct 02, 2003 2:00 pm
by kfleming
What happens if you put the group field on a record band.__Does it then show up?__Kathleen__R&R Support
==> RE: first group name not included
Posted: Fri Oct 03, 2003 7:37 am
by CPL2624
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?
===> RE: first group name not included
Posted: Fri Oct 03, 2003 11:57 am
by kfleming
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
====> RE: first group name not included
Posted: Fri Oct 03, 2003 12:28 pm
by CPL2624
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__
=====> RE: first group name not included
Posted: Fri Oct 03, 2003 2:12 pm
by kfleming
What happens if you take away the logical line condition?____Kathleen__R&R Support
======> RE: first group name not included
Posted: Mon Oct 06, 2003 6:15 am
by CPL2624
[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
=======> RE: first group name not included
Posted: Mon Oct 06, 2003 11:59 am
by kfleming
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