Hi Deepti

I was having the same problem but it happened when i select default default database in coonection property box but when i select my database name it works fine....

Thanks Andrew

We are also using internal e-mail. Could you provide activeX code for this task.

Regards

Is there any other way to do this thing

Regards

Thanks for reply. At present i am working like but i need to store all promotion code in a table so that product manager can see this later also by selecting...

Hi Prasad

Yah that is what i am trying to do..........

It is possible to do with VB form. Actually reporting services is totally new for me so not sure how to...

Thanks a lot...

I checked so many times properties everytime missed that check box.

Thanks once again

Hi Mike

Thanks for reply but could explain bit more i am a new user so not able to understand.

Regards

Thanks a Lot Stuart

It was a only one click because i have not selected the option store procedure but your post helped me to sort the problem , it's working...

Hi Sergiy

Thanks a lot it's working now. Yah you are right my ID field is not actually Unique. After reading your post i checked my ID field and find out...

Thanks a lot For reply

Table data which i posted is only a sample data i have arround 40,000 lines for this set of customers.

Total for debit note for customer code 'DA55' with...

Here is the sample data :-