Question:
Hi CHC.
I found this old question put for you and I would like to know if you find the solution.
Thanks.
Extdaa
-------------------------------------------------------------------
The key date of a query, is it for the whole query at once, or could we use it record per record ?
I would like to create a report containing a navigational attribute that is time dependent ;
and I would like to show the status of the attribute based on a date retrieved from the current record.
Example
infoobject...color.....from............to
A...............white....01.01.2000...31.12.2000
A...............yellow..01.01.2001...31.12.2001
"cube"
infoobject....creation date of the record....KYF
A..................02.01.2000.........................5
A.................02.01.2001..........................8
I would like to create a report concerning the color, depending on the creation date
color......KYF
white........5
yellow......8
I am pretty sure this is possible, but I am not sure that I attack the problem from the correct side ?
Ch
Answer:
Must be an old one as I even don't remember where was the last place where I developed non-basic queries.
Sorry, but I think I never found a solution, as I currently don't have a clue on how I should handle such a requirement.
Ch
Answer:
Does How To...work around the ‘Single Key Date’ limitation address this?
/forums/viewtopic.php?t=51577
Answer:
Thanks Robert. I had already seen this "How to..." document before, but I was wondering if there was any other solution, without having to code an enhancement for it.