I have a report that runs the way I need it to run. I have no access to the single data source it feeds from but I can link to it.
The report displays various activities by username group on a group id and a week id.
I have another table called configs that has settings i need to select on per user (one for record for every user in the group id). I need to make some type of select list from this based on the settings.
the configs has a field called email 1 or 0. i need to select all of the group ids that have this in the report.
I cannot link the group id to groupid from configs to the main table, they are not relational and cause the data to double/triple etc.
How can I use the one table to formulate a set of ids then use those as selection criteria in the second report???
best regards.
sql server 2000 and i do have access to the sql commands.
The report displays various activities by username group on a group id and a week id.
I have another table called configs that has settings i need to select on per user (one for record for every user in the group id). I need to make some type of select list from this based on the settings.
the configs has a field called email 1 or 0. i need to select all of the group ids that have this in the report.
I cannot link the group id to groupid from configs to the main table, they are not relational and cause the data to double/triple etc.
How can I use the one table to formulate a set of ids then use those as selection criteria in the second report???
best regards.
sql server 2000 and i do have access to the sql commands.