Shared Variables WhilePrintingRecords? Empty fields format

building reports crystal reports
1

So I created formulated fields in order to have the output the requester would like it to display.

Doing so however I get extra rows of data (empty fields).
Not sure how to explain it, please see attached.

I can format it if I was using MS Access report but not sure how to format it in CRW?

For each record they’ll have columns of data but with the formulated fields it creates a row for each record.

I don’t know if that made sense but would like the column fields to show in one row.

There are 3 sets of column fields that are formulated fields. So when the person has 3 results, instead all showing in one row it shows it 3 times and then shows when there is data to display in any of the 3 columns.

From what I’ve gathered so far is using shared variables
with the whilepringrecords.

however I am unsure how to apply it with three fields.
The TestType, HighestLevel, and LastTestDate.
For each of the 3 TestTypes, there’s a Level and a LastTestDate.

  1. Moves, level, and a LastTestDate
  2. Dance, level, and a and a LastTestDate
  3. Free, level, and a LastTestDate

Where ALL of them may have a level with a LastTestDate.
Or just one or two of the TestTypes may have a Level with a LastTestDate
CRW.PNG
CRWDesign.PNG
CRWFormatted.PNG

techsupport15 (BOB member since 2015-10-05)

2

I suspect there is a better way to do this but this will work.

  1. Create a formula and call it Start Moves
  2. In this formula enter the following
whileprintingrecords;
stringvar Moves := "";
  1. Place it in the Group Header for MBR#
  2. Create a formula and call it Middle Moves
  3. In this formula enter the following
whileprintingrecords;
stringvar Moves;
IF {Testtype}='Moves' then
Moves := {Testtype};
  1. Place it in the Details Section
  2. Create a formula and call it Final Moves
  3. In the formula add
whileprintingrecords;
stringvar Moves;
Moves;
  1. Place it in your group footer

Repeat this for each additional field you need added in, obviously changing the name of the variable and formula’s

pidgeon001 :australia: (BOB member since 2012-03-06)

3

Thank you! Will try it in the future!

The easiest way was to do a MAX on those fields from the Group on Member.
I don’t know why I didn’t consider that since that’s what I did in Access.

techsupport15 (BOB member since 2015-10-05)