Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
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
Reply With Quote
  #2 (permalink)  
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);
}
}

Reply With Quote
  #3 (permalink)  
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.
Reply With Quote
  #4 (permalink)  
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.

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 02:16 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.