hello,
      I am Akhil. We are using windows 2000 and VS.Net 2003 as the development environment for the crystal reports. When our reports are deployed on windows 2003 server machine they are not working.
They are working fine at the development environment.

We are using crystal reports in two ways
1) First type of reports are binded with .XSD schema defination xml files and at runtime we send dataset to this reports.

2) The reports are binded with stored procedures in the database and at runtime we change logon info of the reports to the one currently used database at runtime.

When reports are deployed on win 2000 machine they are displayed
But when reports are deployed on win 2003 machine the reports of type 2 fail at the time of applying logon info.

Can any body point out the probabale cause of error

Thanks in advance
Akhil

I am adding the code of function that is failing

private void ApplyLogOn(ref ReportDocument oRptDoc)
{
try
{
crDatabase = oRptDoc.Database;
crTables = crDatabase.Tables;

foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
crTable.ApplyLogOnInfo(crTableLogOnInfo);
crTable.Location = crConnectionInfo.DatabaseName+".dbo."+crTable.Loca tion.Substring(crTable.Location.LastIndexOf(".") + 1);
}

CrystalDecisions.Shared.ParameterDiscreteValue discreteVal = new ParameterDiscreteValue();
CrystalDecisions.Shared.ParameterRangeValue rangeVal = new ParameterRangeValue();

ParameterValues curvalues =new ParameterValues() ;
foreach (ParameterFieldDefinition parafld in oRptDoc.DataDefinition.ParameterFields)
{
if(parafld.DiscreteOrRangeKind.ToString()=="Discre teValue")
{
discreteVal.Value = Request.Params[parafld.ParameterFieldName];
curvalues.Add(discreteVal);
parafld.ApplyCurrentValues (curvalues);
}
else
{
string strtemp = Request.Params[parafld.ParameterFieldName];
rangeVal.StartValue=strtemp.Substring(strtemp.Inde xOf("~")+1);
rangeVal.EndValue = strtemp.Substring(strtemp.IndexOf("~")+1,strtemp.L ength-strtemp.IndexOf("~")-1);
curvalues.Add(rangeVal);
parafld.ApplyCurrentValues (curvalues);
}
}
}
catch(Exception ex)
{
throw new MusicMedalException(881);
}
}

Hi Akhil,

in ur msg u didn't mentioned about the version of crystal report. lower version of crystal report won;t work in windows 2003 server.



Srihari Narayanan,
Software Engineer,
NonVerba Information Solutions Pvt. Ltd.

Thanks Srihari,

We are creating reports form VS.NET development environment.
More over as i mentioned earlier the reports that were binded to XSD s and populated at runtime using Dataset are working fine.

But problem is with reports of type 2
When we try to change logon info the exception is raised.

I really wonder if some crystal decisions API's work diffrently in Win 2003/ IIS 6 machine.

Reports are working fine in win 2000 machine.

Thanks Again
Akhil Vira.