UI Filtered reporting

rbuser

Although all my reports are designed within the DADE environment, I still
need to report against filtered or query based datasets generated by my main
application (.e.g.the users selects various controls which filters all
invoices against (say) a customer and date range, and a grid is
appropriately populated). In the past when I was using Crystal Reports and
paradox tables (I'm now using FlashFiler2), I simply batchmoved this
filtered dataset to a holding table which is used for reporting purposes. In
fact really all I needed to do was batch the key field to the holding table
and link this to the actual (for example) invoice table to make it work.

The problem with this strategy is i) it can result in alot of these "holding
tables"; ii) each holding table needs exclusive access when the records ares
batched so there can be problems in a multi-user environment; iii) it can be
a bit slow on large filtered datasets. So I was considering building a
stringlist from the key field and then assigning this list to a reports
autosearch critierion with an "in list" clause. Would this work? Would it be
slow if there were a good few records? Are there other strategies for this
scenario that people are using? Comments very much appreciated.


Paul

nardmoseley

Probably depends on how fast the FF2 SQL engine can process a Where
InList search clause.

You'll probably need to perform some benchmark testing. You would not
need to code the entire solution to do the testing. Just create some FF2
SQL queries and try various search conditions to test the performance.