When I burst a report, the styling alternates between every report. Is this a setting? How do I make all reports have the same formatting? For example: with a burst value of 1, 3 and 5 the results on those individual reports reflect my desired styles I created in the report. For burst values of 2, 4 and 6 however, the style is something else that does not reflect the report I created. Any help on this is greatly appreciated!

This message has been edited. Last edited by: Kerry,

Please post your code.

-* Created by Power Painter
-* Default Mode: ResourceLayout
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$CjxSb290IHZlcnNpb249IjEuMCIgPgogICA8T2JqZWN0IG9iamVjdElkPSJUYWJsZV8xIiA+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJMaW5rZWRTb3J0cyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgIDwvT2JqZWN0PgogICA8T2JqZWN0IG9iamVjdElkPSJUYWJsZV8zIiA+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJMaW5rZWRTb3J0cyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgIDwvT2JqZWN0PgogICA8T2JqZWN0IG9iamVjdElkPSJUYWJsZV8yIiA+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJMaW5rZWRTb3J0cyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgIDwvT2JqZWN0PgogICA8T2JqZWN0IG9iamVjdElkPSJUYWJsZV80IiA+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJMaW5rZWRTb3J0cyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgIDwvT2JqZWN0PgogICA8T2JqZWN0IG9iamVjdElkPSJUYWJsZV81IiA+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJMaW5rZWRTb3J0cyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgIDwvT2JqZWN0PgogICA8T2JqZWN0IG9iamVjdElkPSJUYWJsZV82IiA+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJMaW5rZWRTb3J0cyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgIDwvT2JqZWN0PgogICA8T2JqZWN0IG9iamVjdElkPSJUYWJsZV85IiA+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJMaW5rZWRTb3J0cyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgIDwvT2JqZWN0PgogICA8T2JqZWN0IG9iamVjdElkPSJHTE9CQUwiID4KICAgICAgPFByb3BlcnR5IG5hbWU9IlNhbXBsZURhdGEiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIiA+dHJ1ZTwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJHbG9iYWxSZWNvcmRMaW1pdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjEwPC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbFJ1blJlY29yZExpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+MDwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJmaWVsZERpc3BsYXlNb2RlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+bGFiZWw8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0icHJlZml4RGlzcGxheU1vZGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID48L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iZW5hYmxlUHJldmlldyIgdHlwZT0iamF2YS5sYW5nLkJvb2xlYW4iID50cnVlPC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9IkxpbmtlZFNvcnRzIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+bm90IGluaXRpYWxpemVkPC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9IkZvY2V4ZWNQcmVmZXJlbmNlcyIgdHlwZT0iTWFwIiA+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfdGFibGVfZm9ybWF0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+SFRNTDwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlFZGl0TW9kZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUZvcm1hdFRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SG9tZVRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVF1aWNrQWNjZXNzVG9vbGJhclNhdmVJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID50cnVlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVJlc291cmNlc0ZpZWxkVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X2NoYXJ0X2Zvcm1hdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPkhUTUw8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SW5zZXJ0VGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkVkaXRJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlTZXJpZXNUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImluZm9Bc3Npc3RNb2RlQWxsb3dlZEluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF9wcmV2aWV3X3BhZ2VsaW1pdF9sYXlvdXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID4xPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZXhjZWxfZm9ybWF0X3Zpc2libGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID50cnVlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF9wcmV2aWV3X3BhZ2VsaW1pdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X2NvbXBvc2VfZm9ybWF0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+UERGPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUludGVyYWN0aXZlTW9kZUlu
*-INTERNAL_COMMENT LINE#1$Zm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5RGF0YVRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZWRpdG9yVHlwZV92aXNpYmxlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9InRoZW1lc19jb250cm9sX3Zpc2libGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID50cnVlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNsaWNlcnNUYWJJbnRlcmFjdGl2ZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5TGF5b3V0VGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICA8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iY2FzY2FkZU5hbWVzIiB0eXBlPSJNYXAiID48L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iTWFzdGVyX0ZpbGVzIiB0eXBlPSJTZXQiID4KICAgICAgICAgPEVudHJ5IHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5QSU1TUE9MSUNZPC9FbnRyeT4KICAgICAgPC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9Ik91dHB1dEZvcm1hdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPlBERjwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJTbGljZXJHdWlJc2xhbmQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID57JnF1b3Q7YkF1dG9QcmV2aWV3JnF1b3Q7OmZhbHNlLCZxdW90O2JPcHRpb25zR3JvdXBWaXNpYmxlJnF1b3Q7OnRydWUsJnF1b3Q7YlJlY0xpbWl0R3JvdXBWaXNpYmxlJnF1b3Q7OnRydWUsJnF1b3Q7YlByZXZpZXdDb250cm9sVmlzaWJsZSZxdW90Ozp0cnVlLCZxdW90O2JSdW50aW1lQ29udHJvbFZpc2libGUmcXVvdDs6dHJ1ZX08L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iU0xJQ0VSX0lORk9STUFUSU9OIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+Jmx0O1NMSUNFUl9HUk9VUCZndDsKICAgJmx0O0dST1VQIGdyb3VwTnVtYmVyPSZxdW90OzAmcXVvdDsgc2xpY2VyR3JvdXBMYWJlbD0mcXVvdDtHcm91cCAxJnF1b3Q7IHNsaWNlckdyb3VwT3JkZXI9JnF1b3Q7MCZxdW90OyBzbGljZXJHcm91cFNpemU9JnF1b3Q7MCZxdW90OyBzbGljZXJHcm91cGhpZGU9JnF1b3Q7ZmFsc2UmcXVvdDsgJmd0OyZsdDsvR1JPVVAmZ3Q7CiZsdDsvU0xJQ0VSX0dST1VQJmd0OzwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJGZXhTdGF0ZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnsmcXVvdDtfYXJDb21wb25lbnRzJnF1b3Q7OltdfTwvUHJvcGVydHk+CiAgIDwvT2JqZWN0Pgo8L1Jvb3Q+
-*Do not delete or modify the comments above


