Notes SQL not pulling results from all fields

Hello,

I am trying to create a Crystal report for our passthru usage reports, from the log.nsf. I can see the default view just fine and all is well through the notes client, so I decided to use notes sql to pull the data I need into crystal.

However when I do this all I get is the header information, using the table “Passthru_Connection”

Pulling from other tables ie “UsageByUser” returns data into the report.

Does anybody have any ideas as to why I cannot get the data to return on this one table?

Thanks in advance.