Reports in Database and Filters

rbuser

Before I go searching too deep I thought someone might have an answer to
this simple question.

I store my reports in a database.

Can I specify a filter on an additional field just for accessing reports.
For example, a Boolean field named "IsReport" and use the
filter='IsReport=TRUE'

Since I have to distribute the report database with my application I'd like
to be able to throw some other, non-report BLOBS in there as needed.

Thanks,

-Johnnie

digitalmetaphors

What is the relationship between the report templates and the non report
BLOBs? Regardless, I would put them in separate tables. One table would
have reports and one table would have non-report BLOBs. You never know, down
the road, you might want to add more columns to the tables and link these
two tables together using a lookup query. In that case, it would be helpful
to have two tables.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Thank you.

-Johnnie