I am working on report that displays some info from time card tables...
There is table, lets call it Shop_timecards that is linked to Employee table, (on employee ID) and then it displays some data.
Now there is another table called Engineering_time cards that is basically a mirrored Shop_timecards (all columns are the same) for different group (engineers), also linked to Employee_ID table.
I know this can be resolved by creating two subreports one for Shop and another for Engineering... but since table have same structure is there more elegant way to select which table use in one (main) report?
All ideas and tips are appreciated.
IP Logged
