Removing Non Duplicate Values from the Report

[kv444]

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 !!!

 

[kray4660]

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.

 

[kv444]

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..

 

[Charliy]

Would you want to see:

Phone

or

Phone
Phone
Phone

 

[kv444]

I want to see

phone
phone
phone



Thanks!!!

 

[CoSpringsGuy]

I would use a command table

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

 

[kv444]

Is there a way i could do it directly at the report level

 

[CoSpringsGuy]

yes
group on item

create a group selection formula (not record selection formula)

count(item,item) > 1

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[kv444]

No Luck with this...for some reason i am not able to group the dimension column in webi 4.1...

 

[Charliy]

I would use a Suppression formula in the Detail section.

Something like:
{table.field} <> previous({table.field}) and {table.field} <> next({table.field})

 

[kenhamady]

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

http://www.kenhamady.com/