This is great Ray.. thanks for all your help...

Well i was hoping that i wouldnt need a SP and i can just do the formatting in the RDL... the customer wants to see something pretty and not 7200...

great to hear you got that working... this is something i shall save in my bookcase...

save yourself the hassel and just use VS 2003 ... until your company is ready to upgrade the report server to 2005, just keep doing what you were doing before......

I dont think you can do that... you must specify a specific data source when you create the report... im not sure.. has anyone else accomplished this...

VS 2003 is the only choice to edit the report ... i would stick with that...

this is what stands out to me

Data source 'AMTRK': Abort handler called. CanAbort = True.

w3wp!processing!950!4/30/2007-14:02:50:: i INFO: Abort callback successful.

w3wp!processing!950!4/30/2007-14:02:50:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report...

Can you provide the ErrorLog Under the ReportingServices folder in Program Files...

I had a similar situation one time but here is what i did... i had a report A ... and i wanted it to go to report B which was...

YES... you get an error from the ReportServer itself stating it is the wrong version number...

I think what he is asking for is to be rendered out in Excel instead of HTML.... and i think this might be accomplished by tweaking the ReportViewer.aspx page... i...

Ive gone with UNION ALL in the past ... and it works.. I'd go with a Union All

Mann I am running into this same problem... does anyone have a solution... my last hope is to call MS... please help... thanks

I have a reporting web farm and i reset IIS on all the boxes and i still get this error...

Im using in the SQL side a datediff in hours ...