Damn...This is magic. It worked John.

Thanks a lot...

Following query worked for me:

with prod as

(

select distinct ShipmentID From Shipment

where Producttypeid <> 2

)

select DISTINCT ShipmentID From Shipment h

LEFT OUTER join prod p on h.ShipmentID = p.ShipmentID

where...

Thanks for your quick reply Sean.

It is still giving me wrong results. it should give me the shipments which only and only has product type = 2. that means if...

I think the problem has to do with duplicate groups or users. What happened in my case is we had a gradual migration from one domain to the other....

Hey seshu.vnkt

Thanks for the reply.

I think u didn't get my requirement....

Hey Greg,

Thanks for the reply.

I had already tried that query but it didn't worked.

Jeff's solution worked for me.

I appreciate your help in this.

Cool It worked.

Thanks Jeff.

Found the solution:

Installing SSRS 2005 SP3 worked.

Thanks

🙂

thanks for the reply.

The reason I am looking for this conversion because the content in PDF document is kind of...

Yes Matt. you are right. that was the second error. now it worked.

Thanks a lot.

Thanks for the reply Matt.

I chekced my table design and I forgot to set the identity specification for my ImageID column. but now it's throwing an sql server connection error.

Thanks for the reply.

To your point if it executes all the dataset then it should give me the results but to get the result I need to click on ViewReport....

Yes.

You need to assign the Text qualifier as " (double quote) while creating the flat file source connection for CSV file.

It comes into my requirement.

I am calling my WCF service (As a web reference) to generate and return the SSRS report into byte array and doing the further processing.