Solved

C# Crystal Reports - Not displaying Data

Posted on 2014-12-12
3
1,040 Views
Last Modified: 2014-12-20
I am working on a website.  I did not originally develop it.  I am troubleshooting the issue.  The dataset is populating with data.  I checked the XSD on the report, the datatbase verifies.  I added text on the report.  The report prints as excel but no data displays.  Any ideas?

 DataSet myDataSet = new DataSet();

myAdapter.Fill(myDataSet,"eoData");			

oRpt.SetDataSource(myDataSet);
												
crystalReportQueue myCRQ = new crystalReportQueue(appMan.ConnectionString);

myCRQ.storageFormat = CrystalDecisions.Shared.ExportFormatType.Excel;

int iPrintQ = myCRQ.load(oRpt, "EO Report", appMan.UserID);
Response.Redirect("PrintQueueList.aspx");

Open in new window

0
Comment
Question by:CipherIS
  • 2
3 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 40497056
Has this been working or is this something new you added?

If you export the report to Excel do you get data?

mlmcc
0
 
LVL 1

Accepted Solution

by:
CipherIS earned 0 total points
ID: 40500473
I resolved the issue.  But to answer your question.  This app was written in .NET 1.1.  Didn't have the original source code.  Upgraded it and everything was breaking.  

Looking into it, finally noticed that the dataset name was not matching the XSD name.  Once that was changed that resolved the issue.  The data is getting to the report now.

Thank You.
0
 
LVL 1

Author Closing Comment

by:CipherIS
ID: 40510601
The dataset name was not matching the XSD name which prevented the report from populating the data.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question