This is exactly my problem and my sql. The report has cascading parameters and it works well for a single value. I tried to make it work for multi- select...

I think a comma delimited list would be fine.

Thanks for your information but what should I do on this case?

The error is this "the Select list for the insert statement contains more items than the insert list. The number of select values must match the number of INSERT columns....

Yes, I still have issue with error.

Actually my value has the closing parameter. I must have have missed it when I copied the sql to paste on this forum

I was refering to expressions and not sql. Anyway I later found out the correct one to use.

For other people who might have the same problem, the correct expresion...

Thanks Erland Sommarskog

I will check the code again with your suggestions in the office tomorrow.

EO

Hi,

I have tried the SELECT distinct but it didnt work. As Erland Sommarskog said in the first reply that it has to do with the Joins so I am...

Hi ,

This is the code that I have. I really want to know which one is inserting the duplicate that violates the primary key constraints.

Thanks

DECLARE @History Table

(

Jobnumber INT...

Thanks for your response. I just read about this before you posted it. I will try it in office tomorrow

Could you help me put that into the URL expression. The target that needs to open in a new tab is the Product ID

You guys got it. I was looking at Functions in the report model and it didnt specify to use Join in the lookupSet

Hi,

I do not think your problem is the same as mine. As a matter of fact, I do not think mine is possible with a lookup. I have to find...

Wow. I used earlier =Format(Fields!DateField.Value, "ddmmyyyy") but it was'nt working but when I changed the mm to MM like you stipulated, it worked like a magic. I never knew that...