Joined: 02 Nov 2015
Online Status: Offline
Posts: 3
Topic: Crosstab suppressed fields Posted: 20 Nov 2015 at 10:12am
I have a report that needs to show replicate values for lab tests along with stored values for the average and standard deviation. I have been working with a Crystal XI crosstab with this setup:
Rows:ChemicalName......Columns:SampleGrp and RepNumber....Summarized flds:max result and max average and max stddev
The goal is to display results in the RepNumber columns and the stored statistics in the subtotal column.
I can suppress the average and stddev in the RepNumber column and suppress the result in the SampleGrp Subtotal column. It looks perfect until I export to Excel and reserved spaces(from suppressed fields) make a mess. Is there any way to force Crystal to not reserve the space in the export? Or is there a way to create a formula so that result would appear in RepNumber and average and stddev would appear in the subtotal column? Is there some way to reference the subtotal column?
Joined: 02 Nov 2015
Online Status: Offline
Posts: 3
Posted: 30 Nov 2015 at 8:49am
I think my explanation of the issue is too complex? I don't know how to add a screen shot. So I will attempt to "draw" what this looks like.
Sample 1 Grp
.......Sample 1...Duplicate 1...Duplicate 2...subtotal
chemical--result---result---result---stored average
Is there any way to capture the average from the database in the subtotal column? Or can anyone think of a different approach that I could try?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum