Hidden Values affect report output

[jmills]

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.

[tjohnson3050]

Try excluding it from the query, and using the fully qualified data item from the model in the filter, instead of the query item.

[jmills]

That solution seemed to have worked! thanks, you made my day!!