Spliting a report field into an array

[Joy1]

Hi guys

I'm working on CR9 and connecting to Oracle via ODBC.

I've created a report to show an asset list for a specific group.
Report fields:
DeviceName, DeviceType, SoftwareType & Software. The SoftwareType field contain 3 classifying values (namely: Operating System, Database, Application) and the Software field contain 3 values (Operating System Name, Database Name, Application Name).
How can i create an array so that i can eliminate SoftwareType & Software as report fields and instead have Operating System, Database and Application as new report fields detailing SoftwareType attributes (Operating System Name, Database Name& Application Name) as their contents?

Please assist.


Joy

 

[lbass]

If I'm following you, you can create conditional formulas like this:

//{@Operating System Name}:
if {table.softwaretype} = "Operating System" then
{table.software}

//{@Database Name}:
if {table.softwaretype} = "Database" then
{table.software}

//etc.

If you are grouping on device name, you could then place these formulas in the detail section, insert maximums on them, drag the results into the group header, and then suppress the detail and group footer sections.

-LB

 

[Joy1]

Thanks LB for your input. Tried the conditional formulas as adviced - works like a charm - THANK YOU.

Joy