Grouping and Details

[crystaldev1]

Hello. I'm using CR 9 (sql server 2005). I would like to develop a report with three columns:

Type, Colors, Custom Fields

I would like to group by type and colors. Custom fields are linked to type but have no relationship with colors. Custom fields are linked to type. I would like to display as follows:

Type1
Blue Field1
Red Field2
Yello Field3
Field4

How could I list all of the custom fields linked to permit type to the right and also list colors of type in the middle of the report. Colors and custom fields are both linked to type but not with each other. Thanks.

 

[lbass]

Can't follow this. Please try again, showing how the data currently displays when the fields are placed in the detail section. Also please label all fields with table and field, as in {table.field}. It would help to also separately see the tables you are using and how they are linked. Finallly, show how you want the sample you have shown to display.

-LB

 

[pvidya]

Hi,

There could be a simpler answer but a solution that strikes me right away is to use two sub-reports, place them next to each other. One subreport would display the colurs and the other type.

The sub-reports would link to the main report on type - so for each grouping of type, the sub-reports would only display the details related to that type value.

Hope this helps.

 

[crystaldev1]

Pvidya, thaks for your input but I'm trying to avoid using subreports since I need to insert this report as a subreport and CR doesn't allow subreport within subreport.

Type1 <---(Group1)
Blue <---(Group2) CustomField1
Red CustomField2
Yello CustomField3
CustomField4

I do not want to place the customfields in detail section since it will list same custom fields for each Group2. It would be ideal to just list it separately, not under Group2.

 

[lbass]

Insert another GH#1 section, and place the custom fields (if they are actually separate fields, not instances of the same field) in GH1_b. Then format GH1_b to "Underlay following sections."

-LB