Thank you so much..it worked. 🙂

thank you,

that worked for the data I posted, I guess I still have some bad data, as I still get the same error any tips on how to locate...

thanks all

Thank you all. That was the case,

Now I am struggling with bad data , would appreciate your help. I want to convert following data in datetime hhmmss format Here...

Thanks all for your replies !!

Yes, I think its missing one extra field, i will try this thanks

SQL_Nw (4/26/2012)

---

Hi i have 2 temp tables in my procedure #item and #sequence. I am trying to update column itemsequence in first table

from second table using update.. set...

thanks !!

thanks for your reply. I corrected the proc to show the data but now when run for a full year, report throws an error

"Object xxxxxxxxx has been disconnected or...

Perfect !! thank you.

Thanks for the link. however I am not into .Net much. Is there anything I can do on my own. something at report level formatting/sp level ?

High light by clicking your dataregion (table) > then right click properties > new window will open up called as Table Properties > click on sorting tab

then enter your...

Sure, you are welcome.

Simon,

you should allow multiple string concatenation using ',' in all your datasets.

for instance if you are using

select item_id, item_desc from Items

instead of that

USE ---

-----------------------

Declare @ParamItem varchar(1000),

...

simon.letts (12/1/2011)

---

I want to write an RS report for our business just to let them pick a sales figure for all or specific region(s) of their choice ie in RS...