i am new to ssrs and looking for guidance : i need to develop a report based on multiple tables: general ledger, customer ledger and customer master...
the purpose of report is to have customer segment wise sales and expense information.... for given month and YTD.
customer segments are defined in customer master, sales is in customer ledger and expenses are in general ledger..
the problem i am facing are:
1. I need to display all customer segments, and if no sales /expenese for any segment, then show 0 values.. .however, if i join tables and apply WHERE clause for date..i am missing some segments due to lack of data within where condition
2. i believe having subqueries is expensive when u r dealing with millon records.
further i want to know how to have a calculated field based on two different dataset fields.
View Complete Post