Get Dates to all print on one page not 4 1

[HookEmHorns]

Hello Experts -

I am new relatively new to Crystal and its causing some heartburn right about now.

I have a report form my client needs and if I keep it without a gouping, I get 4 pages for the 4 dates on my form. I would love to get it all to stay on one page and not print 4 times.

I created 4 formulas MMRDate1, MMRDate2, MMRDate3 and MMRDate4.

MMRDate1 =

IF {cusASIISC_ImmunizationsGet.Category} = "Measles, Mumps, Rubella" and {cusASIISC_ImmunizationsGet.Sequence} = 0
THEN {cusASIISC_ImmunizationsGet.ImmunDte}

MMRDate2 =

IF {cusASIISC_ImmunizationsGet.Category} = "Measles, Mumps, Rubella" and {cusASIISC_ImmunizationsGet.Sequence} = 1
THEN {cusASIISC_ImmunizationsGet.ImmunDte}

MMRDate3 =

IF {cusASIISC_ImmunizationsGet.Category} = "Measles, Mumps, Rubella" and {cusASIISC_ImmunizationsGet.Sequence} = 2
THEN {cusASIISC_ImmunizationsGet.ImmunDte}

MMRDate4 =

IF {cusASIISC_ImmunizationsGet.Category} = "Measles, Mumps, Rubella" and {cusASIISC_ImmunizationsGet.Sequence} = 3
THEN {cusASIISC_ImmunizationsGet.ImmunDte}

I am stumped how to get this to print on one page.

 

[Turkbear]

Hi,
Where are they placed? - If in details there should be no reason for 4 pages ...What else is in the detail section?

Have you added any special formatting ( like New Page After or New Page Before?)






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[HookEmHorns]

I placed the 4 formulas in my detail section. I have the following 2 values ckd on the details tab:

Free Form Placement
Keep Together

Its printing on 4 pages and I can't figure out how or why its doing this. I need it to stay on one page only.

 

[lbass]

It looks like these would print each in their own row. Is it that you want them in the same line? Why aren't you grouping? You could achieve the one line, if you insert a group on the appropriate field and then insert maximums on each formula at the group level. Then you would suppress the detail section.

-LB

 

[HookEmHorns]

lbass -

I would indeed like them in the same line. I don't need to group because this form will only print one patient at a time. If anything, I can group on the patients name. With that, how do I insert maximuns on each formula at the group level??

Your help is appreciated.

 

[lbass]

Yes, insert a group on patient name, and then place your formulas in the detail section, right click on each->insert summary->maximum->group level. Repeat for each formula. Then suppress the detail section and group header, and drag the groupname into the group footer if you want it to show.

-LB

 

[HookEmHorns]

Lbass -

Thank you ... no more heartburn!