TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
sruthi ramachandrula
NA
14
42.4k
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
Reply
Answers (
1
)
please modify the code which is in indian currency format
format the number in indian currency format