COMPOUND LAYOUT PCHOLD FORMAT PDF
SECTION=Section_1, LAYOUT=ON, PAGESIZE=LETTER, ORIENTATION=PORTRAIT, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.25, BOTTOMMARGIN=0.25, $
COMPONENT=Table_1, COMPONENT-TYPE=REPORT, POSITION=(0.052083 1.5), DIMENSION=(* *), METADATA='VERSION:1.0;WIDTH:3.28125;HEIGHT:6.385416;LEFT:0.052083;TOP:1.5;COMPONENTS_INCLUDED:AWAITING,COMPLETE,TOTALI,PENDING,INPROGRESS,FINALIZED,ALLUW,UWCAND,TotalCancellations,TotalOtherChanges', $
COMPONENT=Table_3, COMPONENT-TYPE=REPORT, POSITION=(0.0625 2.885416), DIMENSION=(3.239583 10.28125), METADATA='VERSION:1.0;COMPONENTS_INCLUDED:AWAITING,COMPLETE,TOTALI,PENDING,INPROGRESS,FINALIZED,ALLUW,UWCAND,TotalCancellations,TotalOtherChanges', $
COMPONENT=Table_2, COMPONENT-TYPE=REPORT, POSITION=(3.59375 1.53125), DIMENSION=(2.958333 6.385416), METADATA='VERSION:1.0;COMPONENTS_INCLUDED:AWAITING,COMPLETE,TOTALI,PENDING,INPROGRESS,FINALIZED,ALLUW,UWCAND,TotalCancellations,TotalOtherChanges', $
COMPONENT=Table_4, COMPONENT-TYPE=REPORT, POSITION=(3.614583 2.864583), DIMENSION=(2.916666 8.333333), METADATA='VERSION:1.0;COMPONENTS_INCLUDED:AWAITING,COMPLETE,TOTALI,PENDING,INPROGRESS,FINALIZED,ALLUW,UWCAND,TotalCancellations,TotalOtherChanges', $
COMPONENT=Table_5, COMPONENT-TYPE=REPORT, POSITION=(1.572916 4.78125), DIMENSION=(2.989583 6.385416), METADATA='VERSION:1.0;COMPONENTS_INCLUDED:AWAITING,COMPLETE,TOTALI,PENDING,INPROGRESS,FINALIZED,ALLUW,UWCAND,TotalCancellations,TotalOtherChanges', $
COMPONENT=Table_6, COMPONENT-TYPE=REPORT, POSITION=(0.40625 5.96875), DIMENSION=(45.34375 26.94791), METADATA='VERSION:1.0;COMPONENTS_INCLUDED:AWAITING,COMPLETE,TOTALI,PENDING,INPROGRESS,FINALIZED,ALLUW,UWCAND,TotalCancellations,TotalOtherChanges', $
COMPONENT=Table_7, COMPONENT-TYPE=REPORT, POSITION=(6.625 1.90625), DIMENSION=(0.864583 0.583333), METADATA='VERSION:1.0;COMPONENTS_INCLUDED:AWAITING,COMPLETE,TOTALI,PENDING,INPROGRESS,FINALIZED,ALLUW,UWCAND,TotalCancellations,TotalOtherChanges', $
COMPONENT=Table_8, COMPONENT-TYPE=REPORT, POSITION=(6.614583 3.270833), DIMENSION=(0.864583 0.78125), METADATA='VERSION:1.0;COMPONENTS_INCLUDED:AWAITING,COMPLETE,TOTALI,PENDING,INPROGRESS,FINALIZED,ALLUW,UWCAND,TotalCancellations,TotalOtherChanges', $
COMPONENT=Table_9, COMPONENT-TYPE=REPORT, POSITION=(4.583333 4.791666), DIMENSION=(1.375 6.385416), METADATA='VERSION:1.0;COMPONENTS_INCLUDED:AWAITING,COMPLETE,TOTALI,PENDING,INPROGRESS,FINALIZED,ALLUW,UWCAND,TotalCancellations,TotalOtherChanges', $
COMPONENT=Table_10, COMPONENT-TYPE=REPORT, POSITION=(5.75 4.958333), DIMENSION=(0.864583 0.78125), METADATA='VERSION:1.0;COMPONENTS_INCLUDED:AWAITING,COMPLETE,TOTALI,PENDING,INPROGRESS,FINALIZED,ALLUW,UWCAND,TotalCancellations,TotalOtherChanges', $
OBJECT=STRING, NAME=Text_1, POSITION=(2.4375 1.5625), MARKUP=ON, TEXT='Counts', FONT=ARIAL, SIZE=12, COLOR=RGB(0 0 0), WRAP=ON, DIMENSION=(0.520833 0.21875), $
OBJECT=STRING, NAME=Text_2, POSITION=(1.989583 0.34375), MARKUP=ON, TEXT='Property Reunderwriting Program
Agency Level Progress for <&RenewalAgencyNbr>', FONT=ARIAL, SIZE=12, COLOR=RGB(0 0 0), WRAP=ON, DIMENSION=(4.802083 0.822916), $
OBJECT=STRING, NAME=Text_3, POSITION=(5.947916 1.604166), MARKUP=ON, TEXT='Agency % State % ', FONT=ARIAL, SIZE=12, COLOR=RGB(0 0 0), WRAP=ON, DIMENSION=(1.489583 0.25), $
OBJECT=STRING, NAME=Text_4, POSITION=(2.916666 1.239583), MARKUP=ON, TEXT='Inspection Progress', FONT=ARIAL, SIZE=12, COLOR=RGB(0 0 0), WRAP=ON, DIMENSION=(1.46875 0.28125), $
OBJECT=STRING, NAME=Text_5, POSITION=(2.854166 2.614583), MARKUP=ON, TEXT='Underwriting Progress', FONT=ARIAL, SIZE=12, COLOR=RGB(0 0 0), WRAP=ON, DIMENSION=(1.645833 0.270833), $
OBJECT=STRING, NAME=Text_6, POSITION=(2.697916 4.4375), MARKUP=ON, TEXT='Underwriting Action Results ', FONT=ARIAL, SIZE=12, COLOR=RGB(0 0 0), WRAP=ON, DIMENSION=(2.135416 0.270833), $
OBJECT=STRING, NAME=Text_7, POSITION=(5.979166 2.90625), MARKUP=ON, TEXT='Agency % State % ', FONT=ARIAL, SIZE=12, COLOR=RGB(0 0 0), WRAP=ON, DIMENSION=(1.510416 0.291666), $
OBJECT=STRING, NAME=Text_8, POSITION=(5.229166 4.864583), MARKUP=ON, TEXT=' Agency % State % ', FONT=ARIAL, SIZE=12, COLOR=RGB(0 0 0), WRAP=ON, DIMENSION=(1.572916 0.270833), $
OBJECT=STRING, NAME=Text_9, POSITION=(3.166666 5.979166), MARKUP=ON, TEXT='Crit 1', FONT=ARIAL, SIZE=12, COLOR=RGB(0 0 0), WRAP=ON, DIMENSION=(0.520833 0.25), $
OBJECT=STRING, NAME=Text_10, POSITION=(4.104166 5.979166), MARKUP=ON, TEXT='Crit 2', FONT=ARIAL, SIZE=12, COLOR=RGB(0 0 0), WRAP=ON, DIMENSION=(0.510416 0.270833), $
OBJECT=STRING, NAME=Text_11, POSITION=(4.927083 5.96875), MARKUP=ON, TEXT='High', FONT=ARIAL, SIZE=12, COLOR=RGB(0 0 0), WRAP=ON, DIMENSION=(0.46875 0.28125), $
OBJECT=STRING, NAME=Text_12, POSITION=(5.677083 5.947916), MARKUP=ON, TEXT='Medium', FONT=ARIAL, SIZE=12, COLOR=RGB(0 0 0), WRAP=ON, DIMENSION=(0.729166 0.322916), $
OBJECT=STRING, NAME=Text_13, POSITION=(6.697916 5.958333), MARKUP=ON, TEXT='Total', FONT=ARIAL, SIZE=12, COLOR=RGB(0 0 0), WRAP=ON, DIMENSION=(0.520833 0.260416), $
END

