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!!!!