I am attemtping to pull directly from a lotus notes database using ODBC conenctions as it supports the command function giving stronger SQL capabilities and I have run into two problems.

1) Does ODBC not support the count command? I can my sql statement fine but as soon as I set it to use the count function, it generates an API driver error.

2) Is there a way to link three lotus notes databases together in an SQL statement as I need to count and group for all three databases in the same subreport.