Got a couple of questions: Am new to this so please bear with
me
Scenario 1: I have a one to many relationship from Table1 to Table2. Table2 may or may not have a record for a row in Table1.
- Using a report builder, I am only able to display those records which exists in table2. Is is possible to display all rows from table1 which may or many not have subsequent rows in table 2 (something like a left join)?

Scenario 2:
- I have a table where some of the fields are restricted to a only a
few. How do I create similar functionality in the report model as well?