Being new with SQL and SSRS and can do many things already, but I think I must be missing some basics and therefore bang my head on the wall all the time.

A **report** that is almost working, **needs to have more results** in it, based on conditions.

My working query so far is like this:

```
SELECT projects.project_number, project_phases.project_phase_id, project_phases.project_phase_number, project_phases.project_phase_header, project_phase_expensegroups.projectphase_expense_total, invoicerows.invoicerow_total
FROM   projects INNER JOIN 
                project_phases ON projects.project_id = project_phases.project_id
                LEFT OUTER JOIN
                project_phase_expensegroups ON project_phases.project_phase_id = project_phase_expensegroups.project_phase_id
                LEFT OUTER JOIN 
                invoicerows ON project_phases.project_phase_id = invoicerows.project_phase_id
WHERE  ( projects.project_number = @iProjectNumber )
       AND
       ( project_phase_expensegroups.projectphase_expense_total >0 )

```

The parameter is for `selectionlist` that is used to choose a project to the report.

**How to have also records that have**
`( project_phase_expensegroups.projectphase_expense_total )` with value `0` but there might be invoices for that project phase?

Tried already to add another condition like this:

```
WHERE        ( projects.project_number = @iProjectNumber )
             AND
             ( project_phase_expensegroups.projectphase_expense_total > 0 )
             OR
             ( invoicerows.invoicerow_total > 0 )

```

but while it gives **some** results - also the one with `projectphase_expense_total` with value `0`, but the report is total mess.

So my question is: what am I doing wrong here?