-*COMPONENT=Define_PIMSPOLICY
DEFINE FILE PIMSPOLICY
AWAITING/I11C=IF PIMSPOLICY.PIMSPOLICY.INSPECTIONPRIORITY NE 'GOOD' OR 'LOW' AND PIMSPOLICY.PIMSPOLICY.POLICYFORMID OMITS '4' OR '6' AND PIMSPOLICY.PIMSPOLICY.INSPECTIONSTATUSID EQ 1 THEN 1 ELSE 0 ;
COMPLETE/I11C=IF PIMSPOLICY.PIMSPOLICY.INSPECTIONPRIORITY NE 'GOOD' AND PIMSPOLICY.PIMSPOLICY.POLICYFORMID OMITS '4' OR '6' AND PIMSPOLICY.PIMSPOLICY.INSPECTIONSTATUSID EQ 2 THEN 1 ELSE 0 ;
TOTALI/I11C=IF PIMSPOLICY.PIMSPOLICY.INSPECTIONPRIORITY NE 'GOOD' AND PIMSPOLICY.PIMSPOLICY.POLICYFORMID OMITS '4' OR '6' AND PIMSPOLICY.PIMSPOLICY.INSPECTIONSTATUSID EQ 1 OR 2 THEN 1 ELSE 0 ;
PENDING/I11C=IF PIMSPOLICY.PIMSPOLICY.INSPECTIONPRIORITY NE 'GOOD' AND PIMSPOLICY.PIMSPOLICY.UNDERWRITINGSTATUSID EQ 9 OR 11 OR 12 OR 14 AND PIMSPOLICY.PIMSPOLICY.INSPECTIONSTATUSID EQ 2 OR 8 THEN 1 ELSE 0 ;
INPROGRESS/I11C=IF PIMSPOLICY.PIMSPOLICY.INSPECTIONPRIORITY NE 'GOOD' AND PIMSPOLICY.PIMSPOLICY.UNDERWRITINGSTATUSID EQ 10 OR 14 AND PIMSPOLICY.PIMSPOLICY.INSPECTIONSTATUSID EQ 2 OR 8 THEN 1 ELSE 0 ;
FINALIZED/I11C=IF PIMSPOLICY.PIMSPOLICY.INSPECTIONPRIORITY NE 'GOOD' OR 'LOW' AND PIMSPOLICY.PIMSPOLICY.ORIGINALINSPECTBYDT IS-FROM '20120401' TO '20121231' AND PIMSPOLICY.PIMSPOLICY.UNDERWRITINGSTATUSID EQ 13 AND PIMSPOLICY.PIMSPOLICY.INSPECTIONSTATUSID EQ 2 OR 8 THEN 1 ELSE 0 ;
ALLUW/I11C=PENDING + INPROGRESS + FINALIZED ;
UWCAND/I11C=IF PIMSPOLICY.PIMSPOLICY.INSPECTIONPRIORITY NE 'GOOD' AND PIMSPOLICY.PIMSPOLICY.INSPECTIONSTATUSID EQ 1 OR 2 OR 8 THEN 1 ELSE 0 ;
TotalCancellations/I9C=PIMSPOLICY.PIMSPOLICY.ISNONRENEW + PIMSPOLICY.PIMSPOLICY.ISMIDTERMCANCEL + PIMSPOLICY.PIMSPOLICY.ISCANCEL ;
TotalOtherChanges/I9c=PIMSPOLICY.PIMSPOLICY.ISDEDUCTIBLECHANGE + PIMSPOLICY.PIMSPOLICY.ISCLAIMSURCHARGE + PIMSPOLICY.PIMSPOLICY.ISPHYSICALCHARACTERISTICSSURCHARGE + PIMSPOLICY.PIMSPOLICY.ISREMOVECOVERAGE + PIMSPOLICY.PIMSPOLICY.ISPROGRAMCHANGE + PIMSPOLICY.PIMSPOLICY.ISEXCLUDECOVERAGE + PIMSPOLICY.PIMSPOLICY.WINDHAILDEDUCTIBLECHANGE ;
END
SET COMPONENT=Table_1
-*component_type report
TABLE FILE PIMSPOLICY
SUM AWAITING AS 'Awaiting Inspections'
OVER COMPLETE AS 'Completed Inspections'
OVER TOTALI AS 'Total Inspection Candidates'
BY PIMSPOLICY.PIMSPOLICY.RENEWALAGENCYNBR AS '.'
WHERE PIMSPOLICY.PIMSPOLICY.ORIGINALINSPECTBYDT FROM '20120401' TO '20121231';
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=TITLE, COLUMN=N1, COLOR=RGB(255 255 255), BACKCOLOR=RGB(255 255 255), $
TYPE=DATA, COLUMN=N1, COLOR=RGB(255 255 255), BACKCOLOR=(RGB(255 255 255) RGB(235 235 240)), $
ENDSTYLE
END

