Hello all! I'm new to Cognos and reporting so I appreciate as much detail as possible. I have a simple 3 table SQL database with primary and foreign keys defined correctly:
order table= (order_id), firm_id, client_id, date_sent, order_variance
client table= (client_id), client_name
firm...