multiple rows on a single page 1

[kevlar26]

I am writing a report to show information for each patient. A lot of people have multiple coverages, I am having trouble getting all of one persons coverages to show on a single page rather then repeating the entire page each time this person is entered for a different coverage.

example:

NAME COVERAGE
bob jones medicare
joe bob medicaid
bob jones healthwave

Rather then having bob jones show up on 2 different pages of the report I need to have bob jones show on one page and show both coverages.

I would like the report to show:

NAME COVERAGE
Bob jones medicare, healthwave... etc

I think I am just missing something simple here.
Thanks in advance for any help!

 

[lbass]

Insert a group on the patient name field, and then create three formulas:

//{@reset} to be placed in the group header and suppressed:
whileprintingrecords;
stringvar x;
if not inrepeatedgroupheader then
x := "";

//{@accum} to be placed in the detail section and suppressed:
whileprintingrecords;
stringvar x := x + {table.coverage} + ", ";

//{@display} to be placed in the group footer:
whileprintingrecords;
stringvar x;
if len(x) >= 2 then
left(x,len(x)-2)

Drag the groupname into the group footer and then suppress the group header and detail section.

-LB

 

[kevlar26]

That didnt work out so well..
I should have explained what I was doing a little better.. I am not creating a list.

I have a form that has to be filled out before a patient comes in. (Currently someone has to look all of this info up in the database and hand write it)

So the CR I am doing pulls the info and places it on the form to be printed.

The only problem I am having is if someone has multiple coverages it is making multiple copies of the form for that person (one for each coverage). I need to figure out how to make it put all of the coverages on one form with the rest of their info.

 

[lbass]

You will need to identify the report sections where you are displaying the information and in general how the form is set up in relation to report sections.

-LB

 

[lbass]

Actually, you are creating a horizontal list. You need to do as I said initially. I think your form might be set up in a detail section, which is why it is printing multiple times. Move it to the group footer section, suppress the group header and detail section, and implement my earlier suggestion.

-LB