Last post Aug 25, 2011 02:50 AM by suresh_g_v2002
Aug 24, 2011 09:41 PM|aisyaziz|LINK
It gives me this error:-
- An error has occurred during report processing.
*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?
Aug 24, 2011 09:45 PM|suresh_g_v2002|LINK
I guess the stored procedure you are using is not executed on the interner server database,
Aug 24, 2011 11:09 PM|aisyaziz|LINK
we don't use the stored procedure. does the built-in stored procedure affect this?
Aug 25, 2011 02:50 AM|suresh_g_v2002|LINK
use sql profiler and track the query..to check whether it is executed correctly on the db server.., I mean any syntaxt errors when passed from reportviewer/datasource to server