Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Removing Non Duplicate Values from the Report

Status
Not open for further replies.

kv444

Programmer
Nov 20, 2011
23
US
Hi All,

I am trying to develop a report in webi where i would like to see only duplicate records in the report and would like to drop the records that are unique from the report.

For Example i have a column in the report:

Item:
Laptop
Phone
Phone
Phone
watch
pen

Here i want to see the column with Item values that are only in "Phone" category and drop the laptop,watch and pen records from the report.


Could you please help me figure out how i can achieve this..


Thank you very much for your help in advance !!!
 
The way that I have done it,(not necessarily the best way) is do grouping, hide the details, put a in a counter (running total?), put the information I want to see in the group footer (GF). Hide the GF if the counter > 1.
 
Could you please explain it a little bit in detail...i am trying to show only the duplicate dimensions in the report...will i be able to use running total here..
 
I want to see

phone
phone
phone



Thanks!!!
 
I would use a command table

Code:
SELECT
    y.item
    FROM @YourTable y
        INNER JOIN (SELECT
                        item, COUNT(*) AS CountOf
                        FROM @YourTable
                        GROUP BY item
                        HAVING COUNT(*)>1
                    ) dt ON y.item=dt.item

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 
Is there a way i could do it directly at the report level
 
yes
group on item

create a group selection formula (not record selection formula)

Code:
count(item,item) > 1

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 
No Luck with this...for some reason i am not able to group the dimension column in webi 4.1...
 
I would use a Suppression formula in the Detail section.

Something like:
{table.field} <> previous({table.field}) and {table.field} <> next({table.field})
 
kv, you are asking a WEBI question in a Crystal Reports forum? The methods we would use don't apply to WEBI.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top