Thursday, December 14

Print State Functions / Remaining

Google+ Pinterest LinkedIn Tumblr +

Some databases support null data values and others do not. This function will not work If the active database does not support null values.

If the database supports nult values, you can use this function to find the null values that get created as the result of a failed lookup while Joining.

Finally, the IsNullQ function can now be passed to the server in the SQL state­ment as part .of the record selection formula.

the last record of the report. I sometimes use the following Boolean formula to conditionally format a Group Footer section:

OnLastRecord – false

For example, if I formatted the groups to start a new page after each Group Footer, the Report Footer gets stranded on the last page of the report, possi­bly with summary or grand total information. To have the Report Footer print after the last Group Footer, I insert the formula above as a conditional formula for the New Page After option. Now the report ignores the New page After direction when it encounters the last record of the report.

, The PreviousQ function allows you to check for repeated values, as in the following example:

If Previous ((Order. Order Amount) – Order. Order Amount) then

•Check for Repeated Value” •


This formula flags repeated values in the {Order.Ordcr Amount) field.with the words Check for Repeated Value.

There arc countless other ways to use these Print State functions, so search those Help files for ideas. The more you knew what is available, the easier , your report designing will be.


About Author

Leave A Reply