Invetory Labels - Extended Description

SUGGESTED

I am trying to add the extended item description to the inventory labels.  I am at a loss.  I've added the CI_ExtendedDescription in the Database Expert and added the field to the report - but when I try to print the labels, they are blank.   I'm not that familar with Crystal Reports.  I've done some searches and people refer to adding a formula, but I'm not sure where, or what formula to add.

I know it is a very broad question - and I don't have a lot of Crystal Reports experience.  But if anyone has some ideas on how to accomplish this - it would be appreciated.  I've already wasted a few hours experimenting and trying to figure it out!

Parents
  • 0

    Whatever table is in the report will need to be linked to CI_ExtendedDescription on the ExtendedDescriptionKey fields in each.  If your base table in the report doesn't have the field, then you will need to add it to the work table as a sourced UDF from CI_Item on the Item Code.

    Once you are able to link the tables.  You need to create a formula that checks if the ExtendedDescriptionKey is blank or 0000000000.  If it is, then use the standard ItemCodeDesc, if it isn't then use CI_ExtendedDescription.ExtendedDescriptionText.

    If you want to avoid table joins in the report, you can instead use a subreport and have it linked on the ExtendedDescriptionKey in the main report.

Reply
  • 0

    Whatever table is in the report will need to be linked to CI_ExtendedDescription on the ExtendedDescriptionKey fields in each.  If your base table in the report doesn't have the field, then you will need to add it to the work table as a sourced UDF from CI_Item on the Item Code.

    Once you are able to link the tables.  You need to create a formula that checks if the ExtendedDescriptionKey is blank or 0000000000.  If it is, then use the standard ItemCodeDesc, if it isn't then use CI_ExtendedDescription.ExtendedDescriptionText.

    If you want to avoid table joins in the report, you can instead use a subreport and have it linked on the ExtendedDescriptionKey in the main report.

Children