Search results

Ok Im in formatting hell here. 1. When I drag in sub reports (or reports to be used as subreports) The first one usually drags in fine. The second one will sometimes float behind the second one. And the third one will usually either drag in correctly, or float behind one of the other two. 2...

I want to count based on 1 (same) field from each of two tables, based on if ID is in "X". select a.groupid, count(a.id), count(b.id) from ta a, tb b where value in ('a','b','c') group by a.groupid Thats sort of the psuedocode but Im not getting the right results. Any help would be appreciated.

So I have a query which prompts the user for a username to search by, GetUsername. Im used to TSQL usage which would be something like: exec GetUsername 'blah' My goal is to generate about 10 reports based on this query but with different (hardcoded) input. I do not want to prompt the user...

I have not found an easy way to do this yet. Assuming I have my TOP 10 and ORDER BY parts correct, how can I absolutely restrict my results to exactly 10? Thanks