Hi everyone, I’m have a problem/question regarding how I can generate a report in next format:
1.    I have a object sale which have next elements:
    a.    Ariel
    b.    Tide
    c.    Persil
    d.    Colgate
    e.    Orbit
    f.    Aqua Fresh
    g.    …
    h.    SaleDate
2.    The object have elements which can be grouped:
    a.    Arial + Tide + Persil = Detergents
    b.    Colgate + Orbet + Aqua Fresh = ... Dental stuff something like this.
3.    I need a report which will not generate a in vertical direction like:

Date	Arial	Tide	Colgate	Orbit	Aqua Fresh
12.11.2008	10	15	44	77	88
13.11.2008	54	12	47	154	47
…

I need it to be generated in landscape format something like this:

Date	12.11.2008	13.11.2008	…
Arial	10	54
Tide	15	12
Persil	44	47
Detergent Totals	69	113
Colgate	77	154
Orbit	88	47
Aqua Fresh	12	9
Dental Stuff Totals	177	210

PLS!!! advice me, where and what to set in Design to be able to prepare this kind of report.
THX in advance!!



Edited by sairus_md - 12 Aug 2009 at 8:57am