Crystal Reporting
-
Hi am new to SQL Server and i need to make a reporting i have this thable e.g Name RecieptNo Charles 0001 Charles 0002 Charles 0003 Harry 0004 Harry 0005 The report need to look like this Name RecieptNo _____________________ Charles 0001 0002 0003 ____________________ Harry 0004 0005 can any one help with the query for this one?
-
Hi am new to SQL Server and i need to make a reporting i have this thable e.g Name RecieptNo Charles 0001 Charles 0002 Charles 0003 Harry 0004 Harry 0005 The report need to look like this Name RecieptNo _____________________ Charles 0001 0002 0003 ____________________ Harry 0004 0005 can any one help with the query for this one?
So do the formatting of the data in the report. DO NOT try and make the database do the UIs job. The query into the database should get you all the data required in the report, it is then up to you to format the report the way you need it to look, this has nothing to do with the query.
Never underestimate the power of human stupidity RAH
-
Hi am new to SQL Server and i need to make a reporting i have this thable e.g Name RecieptNo Charles 0001 Charles 0002 Charles 0003 Harry 0004 Harry 0005 The report need to look like this Name RecieptNo _____________________ Charles 0001 0002 0003 ____________________ Harry 0004 0005 can any one help with the query for this one?
Use the Suppress if duplicated[^] option
thatraja
FREE Code Conversion VB6 ASP VB.NET C# ASP.NET C++ JAVA PHP DELPHI ColdFusion
HTML Marquee & its alternativesNobody remains a virgin, Life screws everyone :sigh: