how to supress duplicates

Oct 28 2010 8:49 AM

Hi,
 
In my report in header part i am showing account number and account description and in details section showing the stock information for that account.
when i run the report for a single account, the procedure connected to Crystal report runs at backend.
my requirement in report is when there is no data for that account it should display account and description in header part and in detail part it should display 'No data' message in report.
the select statement at backedn i used is:
SELECT distinct NULL PROCESSING_GROUP,NULL MANAGER,NULL ACCOUNTANT,NULL CLIENT, LOCAL_ACC_NO,null CORR_ACC_NO, CORR_NAME,null STOCK_CODE,null PRIMARY_CODE,'No Data' SECURITY_DESC,null INVESTONE_SHARES,null THEIR_SIDE_SHARES,null SHARE_DIFFERENCE, NULL VALUE_DATE,null AGE,null NO_OS_ITEMS, NULL INVMGR FROM a;
even though the procedure is throwing single record, in cr it is showing in 12 or 17 pages repeatedly.
even in a single page it is displaying the message multiple times so i supressed page wise but i am not able to supress report wise.
i also tried to run the query removing the message since SECURITY_DESC is a column in table consisting of different values they are not getting overwritten by the message.
 
Please suggest.
 
Thanks in advance
sruthi 
 
 

Answers (1)