I have a SQL express database with a fairly straightforward query. There are two check box parameters and I am using sp_DBRCheckBox example with INNER JOIN to filter the records shown in the report. Everything works fine, apparently, except that the report never completes.
If I use the exact same stored procedure in SQL Server Express, giving it exactly the same parameters, it executes in 15 seconds and returns 26,670 rows, for example. But in myDBR the report never stops. I would expect it to take longer, but I've left it running for over 20 minutes.
Any idea what I can look at to resolve this?
Thanks - Phil