Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
| Search | Today's Posts | Mark Forums Read
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 17th, 2005, 03:01 AM
Authorized User
 
Join Date: Dec 2004
Location: mumbai, maharastra, India.
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to akhilvira
Default Crystal reports not working on windows 2003

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
 
Old November 18th, 2005, 01:43 AM
Authorized User
 
Join Date: Dec 2004
Location: mumbai, maharastra, India.
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to akhilvira
Default

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);
}
}

 
Old November 18th, 2005, 06:14 AM
Registered User
 
Join Date: Nov 2005
Location: Chennai, Tamil Nadu, India.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
 
Old November 18th, 2005, 06:27 AM
Authorized User
 
Join Date: Dec 2004
Location: mumbai, maharastra, India.
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to akhilvira
Default

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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Reports 8 /Windows Server 2003/ ActiveX miriv365 Crystal Reports 37 February 25th, 2016 06:41 AM
Crystal Reports Not working in Windows 2003 Server varooon Crystal Reports 0 January 10th, 2008 01:13 AM
Crystal Report 8 and Windows 2003 suan Crystal Reports 0 December 19th, 2005 05:42 PM
Crystal reports .NET 2003 James VB.NET 0 May 17th, 2005 10:20 AM
Crystal reports .NET 2003 James Pro VB.NET 2002/2003 0 May 16th, 2005 01:28 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.