Skip to Content
0
Former Member
Mar 12, 2009 at 03:35 PM

Show different key fields for different caracteristics in the column.

22 Views

Hi, experts

I am creating a query where there are 4 colomns reprensenting 4 different dates. But I would like to display diffferent key fields for them. For example, under DAY 1, i would like to diplay KeyField 1, for DAY2, DAY3 and DAY4, KeyField 2 et 3 will be added under them.

To do that, i made these key fields "Constant selection" and made some definition in the cells-------

On the line of DAY1 in the colomn KeyField 2 and KeyField 3, I made them "Always Hide".

But I didn't get what i wanted as the two columns (KF2 et KF3) still appear in the report, even if there are no data in these two columns.

Is it possible to realise this requirement:

DAY1 DAY2 DAY3

KF1 KF2 KF3 KF2 KF3

Thanks in advance!!!!