.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Others >> Post New QuestionBookmark and Share Subscribe to Forum

Crystal Report Display Problem

Posted By: BABOO     Posted Date: December 07, 2009    Points:2   Category :Others
Sir,

I created two tables named internalhuskers,externalhuskers.
In first table i am having column names
Date(DataType -varchar(10)),
IName(DataType - varchar(20)),
INutsDHusked(DataType - numeric).
In second table I am having column names
Date(DataType -varchar(10)),
EName(DataType - varchar(20)),
ENutsDHusked(DataType - numeric).
I linked two tables and displayed in crystal report.

My problem is I am getting output as follows.

Date IName INutsDHusked Date EName ENutsDhusked

1/12/2009 Rajesh 8000 1/12/2009 Ganesh 2000

1/12/2009 Raju 1000 1/12/2009 Ganesh 2000

1/12/2009 Rajesh 8000 1/12/2009 Ravi 9000

1/12/2009 Raju 1000 1/12/2009 Ravi 9000

I want to display Rajesh and 8000 only once. I also want to display Date 1/12/2009 only once.
Similarly I want to display Ganesh and 2000 only once. I also want to display Date 1/12/2009 only once.I want to display Raju and 1000 only once.I also want to display 1/12/2009 only once.I want to display Ravi only once and 9000 only once.I also want to display 1/12/2009 only once.

Please Send Steps for displaying crystal report in above format quickly.
Its urgent.
Thanks In Advance

Responses
Author: Prasanti Prusty             
Posted Date: December 17, 2009     Points: 5   

Hi BABOO,

Its not Clear, What's the out put You want.
Just give the Example how you want to display.

And at the time of joining just check for which type of "Join" you are using.

Thank u.

Regards,
Prasanti


Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend