Hello,

I'm in the process of converting oracle reports to user end reports or ReportCaster reports. Instead of re-creating all of these reports, I'm just using the same SQL code and using the SQL Report option to create the procedure.

When it comes to formatting a PDF-only output, I want to indent some of the values in the column TYPE. Example:

TYPE
A. Alumni
A1. Young Alumni
A2. Alumni Staff
B. Parents

I only want to indent A1 and A2. Because my BY is on TYPE, if I added spaces before A1 and A2, they are sorted on top of A. Alumni. Is there a way I can just indent A1 and A2 and keep them ordered under A. Alumni?

---

TABLE FILE SQLOUT
PRINT
DONOR/D20C AS 'Donors'
AMT/D20.2CM AS '$'
BY LOWEST TYPE
ACROSS LOWEST FISCAL_YEAR AS ''
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE ROW-TOTAL AS 'TOTAL'
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *

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

I would DEFINE the column that is displayed and use the original column in the BY with a NOPRINT. Something like this untested code:

DEFINE FILE SQLOUT
TYPE_DISP/A20 = IF TYPE IN ('A1', 'A2', 'B1', 'B2', 'C1', 'C2') THEN '   ' | TYPE ELSE TYPE;
END

TABLE FILE SQLOUT
PRINT
DONOR/D20C AS 'Donors'
AMT/D20.2CM AS '$'

BY LOWEST TYPE NOPRINT
BY LOWEST TYPE_DISP AS 'TYPE'

ACROSS LOWEST FISCAL_YEAR AS ''
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE ROW-TOTAL AS 'TOTAL'
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
...
END

Perfect! Thank you, Francis.