Putting Together List Boxes?

[#1]

I don't know if someone else has asked this, but is there a way to join List Boxes into on List Box? More specifically I have for list boxes showing delinquency amounts, labeled "0-30 Days", "31-60 days", "61-90 days" and ">90 days". Is there a way to have a list box just titled "Delinquencies" that has these 4 categories as options that connects to the data from these 4 boxes?

[Clever_Anjos]

You can prepare a table at script consolidating those fields

[Peter_Cammaert]

How about turning your four list boxes into a single one, and prefixing each value with its category and a slash e.g. "0-30 Days" & "/" & "27", "0-30 Dats" & "/" & "28" etc.

Then enable the "Show as Tree View" option in ListBox->Properties->General.

Peter

[jagan · Accepted solution]

Hi,

If you have two date fields in your table, then the differences should between the two dates can be categorised like this

Load

     FromDate,

     ToDate,

     If(Num(ToDate - FromDate) > 90, '>90 days',

     If(Num(ToDate - FromDate) >60 and Num(ToDate - FromDate) <= 90, '61-90 days',

     If(Num(ToDate - FromDate) >30 and Num(ToDate - FromDate) <= 60, '31-60 days',

     If(Num(ToDate - FromDate) >0 and Num(ToDate - FromDate) <= 30, '0-30 days', 'N/A')))) AS Delinquencies

FROM Data;

Now use Delinquencies field as List/Filter box.

Hope this is what you are expecting.

Regards,

jagan.

[israrkhan]

Hi John,

in above posts they have describe you script level solution.

but if you want design level, the try this one.

uncheck show caption for all list boxes on Caption tab. and show border as well.

then create a text object, give it color you want , and text "Delinquencies"

then arrange all list boxes like column, and put the txt box on top, it will look like list box header(caption)

see the attached example...