SET COMPONENT=Table_3
-*component_type report
TABLE FILE PIMSPOLICY
SUM PENDING AS 'Pending '
OVER INPROGRESS AS 'In Progress/Deferred'
OVER FINALIZED AS 'Finalized'
OVER ALLUW AS 'Available for Underwriting '
OVER UWCAND AS 'Underwriting Candidates'
BY PIMSPOLICY.PIMSPOLICY.RENEWALAGENCYNBR AS '.'
WHERE PIMSPOLICY.PIMSPOLICY.ORIGINALINSPECTBYDT FROM '20120401' TO '20121231';
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=TITLE, COLUMN=N1, COLOR=RGB(255 255 255), BACKCOLOR=RGB(255 255 255), $
TYPE=DATA, COLUMN=N1, COLOR=RGB(255 255 255), BACKCOLOR=(RGB(255 255 255) RGB(235 235 240)), $
ENDSTYLE
END

SET COMPONENT=Table_2
-*component_type report
TABLE FILE PIMSPOLICY
SUM COMPUTE AWPERC/D12.2%=( AWAITING / TOTALI ) * 100 ; AS 'Awaiting Inspections'
OVER COMPUTE COMPERC/D12.2%=( COMPLETE / TOTALI ) * 100 ; AS 'Completed Inspections'
OVER COMPUTE TOTALIPERC/D12.2%=AWPERC + COMPERC ; AS 'Total Inspection Candidates'
BY PIMSPOLICY.PIMSPOLICY.RENEWALAGENCYNBR AS '.'
WHERE PIMSPOLICY.PIMSPOLICY.ORIGINALINSPECTBYDT FROM '20120401' TO '20121231';
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=TITLE, COLUMN=N1, COLOR=RGB(255 255 255), BACKCOLOR=RGB(255 255 255), $
TYPE=DATA, COLUMN=N1, COLOR=RGB(255 255 255), BACKCOLOR=(RGB(255 255 255) RGB(235 235 240)), $
ENDSTYLE
END

