It might be easier for Jeff, or anyone else to give you a more detailed answer if you would illustrate what one or two of your reports look like. Depending on the data you want, a JOIN, a LEFT JOIN, or even a CROSS APPLY of a subquery might be appropriate ways to tie data together from multiple tables.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills