Header of a table

[Former Member]

Hi everyone,

May be I'm approaching this the wrong way, but I need your help.

I have a report based on a Procedure.

Each column contain the quantities of a different Item, The user define the items by parameters.

The report is working perfectly, except for it's header.

I Want to put the Item number + Item Descr + Item format of each column in the header.

I have the Item Number as parameter Item1.

How to extract the other informations???

               Item1        Item2       Item3

Client       Descr       Descr       Descr

               Format     Format     Format

ABC           5             4                2

DEF            3            2                1

Thanks in advance.

[Former Member]

Just to help somebody else with the answer.

I used subreports in the header to place the description and format of the columns.

Not an elegant way, but it did what I needed.

[kothandaraman_nagarajan]

Hi,

Please post query to check or provide more details.

Thanks & Regards,

Nagarajan

[Former Member]

Hello Nagarajan

The Query is irrelevant, it's giving the right answers.

My problem is in creating the header.

The first line I have it from parameters.

It's getting the 2nd and 3rd line, the description and Format of the item by column.

[kothandaraman_nagarajan]

Hi,

Still not understanding your problem. Are  you working with UDT?

Regards,

Nagarajan

[Former Member]

Yes I'm working with a User Defined View.