Hi All,
I'm trying to re-create a report from C8 to Reportnet, and am hitting a wall. I'm currently working on a report that shows summarized worked hours by time code for employees, like the following:
Employee ID, Name, Time Code, Hours
In order for me to get the current year, I need to prompt on the workdate, which i've added to the query, however have excluded from the Report output.
The problem I run into is, when I run the report I get multiple lines for each timecode for each workdate, which i've excluded from the output, instead of a summary. Is there something that i'm missing in Reportnet?
Thanks in advance.
Try excluding it from the query, and using the fully qualified data item from the model in the filter, instead of the query item.
That solution seemed to have worked! thanks, you made my day!!