A Summary Report of a Table

[TEM3]

Using Crystal Reports 8.5 and Oracle Tables:

One of the tables I need to maintain is a bear. It has about 400 fields but only about a dozen records representing a work location. Of the 400 fields only 100 or so are populated and, therefore, of interest.

I would like to create a crosstab style report (but not an actual crosstab) with one of the fields across the top (the name of the location), the name of the other fields of interest down the left side and the value of each of these field under the respective header (location name) field so I could easily compare the table values of each of the fields side by side.

Is there an easy way to do this in CR 8.5??

 

[IdoMillet]

Please show what the display should look like.


Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[TEM3]

Location1 Location2 Location3 Location4 Location5

Field1 Data Data Data Data Data
Field2 Data Data Data Data Data
Field3 Data Data Data Data Data
Field4 Data Data Data Data Data
Field5 Data Data Data Data Data
Field6 Data Data Data Data Data

The column header would be the value of one of the field (location name). The row heading would be the table name of the other fields. The "Data" would be the field value for each of the locations.

 

[IdoMillet]

I don't understand the logic. Sinced there are multiple records, I don't see what should be shown if the same field1 has different values for the same location.




Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com