Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Still Struggling & Need Assistance
Message
General information
Forum:
ASP.NET
Category:
Reporting
Title:
Still Struggling & Need Assistance
Miscellaneous
Thread ID:
01504280
Message ID:
01504280
Views:
199
I am really stuck here. This app runs fine on my PC, bhut when I try to generate the report on the client's server, I'm getting
---------------------------
Application Error
---------------------------
Application has generated an exception that could not be handled.

Process ID=0x16d8 (5848), Thread ID=0x1170 (4464).

Click OK to terminate the application.
Click CANCEL to debug the application.
---------------------------
OK   Cancel   
---------------------------
Here's the code:
private void _RunReport()
{
    try
    {

        // The selected project Id
        int ProjectId = (int)cboProjects.SelectedValue;

        // Create the project object
        csCOSApp.ActiveProject = new csCOSProject();
        csCOSApp.ActiveProject.ProjectId = ProjectId;
        csCOSApp.ActiveProject.LoadData();



        // Get the report's data using info from the active project
        List<DbParameter> Params2 = new List<DbParameter>();
        Params2.Add(new SqlParameter { ParameterName = "@ProjectId", Value = ProjectId });
        Params2.Add(new SqlParameter { ParameterName = "@PrimaryWhseId", Value = csCOSApp.ActiveProject.PrimaryWhseId });
        Params2.Add(new SqlParameter { ParameterName = "@SecondaryWhseId", Value = csCOSApp.ActiveProject.SecondaryWhseId });

        DataSet dsProjectInfo = csCOSApp.DataLayer.ExecuteQuery("ap_GetProjectReportData", Params2, CommandType.StoredProcedure);


        // Create an instance of the Crystal .RPT file
        rptCorporateViewReport reportObj = new rptCorporateViewReport();


        // Set the report's data source to the DataTable
        reportObj.SetDataSource(dsProjectInfo.Tables[0]);       // <=====   APP DIES HERE

        // Assign the report to the viewer
        crlReportViewer.ReportObject = reportObj;
    }
    catch (Exception e)
    {
        logMessage(e.ToString());
        throw e;
    }
}
While I have made some slow progress in getting to this point, I need to deliver this report right now. Anyone see anything here?

Thanks
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform