Xcopy_
December 16th, 2008, 02:14 PM
I will try to explain this as best as I can.
I need a hint here as to a report I need to create.
Here's an example of what I'm building.
Say we have an emp. schedule.
you have emp names as rows and days of weeks as columns.
Where I fall short is here... What object could I use to program a formula to examine the emp name per day of week to display a particular shift symbol.
I've tried using a cross-tab and it doesn't really come close to what I need.
I've had to result in making a static table (draw manual lines) and try to interact my emp with the days of the week.
sql would be as followed... select symbol from aView where empname=PARAM and dayOfWeek=Param etc... PARAMS being the fields I examine in the XY axises.
Has anyone ever come across this in CR.
I'm starting to think it may not be possible
Thank in advance guys.
I need a hint here as to a report I need to create.
Here's an example of what I'm building.
Say we have an emp. schedule.
you have emp names as rows and days of weeks as columns.
Where I fall short is here... What object could I use to program a formula to examine the emp name per day of week to display a particular shift symbol.
I've tried using a cross-tab and it doesn't really come close to what I need.
I've had to result in making a static table (draw manual lines) and try to interact my emp with the days of the week.
sql would be as followed... select symbol from aView where empname=PARAM and dayOfWeek=Param etc... PARAMS being the fields I examine in the XY axises.
Has anyone ever come across this in CR.
I'm starting to think it may not be possible
Thank in advance guys.