Report Builder / temporary tables

rbuser

Hi there,

I'd like to setup a common model for my reports using DADE for MySQL.

I'd like the user to select what he wants to print. So my first idea was
to build a temporary table where he can select.(This way many users can
select different records to print at the same time).
This solution doesnt seem to work since ReportBuilder can't "see" the
temporary table.

So now my idea is to build a table with a unique name that would be
called from Report Builder data section.

exemple : I build my report with a real table called 'selected'.
Then at run time, I change selected to 'select192_168_1_102' for
instance. This table will have the same structure, of course.

so I have 3 questions :
1- Is there a way to force Report Builder to work with temporary tables
(I doubt this is possible)
2- If not, is my solution a correct one to do that ?
3- and if so, how can I change the report builder "table" names
dynamically ?

very best regards,

Etienne

digitalmetaphors

Please do not crosspost. Handled in the DADE newsgroup.


Cheers,

Jim Bennett
Digital Metaphors