Last post Jun 11, 2018 01:04 AM by Deepak Panchal
Jun 09, 2018 03:07 AM|Gentry38|LINK
I need help figuring out how to use an existing data (or unique id) and use this on a new table or matrix. For instance, using Table 1. I want to use the ID field as the way of searching and populating the Table 2 (like where id in ('181552','252533', etc..
but w/o manually entering each ID). I've tried joining these tables but getting duplicates. I've also tried the lookup function and used a temp table and I'm still getting dupes.
Jun 11, 2018 01:04 AM|Deepak Panchal|LINK
I try to create a dummy tables like yours.
SELECT Table_5.id, Table_5.amount_paid, Table_5.deposit_date
LEFT JOIN Table_4 ON Table_5.id = Table_4.id
Output in SSRS Report Viewer.