View Single Post
  #5 (permalink)  
Old March 3rd, 2006, 02:33 AM
jcounihan jcounihan is offline
Registered User
 
Join Date: Mar 2006
Location: Seattle, WA, USA.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The approach I've taken is to let the db do as much work as possible. Generally that means taking an input param from the UI and passing it into the stored procedure when running the report. It's pretty flexible. If many of your queries are similar, it might also reduce the number of them. If performance becomes an issue, there are ways to deal with that.. like report caching or writing to staging tables in the db. If you want more details, let me know. That's just what I'd look at first. I haven't seen that Filters dialog box take anything beyond simple expressions though.

James

MCSD.MCDBA.MCT
Reply With Quote