I have a cross tab report that shows employee name and then a field,(Sum of UPCHKD.EEXTEND) with four values for each data record. I need to evaluate, looking for a value <0 for one of the possible four entries. So, for example:
I can't figure out how I can achieve this result? Does anyone have any ideas/solutions?
The cross tab is setup as the following:
Thanks for providing the pics of the crosstab Design and the expected results. Please have a look at the attached sample report...first change the .txt extension to .rpt. You can reproduce this for your report with these steps:
There are some special functions that are used to access values in cross-tabs. When you insert an "Embedded Summary" in the total and then edit the embedded summary, you'll have access to the "Grid Value" functions. These will allow you to access values based on the current row (in your case) or column of the cross-tab.
The Help has reasonable explanations of how to use these functions.