SET COMPONENT=Table_4
-*component_type report
TABLE FILE PIMSPOLICY
SUM COMPUTE PENDPER/D12.2%=( PENDING / ALLUW ) * 100 ; AS 'Pending'
OVER COMPUTE INPROGPER/D12.2%=( INPROGRESS / ALLUW ) * 100 ; AS 'In Progress'
OVER COMPUTE FINALPERC/D12.2%=( FINALIZED / ALLUW ) * 100 ; AS 'Finalized'
OVER COMPUTE ALLPERC/D12.2=( ALLUW / ALLUW ) * 100 ; AS 'Available for Underwriting'
BY PIMSPOLICY.PIMSPOLICY.RENEWALAGENCYNBR AS '.'
WHERE PIMSPOLICY.PIMSPOLICY.ORIGINALINSPECTBYDT FROM '20120401' TO '20121231';
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=TITLE, COLUMN=N1, BACKCOLOR=RGB(255 255 255), $
TYPE=DATA, COLUMN=N1, COLOR=RGB(255 255 255), BACKCOLOR=(RGB(255 255 255) RGB(235 235 240)), $
ENDSTYLE
END

SET COMPONENT=Table_5
-*component_type report
TABLE FILE PIMSPOLICY
SUM TotalCancellations/I9C AS 'Total Cancellations'
OVER TotalOtherChanges/I9C AS 'Total Other Changes'
OVER PIMSPOLICY.PIMSPOLICY.ISFILEONLY/I11C AS 'Total with No Changes'
BY PIMSPOLICY.PIMSPOLICY.RENEWALAGENCYNBR AS '.'
WHERE PIMSPOLICY.PIMSPOLICY.ORIGINALINSPECTBYDT FROM '20120401' TO '20121231';
WHERE PIMSPOLICY.PIMSPOLICY.INSPECTIONPRIORITY NE 'GOOD' OR 'LOW';
WHERE PIMSPOLICY.PIMSPOLICY.INSPECTIONSTATUSID EQ 2 OR 8;
WHERE PIMSPOLICY.PIMSPOLICY.UNDERWRITINGSTATUSID EQ 13;
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=TITLE, COLUMN=N1, COLOR=RGB(255 255 255), BACKCOLOR=RGB(255 255 255), $
TYPE=DATA, COLUMN=N1, COLOR=RGB(255 255 255), BACKCOLOR=(RGB(255 255 255) RGB(235 235 240)), $
ENDSTYLE
END

