DJP236
asked on
Crystal Reports Writer
I need to collapse a group of similiar records into one record for display,
and then do the same for another group of records. I am not sure how to do it.
Example records are:
Category period value
--------- --------- --------
record #1 "Stocks" "6month" 1.00
record #2 "Stocks" "12month" 3.45
record #3 "Stocks" "24month" 10.34
record #4 "Stocks" "36month" 11.78
And here is how I need them to appear on the report:
category 6mo 12month 24month 36month
-------------------------- ---------- ---------- ---------- ---------- ------
stocks 1.00 3.45 10.34 11.78
and then do the same for another group of records. I am not sure how to do it.
Example records are:
Category period value
--------- --------- --------
record #1 "Stocks" "6month" 1.00
record #2 "Stocks" "12month" 3.45
record #3 "Stocks" "24month" 10.34
record #4 "Stocks" "36month" 11.78
And here is how I need them to appear on the report:
category 6mo 12month 24month 36month
--------------------------
stocks 1.00 3.45 10.34 11.78
ASKER
I have not with this particulr report. Is there a way to do this in a standard report form via formulas or hidden fields?
Sure. A cross tab would do it directly.
Can there be multiple records for each period?
If so are you summing the values?
Are there other periods?
mlmcc
Can there be multiple records for each period?
If so are you summing the values?
Are there other periods?
mlmcc
ASKER
Hi mlmcc,
I guess I wasn't clear -
I was trying to get by without using a crosstab. I evenually used the crosstab via a subreport but should not have had to because the tables used were indexed and linked. The issue with the tables is key fields are one too many relationship which created a seperate detail line for each. I needed the data formatted vertically into one record or within a single Details line.
Is there a way to do this outside of a crosstab? Thanks.
I guess I wasn't clear -
I was trying to get by without using a crosstab. I evenually used the crosstab via a subreport but should not have had to because the tables used were indexed and linked. The issue with the tables is key fields are one too many relationship which created a seperate detail line for each. I needed the data formatted vertically into one record or within a single Details line.
Is there a way to do this outside of a crosstab? Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mlmcc