How do I sort on a field that doesn't appear in the report?

You can only sort on fields that are included in the report. If you want to sort on a field that doesn't appear in the report, add the field to the report and in the Field Properties dialog, turn off the Display in report setting. This tells Stonefield Query to not display that field in the report but to still retrieve it from the database. You can then sort on this field in the sort step of the report wizard.

How can I show a count of each group in a summary report?

Turn on the Include count in group footer setting for the grouped field in step 3.

How do I use more than 10 values in a "is one of" filter?

You can chain "is one of" conditions by specifying 10 values for the first one, then adding another condition using "or" as the connection, specifying the same field, choosing "is one of" for the operator, and entering another 10 values.

When I preview a report, I see the top half of a line of text at the bottom of one page and the bottom half on the top of the next page.

This is caused by word wrapping lines with certain printer drivers. To resolve this issue, in step 2 of the Quick Report Wizard, click Field Properties and on the Format page, turn off Word wrap for all fields but those that contain multiple lines of text.

I'm using the Pervasive database engine and when I filter on a certain character field, I'm not getting all the records I expect.

This can happen when character fields are padded with binary zeros instead of spaces. See for a solution to this issue. Note that on a 64-bit system, the correct Registry key may be HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI*DSNname*.

How can I turn off pagination in a report? I want a report that's just one long page.

In step 5 of the report wizard, turn off Use template paper type, set the paper type to Custom, and enter a large value for Height, such as 100000.

The layout of my report doesn't look quite right: some things aren't in the correct location.

By default, Stonefield Query uses absolute positioning to render a report in the Preview window. While that normally works well, under some conditions, you may wish to use HTML tables instead. In that case, turn off the Use table layout setting in step 5 of the report wizard.

© Stonefield Software Inc., 2018 • Updated: 03/14/16
Comment or report problem with topic