Hi all
Just started working with Crystal after a gap of six+ years (I wasn't very good in the first place!) and have been handed what I think is a real 'doozey' of a problem.
Hopefully I can articulate it properly, so here goes..
I have a report which shows a student's provisional course choices and the availability of those course choices according to a timetable (split into six blocks)
I've just created a simple crosstab to highlight when the courses are available (or not) - that was straightforward enough - however the next step is actually flagging up in some manner whether because of a limitation in the availability some combination of choices would never fit. Makes sense?
So at it's most basic:
Person X
Choice 1 is available in block 1
Choice 2 is available in block 1
Choice 3 is available in block 1,3
would need to display that choices 1 and 2 will never fit for person X because they take place in the same block - it just needs to be highlighted differently.
to make life more complicated the number of choices is variable (though obviously no more than 6) and the courses can be available across from 1 to all 6 of the blocks.
I can imagine this being a complex loop of some kind but any and all ideas are welcome.
Thanks in advance
Squeaks
Just started working with Crystal after a gap of six+ years (I wasn't very good in the first place!) and have been handed what I think is a real 'doozey' of a problem.
Hopefully I can articulate it properly, so here goes..
I have a report which shows a student's provisional course choices and the availability of those course choices according to a timetable (split into six blocks)
I've just created a simple crosstab to highlight when the courses are available (or not) - that was straightforward enough - however the next step is actually flagging up in some manner whether because of a limitation in the availability some combination of choices would never fit. Makes sense?
So at it's most basic:
Person X
Choice 1 is available in block 1
Choice 2 is available in block 1
Choice 3 is available in block 1,3
would need to display that choices 1 and 2 will never fit for person X because they take place in the same block - it just needs to be highlighted differently.
to make life more complicated the number of choices is variable (though obviously no more than 6) and the courses can be available across from 1 to all 6 of the blocks.
I can imagine this being a complex loop of some kind but any and all ideas are welcome.
Thanks in advance
Squeaks