How I can generate a Horizontal Crystal report

Question

Hi everyone, I’m have a problem/question regarding how I can generate a Horizontal Crystal report in next format:

1. I have a object “sale” which have next elements/parameters: a. Ariel; b. Tide; c. Persil; d. Colgate; e. Orbit; f. Aqua Fresh; … 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. Accordantly to Crystal I will get a report which will be generate a in vertical direction like: www.constructor.md/FL/tmp/Table1.JPG

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

Also I tried the Cross-Table, I was not able to get what I need.

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

Answer 1

Have a look at Cross Tab reports. Don't accept this as an answer. (this is trivial)