Puting a demarcation line between the groups

[sgrahman]

Hi,

I have created the following report which shows data by ethnic group, sex and grade level in one page per school.

For example:

XYZ School

Group Index suspensions
--------------------------------------------------------------------------
American Indian 50 5

Asian American 52 7

Male 47 8

Femal 48 6

Grade - 1 56 5

Grade - 2 54 4

Currently, I don't have a demarcation line or If I put one, it shows up after every single group. What I want to do is to put a thick horizontal 2pt line after the end of ethnic group and after the end of sex group and after the end of Grade level. Thanks for your help.

 

[Rickster57]

groups

If you have a group header/footer for your ethnic group this will do the trick. Just put the line in your footer or header (depending where you want it) for ethnic group in that report

 

[sgrahman]

I should not have called them ethnic group, sex and grade level in my previous posting becasue they are under same column. They are all under same field called "group". May be I should have said, how can I put a 2pt line after Asian American, after Female and one after Grade - 2.

 

[Rickster57]

Line

Use the On Print Event of your report then. Place a 2 pt line in your report header or footer. Set it's format to Visible=No.

In the On Print Event:

me.linept2.visible=false

If me.group="Asian American" or me.group="Female" then
me.linept2.visible=true
end if

''or whatever criteria you choose