SecondLevel Traverse(To make the field visible at first Level)

-

Ø     Local Rowset &RS2,&RS3;
Ø   &RS2 = GetLevel0()(1).GetRowset(Scroll.JOB);
Ø   For &I = 1 To &RS2.ActiveRowCount
Ø   &RS3 = &RS2.GetRow(&I).GetRowset(Scroll.JOB_JR);
Ø   For &J = 1 To &RS3.ActiveRowCount                  &RS3.GetRow(&J).GetRecord(Record.HR_LBL_WRK).GetField(Field.DETYA_LBL_AUS).Visible = True;
Ø        End-For;
Ø     End-For;


Comments

Post a Comment

Popular posts from this blog

BI Publisher: If Condition with sub-string in rtf template

-
 <?xdofx:if substr(ACAD_PLAN,1,1) = 'C'  then 'Los Angeles City College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'H'  then 'Los Angeles Harbor College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'M'  then 'Los Angeles Mission College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'P'  then 'Pierce College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'S'  then 'Los Angeles Southwest College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'V'  then 'Los Angeles Valley College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'W'  then 'West Los Angeles College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'T'  then 'LA Trade-Technical Colleg' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'E'  then 'East Los Angeles College' end if?>;
Read more