Passing Parameters using CRYSTAL REPORTS

[Smish]

hey all,

I am passing parameters through code to a stored procedure in both windows application (using c# and sql server & crystal reports)and web application(usi ng asp.net & sql server & crystal reports)...
the windows application works perfectly..
bt web apllication gives exception..."In valid Table Number"...

Can nebdy help...Please.. ....

[radcaesar]

Send the code and exception u got in detail

:)

[Smish]

thanx sir.....
i am giving u the code as well as exception...... ..



this same appliction runs perfectly in windows...appli cation

when i do this like this i get logon exception failed. in web application..

in page_load am writing this code........... .......

{
CrystalReport1 rptReportClass = new CrystalReport1( );
rptReportClass. SetDatabaseLogo n("sa","");
CrystalReportVi ewer1.ReportSou rce = rptReportClass;


//am taking value from another web page....

if(Request.Quer yString["Name"]!=null )
text1 = Request.QuerySt ring["Name"];

discreteVal.Val ue = text1;
paramField.Para meterFieldName = "vDepartmen t";
paramField.Curr entValues.Add(d iscreteVal);
rptReportClass. DataDefinition. ParameterFields["@vDepartme nt"].ApplyCurrentVa lues(paramField .CurrentValues) ;
paramFields.Add (paramField);
CrystalReportVi ewer1.Parameter FieldInfo = paramFields;

}


so i get exception...

(

Logon failed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: CrystalDecision s.CrystalReport s.Engine.LogOnE xception: Logon failed.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


)

so i added this snip of code in the above instead of rptReportClass. SetDatabaseLogo n("sa","");



(

CrystalDecision s.Shared.Connec tionInfo conn=new ConnectionInfo( );
CrystalDecision s.CrystalReport s.Engine.Table myTable;
CrystalDecision s.Shared.TableL ogOnInfo myLog;
conn.ServerName ="VENUS";
conn.DatabaseNa me="master";
conn.UserID ="sa";
conn.Password=" ";
for(int i=0;i<rptReport Class.Database. Tables.Count;i+ +)
{

myTable=rptRepo rtClass.Databas e.Tables[i];
myLog = myTable.LogOnIn fo;
myLog.Connectio nInfo= conn;
myTable.ApplyLo gOnInfo(myLog);
myTable.Locatio n= myLog.TableName ;
}




)



bt then i get this error...

Error in File C:\WINDOWS\TEMP \temp_3a9b8810-741f-4b4f-92a7-ae4cd51a5fe0.rp t: Invalid table number.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: CrystalDecision s.CrystalReport s.Engine.Invali dArgumentExcept ion: Error in File C:\WINDOWS\TEMP \temp_3a9b8810-741f-4b4f-92a7-ae4cd51a5fe0.rp t: Invalid table number.


hope ill get solution for this........... ..

[kenobewan]

Here is an article that may help, C# e.g. half way down:
How to pass Database logon info to a Crystal Report at runtime in VB.NET

[prabodh bansal]

Dear sir,
I want to pass two parameters for date from and date to to the crystal report so that the output is according to it.
Can u plz guide me in this.
[email removed]

Thanks and Regards
Prabodh Bansal

[markchimes]

Hi Smish,

The error indicates that you have authenication problems with the web version of your database. Are you sure you have the same credentials set for your windows and web databases?
The 2nd error indicates that a parameter type does not match what Crystal is expecting to match against the database data type. In other words, check that the code in your web version that passes the parameter has set the same data type as the field in the data table residing in your web database.

Now, if you are using the SAME database for both Windows and Web apps you have a different set of problems. If this is the case, then obviously the problem does not reside with different authentication models or data types. The difference must be in your code. Check that the web code matches your windows code (in terms of functionality, obviously syntax will vary).

Good luck.

Cheers,
Mark Chimes

thanx sir.....
i am giving u the code as well as exception...... ..



this same appliction runs perfectly in windows...appli cation

when i do this like this i get logon exception failed. in web application..

in page_load am writing this code........... .......

{
CrystalReport1 rptReportClass = new CrystalReport1( );
rptReportClass. SetDatabaseLogo n("sa","");
CrystalReportVi ewer1.ReportSou rce = rptReportClass;


//am taking value from another web page....

if(Request.Quer yString["Name"]!=null )
text1 = Request.QuerySt ring["Name"];

discreteVal.Val ue = text1;
paramField.Para meterFieldName = "vDepartmen t";
paramField.Curr entValues.Add(d iscreteVal);
rptReportClass. DataDefinition. ParameterFields["@vDepartme nt"].ApplyCurrentVa lues(paramField .CurrentValues) ;
paramFields.Add (paramField);
CrystalReportVi ewer1.Parameter FieldInfo = paramFields;

}


so i get exception...

(

Logon failed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: CrystalDecision s.CrystalReport s.Engine.LogOnE xception: Logon failed.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


)

so i added this snip of code in the above instead of rptReportClass. SetDatabaseLogo n("sa","");



(

CrystalDecision s.Shared.Connec tionInfo conn=new ConnectionInfo( );
CrystalDecision s.CrystalReport s.Engine.Table myTable;
CrystalDecision s.Shared.TableL ogOnInfo myLog;
conn.ServerName ="VENUS";
conn.DatabaseNa me="master";
conn.UserID ="sa";
conn.Password=" ";
for(int i=0;i<rptReport Class.Database. Tables.Count;i+ +)
{

myTable=rptRepo rtClass.Databas e.Tables[i];
myLog = myTable.LogOnIn fo;
myLog.Connectio nInfo= conn;
myTable.ApplyLo gOnInfo(myLog);
myTable.Locatio n= myLog.TableName ;
}




)



bt then i get this error...

Error in File C:\WINDOWS\TEMP \temp_3a9b8810-741f-4b4f-92a7-ae4cd51a5fe0.rp t: Invalid table number.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: CrystalDecision s.CrystalReport s.Engine.Invali dArgumentExcept ion: Error in File C:\WINDOWS\TEMP \temp_3a9b8810-741f-4b4f-92a7-ae4cd51a5fe0.rp t: Invalid table number.


hope ill get solution for this........... ..

[Smish]

hi,
Thanx ..itz solved..

Hi Smish,

The error indicates that you have authenication problems with the web version of your database. Are you sure you have the same credentials set for your windows and web databases?
The 2nd error indicates that a parameter type does not match what Crystal is expecting to match against the database data type. In other words, check that the code in your web version that passes the parameter has set the same data type as the field in the data table residing in your web database.

Now, if you are using the SAME database for both Windows and Web apps you have a different set of problems. If this is the case, then obviously the problem does not reside with different authentication models or data types. The difference must be in your code. Check that the web code matches your windows code (in terms of functionality, obviously syntax will vary).

Good luck.

Cheers,
Mark Chimes