Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help on Horizontal grouping

Status
Not open for further replies.

pmpafonso

IS-IT--Management
Apr 28, 2009
2
PT
Hi,

I have been having some problems trying to group some fields and showing them in horizontal.

For example,

I have two groups, one by type of fabric another by size.
I need to show data this way:

type totalbox size
number per box


45 50 55 60 65
Cotton 25 5 2 6 8 4

Dont know if i should use some more groups... but i think i have already tried everything.

If someone can help me with this i would be much appreciated.

Thanks.
 
Insert a crosstab where you use type as the row and size as the column, with count of boxes as the summary field. Place the crosstab in the report header or report footer section.

-LB
 
Thanks.

I tried everything... except putting it on the header...

Still new to this :D

Thx again
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top