Recreating a Crystal Report with Subreports

English Forum
1

Hello,

I have the following table:

Cabinet ID DoorQty Width String Height String PanelQty PanelShortName PanelName PanelWidthString PanelLengthString PanelMaterial RailQty RailShortName RailName RailWidthString RailLengthString RailMaterial StileQty StileShortName StileName StileWidthString StileLengthString StileMaterial 1 2 14 13/16 30 1/4 2 DFP Door Flat Panel 11 9/16 27 2 DBR Door Bottom Rail 2 11 13/16 2 DLS Door Left Stile 2 30 1/4 1 2 14 13/16 30 1/4 2 DFP Door Flat Panel 11 9/16 27 2 DBR Door Bottom Rail 2 11 13/16 2 DRS Door Right Stile 2 30 1/4 1 2 14 13/16 30 1/4 2 DFP Door Flat Panel 11 9/16 27 2 DTR Door Top Rail 2 11 13/16 2 DLS Door Left Stile 2 30 1/4 1 2 14 13/16 30 1/4 2 DFP Door Flat Panel 11 9/16 27 2 DTR Door Top Rail 2 11 13/16 2 DRS Door Right Stile 2 30 1/4

What I need this data to look like, in the report is this:

Cabinet ID DoorQty Width String Height String PanelQty PanelShortName PanelName PanelWidthString PanelLengthString PanelMaterial RailQty RailShortName RailName RailWidthString RailLengthString RailMaterial StileQty StileShortName StileName StileWidthString StileLengthString StileMaterial 1 2 14 13/16 30 1/4 2 DFP Door Flat Panel 11 9/16 27 2 DBR Door Bottom Rail 2 11 13/16 2 DLS Door Left Stile 2 30 1/4 2 DRS Door Right Stile 2 30 1/4 2 DTR Door Top Rail 2 11 13/16

Basically, I need to now show any repeated information, but all unique information needs to be on a new line.

Now, I have 4 separate queries that I use to make the above table, and I will post them (along with the database structure) if it will help to figure what I need to do.

Thank you so much for any help you can provide.

2

Hi Andres,
thank you for your note.

I think you can use the designer function Previous() in the condition for the dataline e.g.
CabinetID <>Previous(CabinetID)
Kind regards

Erdal Alacali
Technical Support
combit GmbH