horizonal table

[surajap123]

Hi All,

I have to create a report(may be in a straight table). But the format of the report should be like below, ie. Dimensions & expressions should be one below the other and and little space and again another set in same fashion.

Product  -          Pen
Product ID -       1
Brand -              abc
Sales Amount - 100

Product -           Pencil
Product ID -       2
Brand -              efj
Sales Amount - 150

Product -          Rubber
Product ID -     3
Brand -             xyz
Sales Amount - 40

Please suggest me, how to achieve this.

[tyagishaila]

Check it, and let me know is it possible in your data?

[tyagishaila]

and for blank row

you can concatenate 1 more table like below

Concatenate(TAB1)

Load

' ' as f1,

' ' as f2,

RecNo() as f3

Resident TAB;

[surajap123]

Sorry I didn't get it.

[surajap123]

Hi Frank,

Thanks for all your effort. The text object doesn't react to user selections, But I found your solution interesting.

[tyagishaila]

have you seen sample.qvw?

[tyagishaila]

is this your requirement or not?

f3	f1	f2
1	Product	Pen
1	ProductID	1
1	Brand	abc
1	SalesAmount	100
1
2	Product	Pencil
2	ProductID	2
2	Brand	efj
2	SalesAmount	150
2
3	Product	Rubber
3	ProductID	3
3	Brand	xyz
3	SalesAmount	50
3

[surajap123]

Yes.

Can you do it with my data. Probably you can add more rows if you want.

I am more interested in the layout, so you can try using any data as long as the layout appear as my initial post.

[surajap123]

Yes, without the top headers.

[tyagishaila]

you can remove Headers by clicking on

Suppress Header Row in Presentation Tab.

[Frank_Hartmann]

another solution might be in attached sample but i really don't know how to involve the blank rows

after each block!