Re: [sqr-users] on-break statement in select does not printfirstlineof a data field

["Joe" <jej1216@hotmail.com>]

Richard,

(from the select for Covered Employees)
let $Eligibility_Effdt = &HB.COVERAGE_BEGIN_DT

(from the select for Covered Dependents)
let $Eligibility_Effdt = &HBD.COVERAGE_BEGIN_DT

(from the print procedure)
let $DDelimiter = ''
do Format-Datetime ($Eligibility_Effdt, 
$Eligibility_Effdt_MDY,{DEFMDY},'','')

It is only on the Covered Employees where some have blank for 
$Eligibility_Effdt_MDY.

TIA,

jej1216

----- Original Message -----
From: "Knapp, Richard" <KnappR@umsystem.edu>
To: "This list is for discussion about the SQR database reportinglanguage 
fromHyperion Solutions." <sqr-users@sqrug.org>
Sent: Friday, November 09, 2007 11:28 AM
Subject: RE: [sqr-users] on-break statement in select does not print 
firstlineof a data field


You don't show where $Eligibility_Effdt_MDY gets its values.   That's
where I'd look first.

Richard Knapp
EAS - Data Warehouse Group
University of Missouri
615 Locust Street  #200
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Joe
Sent: Friday, November 09, 2007 11:43 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: [sqr-users] on-break statement in select does not print first
lineof a data field

I have a select statement that goes as follows:

begin-SELECT
E.NATIONAL_ID               () on-break print = never
                                                level = 1
                                                before = SSN-Change-Bef
E.NAME
J.EMPLID
J.EMPL_RCD
E.SEX
E.HIRE_DT
E.BIRTHDATE
E.ADDRESS1
E.ADDRESS2
E.CITY
E.STATE
E.POSTAL
HB.EFFDT
HB.BENEFIT_PLAN
HB.COVRG_CD
HB.COVERAGE_BEGIN_DT
HB.COVERAGE_END_DT
........ etc .........

The Procedure SSN-Change-Bef simply flips a flag so $SSN_Change = 'Y'

In the procedure that prints the lis report, there is the logic:
   if $SSN_Change = 'Y'
      let $SSN_Change = 'N'
      print &E.NATIONAL_ID           (+2, {Col1} )  edit xxx-xx-xxxx
      print &J.EMPLID                (  , {Col2} )
   else
      print ' '                      (+1,  )
   end-if

   print $Report_Name             (  , {Col3} )
   print &HB.BENEFIT_PLAN         (  , {Col4} )
   print $Coverage                (  , {Col5} )
   print $Eligibility_Effdt_MDY   (  , {Col6} )
   print $Start_Action_Dt_MDY     (  , {Col7} )
   print $Termination_Dt_MDY      (  , {Col8} )
   print $Dependent_Benef         (  , {Col9} )
   print $RelationShip            (  , {Col10})

The purpose of the above printing logic is so the report prints the
Employee on the first line, then each dependent on the following lines,
then skips a line before the next Employee.

In addition to the lis report, the SQR creates a flat file.

Here is my issue:

The $Eligibility_Effdt_MDY is inconsistently skipped on the lis report,
but it is there on the flat file.  All of the other data is printed
correctly.
In my output, the first three Employees and family are printed
correctly, on the fourth the $Eligibility_Effdt_MDY is blank on the lis
(but there on the data file), on the fifth Employee, it is blank but the
Dependent lines have it (again, it is there for all the Employee's lines
on the data file).

What is causing this inconsistent blank data for $Eligibility_Effdt_MDY?

TIA,

jej1216





_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users 


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users