SET COMPONENT=Table_6
-*component_type report
TABLE FILE PIMSPOLICY
SUM PIMSPOLICY.PIMSPOLICY.ISNONRENEW/I11C AS 'Non Renew '
OVER PIMSPOLICY.PIMSPOLICY.ISMIDTERMCANCEL/I11C AS 'Mid-Term Cancel (75 day)'
OVER PIMSPOLICY.PIMSPOLICY.ISCANCEL/I11C AS 'Cancel (14 day)'
OVER TotalCancellations
OVER PIMSPOLICY.PIMSPOLICY.ISDEDUCTIBLECHANGE/I11C AS 'Deductible Change'
OVER PIMSPOLICY.PIMSPOLICY.WINDHAILDEDUCTIBLECHANGE/I11C AS 'Windhail Deductible Change'
OVER PIMSPOLICY.PIMSPOLICY.ISCLAIMSURCHARGE/I11C AS 'Claim Surcharge'
OVER PIMSPOLICY.PIMSPOLICY.ISPHYSICALCHARACTERISTICSSURCHARGE/I11C AS 'Phys Char Surcharge'
OVER PIMSPOLICY.PIMSPOLICY.ISREMOVECOVERAGE/I11C AS 'Remove Coverage'
OVER PIMSPOLICY.PIMSPOLICY.ISEXCLUDECOVERAGE/I11C AS 'Exclude Coverage'
OVER PIMSPOLICY.PIMSPOLICY.ISPROGRAMCHANGE/I11C AS 'Program Change'
OVER TotalOtherChanges/I9C AS 'Total Other Changes'
OVER PIMSPOLICY.PIMSPOLICY.ISFILEONLY/I11C AS 'Total No Change'
BY PIMSPOLICY.PIMSPOLICY.RENEWALAGENCYNBR AS '.'
ACROSS PIMSPOLICY.PIMSPOLICY.INSPECTIONPRIORITY AS 'Priority' NOPRINT
WHERE PIMSPOLICY.PIMSPOLICY.ORIGINALINSPECTBYDT FROM '20120401' TO '20121231';
WHERE PIMSPOLICY.PIMSPOLICY.INSPECTIONPRIORITY NE 'GOOD' OR 'LOW';
WHERE PIMSPOLICY.PIMSPOLICY.INSPECTIONSTATUSID EQ 2 OR 8;
WHERE PIMSPOLICY.PIMSPOLICY.UNDERWRITINGSTATUSID EQ 13;
ON TABLE ROW-TOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=ACROSSTITLE, ACROSS=N1, COLOR=RGB(255 255 255), $
TYPE=TITLE, ACROSSCOLUMN=N13, STYLE=BOLD, $
TYPE=TITLE, ACROSSCOLUMN=N12, STYLE=BOLD, $
TYPE=TITLE, ACROSSCOLUMN=N4, STYLE=BOLD, $
TYPE=TITLE, COLUMN=N1, COLOR=RGB(255 255 255), BACKCOLOR=RGB(255 255 255), $
TYPE=DATA, ACROSSCOLUMN=N13, STYLE=BOLD, $
TYPE=DATA, ACROSSCOLUMN=N12, STYLE=BOLD, $
TYPE=DATA, ACROSSCOLUMN=N4, STYLE=BOLD, $
TYPE=DATA, COLUMN=N1, COLOR=RGB(255 255 255), $
ENDSTYLE
END

