First of all, thanks for the quick reply.

But....

The results is a list of results from the table "incident.verzoek as Omschrijving"

So I've got multiple results I like to alter.

Incident_NrDatum_Aanmelden Omschrijving

I010101...

Path for Reporting Services 2008:

\Program Files\Microsoft Visual Studio 9\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

THANKS!

Live can be nice if things work out.

I've learned some new things today that I will write down, so I can reuse it in the future.

(and more importend, I understand...

I understand the part of FULL OUTER JOIN, but I'm not sure what to do with "IsNull(ALIAS1.Aantal_Incidenten, 0) as Aantal_Incidenten" (newbie...)

Ok..... I didn't understood the first reply from Adi.

I've tested and now I've got a good result, but.....

Can it be, that if the second subquery has no results, that there...

In my first post I've posted my code:

select

(

select vestiging.naam, count(*) as Aantal_Incidenten

...

Still having this problem. Can someone help me?

I hope this is what you mean:

In table "incident" there is a field "aanmeldervestigingid" that links to table "vestiging" with field "unid" (It translate a code to a customer name)

In...

Lowell, thanks for you support.

The query runs, but I get the next result/issue:

customer1 5customer11

customer2 3customer11

customer3 7customer11

customer4 2customer11

customer5 8customer11

customer6 11customer26

customer7 2customer26

customer8 6customer26

customer9 3customer26

In...

Yes, I'm using ReportServer and I'm using the parameters to make selections, so I need them.

I'll try the method of Jeff, to fill my parameter.

If it doesn't work, I'll come...