report design

A

anil

Hi all
I need help in formatting the report design for this crosstab query.
Month SiteCode Parameters
Location BOD pH SS E.Coli Total P Total N SAR EC Salinity TKN
January Ara SLARA001 x x x x x x x x
SOARA002 x x x x x x
SOARA004 x x x
SOARA005 x x x
SOARA008 x x x x
TTARA001 xx xx xx xx xx xx
TTARA002 xx xx xx xx xx xx
GOARA011 x x x
GOARA012 x x x

I want the format as
MONTH SITECODE PARAMETER
January SLARA001 BOD pH SS E.Coli TotalN TotalP SAR EC Salinity TKN
January SOARA002 BOD pH SS Ecoli Total N Salinity

i.e I want to just list the parameters in horizantal format.Here tables
are
tblSite,tblMonth,tblParameter,tblSiteParameter(Function table of many
to many relationship).
x is check box that tells which parameter to test this month.
Similar is for all 12 months.

Is there any easier method to do this.

thanks
anil
 
Top