Formula to derive description 1

[TimothyP]

I am using Crystal Reports 8.5 against a SQL server table.

I have a commodity table that looks like this

Com_ID Com_lvl_1 Com_lvl_2 Description
005 005 Abrasives
00514 005 14 Abrasives toxic
00528523 005 28 Abrasives non toxic
035 035 Aircraft Stuff
03501 035 01 Aircraft Doors
03509232 035 09 Aircraft Windows

How do I write a report that derives the high level description?

Sample report...

Com_ID Description High Level Description
005 Abrasives Abrasives
00514 Abrasives toxic Abrasives
00528523 Abrasives non toxic Abrasives
035 Aircraft Stuff Aircraft Stuff
03501 Aircraft Doors Aircraft Stuff
03509232 Aircraft Windows Aircraft Stuff

Thanks for your time,
Tim

 

[lbass]

Add the table a second time to create table_1. Link the two tables on {table.Com_lvl_1} to {table_1.Com_ID}. Then add {table_1.description} to your detail section for the higher level description.

-LB

 

[TimothyP]

Perfect, thank you!