bevarg wrote:
> Hi,
>
> I've created a report that contains all fields from table1, table2, and
> table 3 in a table format.
>
> what's happening with my report is:
>
> when a customer has info about him/her in table1 but not in table 2 or
> table 3
> the report won't the customer record at all.
> but when a customer has info about him/her in all 3 tables
> the report will show the customer record.
>
> what I would like to do is:
>
> Have the report show whatever customer information is available rather
> than show only if the customer has info in all 3 tables. if some of the
> fields in the report are not able to pull info from the report, it
> should show '0'.
>
> Is it possible to get that done through a query? or is that something
> that I can do through reporting services?