Formatting Column Data

[sbirkenkamp]

In my CR I have the report formatted into three columns. Does anyone know if it is possible to have for example on hte last row if there is only two columns filled in, to have the data be in column 1 & 3? and if there is only 1 column with data that it prints in column 2?

xxx xxx xxx
xxx xxx xxx
xxx xxx

or

xxx xxx xxx
xxx xxx xxx
xxx

 

[synapsevampire]

If you use formulas for each field, you can do whatever you like:

formula1
if recordnumber >= totalrecordcount-3) then
(
if isnull({table.fld2}) and isnull({table.field3}) then
""
else
{table.fld1}
)

formula2
if recordnumber >= totalrecordcount-3) then
(
if isnull({table.fld2})
and
(
isnull({table.field3})
and
not(isnull({table.field1}))
)
then
{table.fld1}
else
if isnull({table.fld2})
and
(
isnull({table.field1})
and
not(isnull({table.field3}))
)
then
{table.fld3}
)
)

formula3
if recordnumber >= totalrecordcount-3) then
(
if isnull({table.fld2}) and isnull({table.field1}) then
""
else
{table.fld3}
)


Didn't test, but you should understand the theory, and that it isn't real easy, but doable...

-k