SET COMPONENT=Table_7
-*component_type report
TABLE FILE PIMSPOLICY
SUM COMPUTE AWPERC/D12.2%=( AWAITING / TOTALI ) * 100 ; AS '.'
OVER COMPUTE COMPLPERC/D12.2%=( COMPLETE / TOTALI ) * 100 ; AS '.'
WHERE PIMSPOLICY.PIMSPOLICY.ORIGINALINSPECTBYDT FROM '20120401' TO '20121231';
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=TITLE, COLUMN=N1, BACKCOLOR=RGB(255 255 255), $
TYPE=TITLE, COLUMN=N2, BACKCOLOR=RGB(255 255 255), $
TYPE=DATA, COLUMN=N2, BACKCOLOR=(RGB(255 255 255) RGB(235 235 240)), $
ENDSTYLE
END

SET COMPONENT=Table_8
-*component_type report
TABLE FILE PIMSPOLICY
SUM COMPUTE pendperc/D12.2%=( PENDING / ALLUW ) * 100 ; AS '.'
OVER COMPUTE inprogperc/D12.2%=( INPROGRESS / ALLUW ) * 100 ; AS '.'
OVER COMPUTE finalperc/D12.2%=( FINALIZED / ALLUW ) * 100 ; AS '.'
WHERE PIMSPOLICY.PIMSPOLICY.ORIGINALINSPECTBYDT FROM '20120401' TO '20121231';
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=TITLE, COLUMN=N1, BACKCOLOR=RGB(255 255 255), $
TYPE=TITLE, COLUMN=N2, BACKCOLOR=RGB(255 255 255), $
TYPE=TITLE, COLUMN=N3, BACKCOLOR=RGB(255 255 255), $
TYPE=DATA, COLUMN=N2, BACKCOLOR=(RGB(255 255 255) RGB(235 235 240)), $
ENDSTYLE
END

