It gives me this error:- - An error has occurred during report processing. - COGS *COGS is the datasourcename from what i've debugged, i realized that this error only occur to datasource with a "with" sql statement. other data sources work fine. when i change the sql statement to just a select sql statement, it works fine. i've executed the "with" sql statement in the local and the internet server and it shows the right output, too. i've copied the web.config exactly like the one in my local server, so, the web.config might not be the problem. anyone has any idea how to troubleshoot this?
This can be pretty strange. Some of the things I'd check are that the remote server has the report file in the same folder as it was, tree wise, on the local dev machine. I've seen this one happen. The other thing to try is the Properties for the actual report file. One property that changes the way internal actions work is "Build Action.". I know it's a pain to test but you can try Embedded and Content. Sorry if I confused you any, these are the only things I can think of.
...Sorry about that, it does not apply to all versions, slight "brain fart" on my part. ;-) Can you give a brief detail of how you are doing this? i.e. Just a ReportViewer in VS and the SQL was done with the DataSource. I'll do my best to help with this, just need a better handle on it.
