Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Suppressing duplicate fields in cross tab

Posted on 2017-09-13
12
Low Priority
?
31 Views
Last Modified: 2017-09-18
I am trying to use "Suppress If Duplicated" on the cross tab's non summarized fields, but it is not working.

Attached is the screen shot for reference.
DuplicateValues.jpg
0
Comment
Question by:Sailee Govekar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
12 Comments
 
LVL 4

Expert Comment

by:Raghavendra Hullur
ID: 42292247
Hi,
Can you share the report with saved data (The data shown in screenshot)?
Is there any other field used in crosstab for grouping before the field with data such as "General", "Fresh Water Cooling.." etc.?
0
 

Author Comment

by:Sailee Govekar
ID: 42292303
Hi,

https://drive.google.com/open?id=0By-_z66pGEGrM0xPT3F6WHctc1E

Please refer the above link.

Yes. There is a grouping of "SortOrder"
0
 
LVL 4

Expert Comment

by:Raghavendra Hullur
ID: 42292348
Hi,
The duplication issue is because of the non summary row field "ColumnSortOrder". Can you explain more on usage of ColumnSortOrder?
1
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 101

Expert Comment

by:mlmcc
ID: 42292407
What duplication are you referring to?

I added the fields you are using in the report to the details, and I don't see any duplicate records.
You are getting six records for each component, one for each time slot.

mlmcc
0
 

Author Comment

by:Sailee Govekar
ID: 42293581
The use of "ColumnSortOrder" is for sorting the report as per the 3rd non-summarized row and not by 1st Non-summarized row.
Using "Column sort order", I can sort the cross tab in the required output.
My concern is that if I am using the "ColumnSortOrder" first in the non-summarized rows, then the rest non-summarized field cannot be merged or suppress for duplication? I don't want my cross tab to display its output in alphabetical order, but by the "ColumnSortOrder" field which has the sorting ID for the 3rd Non-summarized field. As I cannot sort the cross tab by the 3rd non-summarized field, so I have considered its ID first. Now in the report the 2nd non-summarized fields are duplicating. How can I merge them? For example, in the report value "General" is repeating multiple time, how can I merge it?
0
 
LVL 4

Expert Comment

by:Raghavendra Hullur
ID: 42293635
Hi,
Please see below points:
1. Since the ColumnSortOrder field values range from 1 to 154, there will be a separate row on 2nd non summarized row whether it's repeating or non repeating as the value for each first non summarized row changes.
2. Regarding merging other non summarized fields, we need to explore more on this using the dynamically changing value for these row fields.
3. If you are sorting by ID of 3rd non summarized field, are you getting the output in the required order?
0
 

Author Comment

by:Sailee Govekar
ID: 42293735
3. If I am using ColumnSortOrder as my first non-summarized field then I am getting the required order output. It includes the repetitive 2nd non-summarized field.
    If I am not taking ColumnSortOrder in Cross tab and using it as "Report->Record Sort Expert->Sort Fields by SortOrder(Default Group) and then by field ColumnSortOrder field then the output is generated alphabetically (which is not required).
0
 
LVL 4

Assisted Solution

by:Raghavendra Hullur
Raghavendra Hullur earned 1000 total points
ID: 42293906
Hi,
I think there is no way to suppress the duplicating values since those are originated based on different values of the first non summary row group.
If you are open for recreating the report as a tabular report using summaries, we can try to work on that.

Or let's see if we get alternate answers from others.
0
 

Author Comment

by:Sailee Govekar
Hi,
I have found some  work around. I have added one more ID so that my data can be displayed the way I wanted.
I have suppressed the ID's which are added in the non-summarized fields.
But some space still exist in the report.
I don't want those empty non-summarized column to be displayed on the report.
Attach is the link of the report on drive:
https://drive.google.com/open?id=0By-_z66pGEGrQTlUemY1REdZNnM

Red Marked columns in the attached image:
Report1.jpg
0
 
LVL 4

Accepted Solution

by:
Raghavendra Hullur earned 1000 total points
Hi,
Check the attached report whether data order is correct as required.
EngineLogBookDetailsReport_PIRemoteV.rpt
0
 

Author Comment

by:Sailee Govekar
Can you explain How did you achieve this?
0
 
LVL 4

Expert Comment

by:Raghavendra Hullur
Hi,
This was something to do with suppression of labels for those non summary fields.
In the Crosstab Expert --> Customize Style, you had suppressed the row sub totals, but label's weren't suppressed.
That's why those 2 fields were appearing in the report output.
1

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question