Crystal Report ask for login when XSD is used as database

[Former Member]

I have generated the XSD of the class file (Value Object) with the help of Dot net XSD tool. This XSD is then bound with the .rpt file.

The problem is that when this is run on other machine and their machine has a different path for the code, the report fails. The odd thing is that some of our reports are working fine, it is only a few that basically are looking for the hard coded XSD path.

As per my knowledge, Crystal report does not require XSD at the runtime. I am totally stuck with this issue. Temporary solution is to set the data source location on the other machine which is rediculous.

I have also tried "Same as Report" option of the report but it look XSD in the "Temp" folder of the "C:\Documents and Settings\username\...".

Is there any dynamic solution ? Can i map the XSD path to my Project application? Any help will be appreciated.

[Former Member · Accepted solution]

Hi,

Let us know the following:

VS version.

CR product used.

First of all lets make sure that you have not saved the report with data. Once you have the xsd used for designing how are you passing the data? If you are using dataset make sure that the dataset have the correct schema.

I believe we are talking about a web based application right? Then give full control (IIS_WPG for IIS6 or aspnet for IIS5) to the temp folder as it is required by the reports.

Helps?

Regards,

AG

[Former Member · Accepted solution]

Thanks AG for replying so quickly.

Here is the details asked.

VS version - VS2005 version 8.0

CR product used. - the one which comes with VS2005

I have not saved report with the data. I had just bind the schema (XSD) with report. I am serializing my class into the dataset. My application is windows based.

Please let me know if you require more info. Waiting for your response

Thanks in Advance.

Thanks

[Former Member · Accepted solution]

Hi,

here is a simple code, it works for me. would you like to try?

OleDbConnection conn = new OleDbConnection("Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=Northwind;Data Source=d-2818-w2k");
OleDbDataAdapter adpt=new OleDbDataAdapter("Select Orders.CustomerID,Orders.EmployeeId,Orders.OrderID,Orders.OrderDate,[order details].productid,[Order Details].UnitPrice,[Order Details].Quantity from [Order Details], Orders Where [Order Details].OrderID = Orders.OrderID",conn);
DataSet ds= new DataSet();
adpt.Fill(ds);
 //ds.WriteXmlSchema("c:\\temp\\myData1.xsd");
 ds.WriteXml("c:\\temp\\myData1.xml",XmlWriteMode.WriteSchema);
ReportDocument rd = new ReportDocument();
rd.Load("c:\\temp\\ADOReport.rpt");
rd.SetDataSource(ds);
CrystalReportViewer1.ReportSource=rd;

There is a very beautiful wiki post by Ludek I am trying to locate it for you........

Thanks,

AG.

[former_member184995 · Accepted solution]

Check to make sure your dataset has data in it prior to passing it to the report.

Also make sure that the dataset matches the schema that you created the report against.

[former_member183750 · Accepted solution]

It's actually a blog :

/people/ludek.uher/blog/2009/03/02/troubleshooting-issues-with-vs-net-datasets-and-crystal-reports

Ludek

[Former Member]

Thanks AG and Ludek .

Creating XSD of the Dataset and then binding it to the report file solve the problem

thanks a lot for your help.

Happy Reporting .....

Taufique Ansari