Can I run Stonefield Query reports from my application?

Yes; see the Using Stonefield Query from Other Applications and Using Stonefield Query from Other Web Applications topic.

One of my user's reports is running very slowly. How can I determine where the problem is?

AppLog.txt in the Logs subdirectory of the SQWeb folder contains information about the report run, including what happened at each stage in the process and how long it took. If this information doesn't help you track down the problem, contact Stonefield Technical Support; we can likely help you track it down.

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 http://support.pervasive.com/t5/PSQL-Knowledge-Base/Disabling-ANSI-Padding-for-ODBC-applications/ta-p/11423 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*.