SET COMPONENT=Table_9
-*component_type report
TABLE FILE PIMSPOLICY
SUM COMPUTE cancelperc/D12.2%=( TotalCancellations / FINALIZED ) * 100 ; AS '.'
OVER COMPUTE nochangeperc/D12.2%=( CNT.PIMSPOLICY.PIMSPOLICY.ISFILEONLY / FINALIZED ) * 100 ; AS '.'
OVER COMPUTE otherchangeperc/D12.2%=100 - cancelperc - nochangeperc ; AS '.'
BY PIMSPOLICY.PIMSPOLICY.RENEWALAGENCYNBR AS '.'
WHERE PIMSPOLICY.PIMSPOLICY.ORIGINALINSPECTBYDT FROM '20120401' TO '20121231';
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=TITLE, COLUMN=N4, BACKCOLOR=RGB(255 255 255), $
TYPE=TITLE, COLUMN=N3, BACKCOLOR=RGB(255 255 255), $
TYPE=TITLE, COLUMN=N2, BACKCOLOR=RGB(255 255 255), $
TYPE=TITLE, COLUMN=N1, COLOR=RGB(255 255 255), BACKCOLOR=RGB(255 255 255), $
TYPE=DATA, COLUMN=N1, COLOR=RGB(255 255 255), BACKCOLOR=(RGB(255 255 255) RGB(235 235 240)), $
ENDSTYLE
END

SET COMPONENT=Table_10
-*component_type report
TABLE FILE PIMSPOLICY
SUM COMPUTE cancelperc/D12.2%=( TotalCancellations / FINALIZED ) * 100 ; AS '.'
OVER COMPUTE nochangeperc/D12.2%=( CNT.PIMSPOLICY.PIMSPOLICY.ISFILEONLY / FINALIZED ) * 100 ; AS '.'
OVER COMPUTE othechgperc/D12.2%=( TotalOtherChanges / FINALIZED ) * 100 ; AS '.'
WHERE PIMSPOLICY.PIMSPOLICY.ORIGINALINSPECTBYDT FROM '20120401' TO '20121231';
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=TITLE, COLUMN=N1, BACKCOLOR=RGB(255 255 255), $
TYPE=TITLE, COLUMN=N2, BACKCOLOR=RGB(255 255 255), $
TYPE=TITLE, COLUMN=N3, BACKCOLOR=RGB(255 255 255), $
ENDSTYLE
END

COMPOUND END

I am not sure why some of the code is so large. It should all be the same. That wasn't intentional.

I'm sure it was not

Just glancing thru, there IS different styling for eacn compontent - so you could need to make them all consistant.

quote:

I am not sure why some of the code is so large

You can prevent that from happening by enclosing your code within the code brackets, shown as , the rightmost icon above (when replying).