deploy crystal report on asp.net server

parshupooja

Hey All,

I have created asp.net application which includes crystal report page on my local machine, it works fine. but when i try to deploy it to remote server it throws error. I was not even being able to build the solution than i did good I found solutions that we need to include DLL in Bin folder, it included and updated the reference. Now I am able to build solution but when I try to run application it throws error on crystal report page on bold italic line

Error:
The type initializer for 'CrystalDecisions.CrystalReports.Engine.ReportDocu ment' threw an exception.
code

Expand|Select|Wrap|Line Numbers

  
    protected void Page_Load(object sender, EventArgs e)

    {

               // object declration 

        CrystalDecisions.CrystalReports.Engine.Database crDatabase;

        CrystalDecisions.CrystalReports.Engine.Table arTable;

        CrystalDecisions.CrystalReports.Engine.Table brTable;

        CrystalDecisions.CrystalReports.Engine.Table crTable;

        CrystalDecisions.CrystalReports.Engine.Table drTable;
 
        TableLogOnInfo dbConn = new TableLogOnInfo();

        // new report document object 

        ReportDocument oRpt = new ReportDocument();                // loading the ItemReport in report document 

        oRpt.Load(Server.MapPath("------.rpt"));
 
        // getting the database, the table and the LogOnInfo object which holds login onformation 

        crDatabase = oRpt.Database;
 
        // getting the table in an object array of one item 

        object[] arrTables = new object[4];
 
        crDatabase.Tables.CopyTo(arrTables, 0);
 
        // assigning the first item of array to crTable by downcasting the object to Table 

        arTable = (CrystalDecisions.CrystalReports.Engine.Table)arrTables[0];

        brTable = (CrystalDecisions.CrystalReports.Engine.Table)arrTables[1];

        crTable = (CrystalDecisions.CrystalReports.Engine.Table)arrTables[2];

        drTable = (CrystalDecisions.CrystalReports.Engine.Table)arrTables[3];
 
        dbConn = arTable.LogOnInfo;

        dbConn = brTable.LogOnInfo;

        dbConn = crTable.LogOnInfo;

        dbConn = drTable.LogOnInfo;
 
        dbConn.ConnectionInfo.DatabaseName = "--";

        dbConn.ConnectionInfo.ServerName = "--";

        dbConn.ConnectionInfo.UserID = "--";

        dbConn.ConnectionInfo.Password = "---";

      dbConn.ConnectionInfo.IntegratedSecurity= true;
 
        // applying login info to the table object 

        arTable.ApplyLogOnInfo(dbConn);

        brTable.ApplyLogOnInfo(dbConn); 

        crTable.ApplyLogOnInfo(dbConn); 

        drTable.ApplyLogOnInfo(dbConn);

        // defining report source 

        CrystalReportViewer1.ReportSource = oRpt;
 
        setReportParameters(); 
 
  -    }

any help appreciated

DrBunchman

Have you checked if CrystalReports for .NET Framework 2.0 has been installed on the server? If you're lucky it could be as simple as that!

Dr B

parshupooja

thanks but How do i find out that? if its not there on server, is it necessary to install there, cant I deploy without installing there?

Quote:

Originally Posted by DrBunchman

Have you checked if CrystalReports for .NET Framework 2.0 has been installed on the server? If you're lucky it could be as simple as that!

Dr B

DrBunchman

I think if you check Control Panel - Add/Remove Programs it will display which .Net components are installed.

In order to install the Crystal Reports for .Net Framework 2.0 you need to create an installer by following these steps:

Go to create a new project in Visual Studio
Select 'Other Project Types' from the New Project dialog box then select 'Setup and Deployment' and Ok
Right click the project in the solution explorer and go to properties
Click the 'Prerequisites' button
Check both MDAC 2.8 and Crystal Reports for .Net Framework 2.0 then Ok
Compile the project and your installed should be in the release folder. Run the .msi file on the deployment server.

Hope this helps.

Dr B

parshupooja

thanks fro replying again. server where i am working does not have visual studio, they have web devloper and web developer there is no option called as new project. there is new website option in web developer, when i click it does not show other project types.

Can this be done in web devloper as i have no right to install anything there?

thanks

Quote:

Originally Posted by DrBunchman

I think if you check Control Panel - Add/Remove Programs it will display which .Net components are installed.

In order to install the Crystal Reports for .Net Framework 2.0 you need to create an installer by following these steps:

Go to create a new project in Visual Studio
Select 'Other Project Types' from the New Project dialog box then select 'Setup and Deployment' and Ok
Right click the project in the solution explorer and go to properties
Click the 'Prerequisites' button
Check both MDAC 2.8 and Crystal Reports for .Net Framework 2.0 then Ok
Compile the project and your installed should be in the release folder. Run the .msi file on the deployment server.

Hope this helps.

Dr B

DrBunchman

Do you use Visual Studio on your development machine?

parshupooja

i have visual studio 2005 on machine where I developed application, crystal report works fine on it. but on server where I am trying to deploy, has web developer.

Quote:

Originally Posted by DrBunchman

Do you use Visual Studio on your development machine?

DrBunchman

Go through the steps I outlines above on your machine with Visual Studio then copy the deployment file to the server and run it.

Let me know how it goes,

Dr B

parshupooja

ok I tried following steps provided but you did not mention which template to choose from other project -setup and deployment, I tried choosing setup first and make sure of 'Prerequisites' . but when i tried to build the project in it starts windows installer and asks me the location of SqlRun_Tools.msi. I tried to use my sql server disc but it doesnot let me install it.
I tried choosing other types of templates under -setup and deployment but I have same issue

/mergemodule/websetup one by one
any suggestion?
Thanks,

Quote:

Originally Posted by DrBunchman

Go through the steps I outlines above on your machine with Visual Studio then copy the deployment file to the server and run it.

Let me know how it goes,

Dr B

DrBunchman

Hmm not sure about that one...when I did this I didn't come across any problems. Anyone else got a suggestion? I'll do a little research and see what I can come up with.

Sorry I can't be more help at this stage.

Dr B

parshupooja

Thanks for help,

Finally I client has been convinced to install visual studio 2005 on server.I am sure it will resolve the problem

Regards,

Quote:

Originally Posted by DrBunchman

Hmm not sure about that one...when I did this I didn't come across any problems. Anyone else got a suggestion? I'll do a little research and see what I can come up with.

Sorry I can't be more help at this stage.

Dr B

deploy crystal report on asp.net server

re: deploy crystal report on asp.net server

re: deploy crystal report on asp.net server

re: deploy crystal report on asp.net server

re: deploy crystal report on asp.net server

re: deploy crystal report on asp.net server

re: deploy crystal report on asp.net server

re: deploy crystal report on asp.net server

re: deploy crystal report on asp.net server

re: deploy crystal report on asp.net server

re: deploy crystal report on asp.net server

Similar .NET Framework bytes

/bytes/development

/bytes/it

/bytes/about