Skip to Content

Crystal Reports - Retrieve Different Data From Same Table

Hi,

I'm trying to retrieve different data from same table

Table= Asset
Field Name: Type of Asset=Equipment (Child)
Field Name: Asset Description= Equipment (Child) Description

Table= Asset
Field Name: Type of Asset = Building (Parent)
Field Name: Asset Description= Building (Parent) Description

In Crystal Report when I enter description fields names I'm getting the same description which is first field (child asset).

I would like to associate / combine two columns so it should show description based on the previous column which asset description.

Current Result

ASSET TYPE ASSET NO ASSET DESC  PARENT ASSET TYPE ASSET NO ASSET DESC Equipment   12345   child (desc)     Building       67899  child (desc)


Trying To Achieve:

ASSET TYPE ASSET NO ASSET DESC  PARENT ASSET TYPE ASSET NO ASSET DESC

Equipment   12345   child (desc)     Building       67899  Parent (desc)

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers