Hello,

I have a table in my DB with 3 fields : code, level, label. "Code" is varchar, "level" varies from 1 to 10 (integer).

I want to insert a group header for "code" (in order to do the sorting) but only for those lines where level = 1. The lines with level > 1 will be in the details lines.

In the group header, i will have the code and the label. Now comes the problem: if i put the group header simply by "code", with no condition, the label will be wrong (will belong to some other line... with label > 1).

So i want to put some condition on the group header to take into consideration the lines with level = 1 ONLY.

For example if i have the lines :

abc, 1, label level1
abc, 2, label level2
abc, 3, label level3

i want to show:

GH : abc label level1
D:                label level2
D:                label level3

and what it shows now is something like:

GH : abc label level3
D:                label level1
D:                label level2

Thanks in advance for any answers.


Edited by APS_LSWE - 11 Feb 2008 at 12:48am

Unfortunately a condition such as this:

GroupName ({GRP.level_col})='OTHERS' AND {GRP.label}="Label level 2"

won't work, because the label can be anything, the code can be anything, the level can be anything... you cannot hardcode the values in your conditions!

Also this: "then in Named Group enter the name GH :abc " sounds like a bit of hardcoding to me. "abc" is a dynamic value in a database.

And thirdly, i made a little mistake in my presentation: level is varchar (with the same value range : 1 to 10).

PS: "GH" stands for "Group header", "D" stands for "Details", i did not actually want to put these into text boxes :)


Edited by APS_LSWE - 14 Feb 2008 at 5:51am