Getting bullet points/asterisks to print

[Roni Sutton]

I have a report which is based on a query. I used the report wizard to create a block style report that looks like:

Goal1 Objective1 Initiative1 Status1
Status2

Initiative2 Status1
Status2

Objective2 Initiative1 Status1
Status2
I want to print bullets in front of each status, initiative and objective. The report is set up with breakpoints on each of those fields so that the information only prints once. If I put the bullets in as text lables, they print on each line. If I set the field up as an unbound field ie ="*"&[fieldname], it prints it correctly, but prints one for every line of the report (example follows)

Goal1 *Objective1 *Initiative1 *Status1
Goal1 *Objective1 *Initiative1 *Status2
Goal1 *Objective1 *Initiative1 *Status3

I only want to print each Goal, Objective and initiative ONCE! But I want the bullets.

Any ideas? Sorry this is so long.

Roni

 

[Travis]

Use Groupings
Set Goal,Objective and Initiative as Groups
Place the appropriate field in its appropriate Group, leaving Status in the Details section Your Report will look like this now:

Goal1
*Objective1
*Initiative1
*Status1
*Status2
*Status3
*Initiative2
*Status1
*Status2
*Status3

Hope this is helpful


[This message has been edited by Travis (edited 01-08-2000).]