Thanks, vcapone

Thank you, Dave. Maybe I’ll use your solution in other report.

Thank you, Chris. Your solution made sense for me.

:satisfied:

Sorry, I try to explain better. Forgive my English.

I have developed a report with CrystalReports, based directly on tables, and I solved the problem. But now I have to do...

I have to do a report which has to have parameter year(@deparr)

Then the procedure has to be something like that

CREATE PROCEDURE usp_GetT

year(@deparr) smallint

AS

....

And how/when to write @Type?

Thank you very much

The records are:

JNr Type

24 Cust

24 A

24 A

25 A

25 A

25 A

25 A

26 Cust

27 A

27 A

so will be

JNr Type

25 A

25 A

25 A

25 A

27 A

27 A

I am at home and I can't...

so definitely saying WHERE Type = 'Cust' means the query retrives records when WHERE Type <> 'Cust'?

Sorry

More I'm interested what retrieves the first LEFT OUTER in the table not_these;

LEFT OUTER

JOIN ( SELECT Substring(Cost,4,7) AS JNr

FROM Ch

WHERE Type = 'Cust' ) AS not_these

ON not_these.JNr =...