Duplicate records in Crystal Report integrated into VS.NET 2003
We are developing a ASP.NET application that has a bunch of Crystal Reports in it. Having created the template for our reports in Crystal report XI IDE and intergrating the same into Visual Studio .NET 2003, we have run into a strange problem. We still couldn't fix the problem ourselves. The problem is like this...
Having intregrated a report called Sample into VS.NET 2003 which resulted in Sample.cs class for the report. We haven't made any changes to IDE generated code. We then created a .aspx page to display the report in a WebForm at runtime. This .aspx has an instance CrystalReportViewer whose ReportSource was an instance of the Sample. This sample was bound was to a DataSet which has only rows in it. Unfortunately, the report comes up with 4 records.
The SQL Query which resulted in the dataset has been thoroughly checked and it always resulted in just 2 rows. The query does contain a JOIN between two tables and when the JOIN is removed, the report renders only two rows.
The JOIN was meant to get the name from a reference table. We somehow couldn't go to the root cause of this strange behaviour exposed by Crystal Report XI with .NET.
Is there something really wrong with the rendering aspect of the report or is there wrong with the Quert? All the queries associated with all the reports do have some sort of joins with one or more than one table... How come the Sql Query is bothering the Report? We just couldn't find any solution.
Could there some kind of a relation between the report and the backend? Hope... no.
It's been quite frustrating and all our reports have come to a halt just bcoz of this snag. Hope some body who has faced this kind of a problem before could guide us and help us in resolving this issue asap.
The query is as follows...
NET_POSITIONS_PROCESS.EXCHANGE_CODE = SCRIP_MASTER.EXCHANGE_CODE
NET_POSITIONS_PROCESS.SCRIP_CODE = SCRIP_MASTER.SCRIP_CODE
NET_POSITIONS_PROCESS.exchange_code = 1
stlmnt_no = '2006003' and stlmnt_type_code = 'N'
Thanks in advance...
Shashi Kumar Nagulakonda
By Mike in forum VB Classic
Last Post: 01-27-2007, 07:28 AM
Last Post: 12-22-2005, 06:09 PM
By AM003295 in forum VB Classic
Last Post: 08-12-2005, 10:13 PM
Last Post: 06-14-2002, 04:49 PM
By Liz Romero in forum ASP.NET
Last Post: 06-08-2002, 12:30 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL