Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 58
  • Last Modified:

Suppressing duplicate fields in cross tab

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
Sailee Govekar
Asked:
Sailee Govekar
  • 6
  • 5
2 Solutions
 
Raghavendra HullurSoftware DeveloperCommented:
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
 
Sailee GovekarStudentAuthor Commented:
Hi,

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

Please refer the above link.

Yes. There is a grouping of "SortOrder"
0
 
Raghavendra HullurSoftware DeveloperCommented:
Hi,
The duplication issue is because of the non summary row field "ColumnSortOrder". Can you explain more on usage of ColumnSortOrder?
1
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
mlmccCommented:
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
 
Sailee GovekarStudentAuthor Commented:
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
 
Raghavendra HullurSoftware DeveloperCommented:
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
 
Sailee GovekarStudentAuthor Commented:
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
 
Raghavendra HullurSoftware DeveloperCommented:
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
 
Sailee GovekarStudentAuthor Commented:
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
 
Raghavendra HullurSoftware DeveloperCommented:
Hi,
Check the attached report whether data order is correct as required.
EngineLogBookDetailsReport_PIRemoteV.rpt
0
 
Sailee GovekarStudentAuthor Commented:
Can you explain How did you achieve this?
0
 
Raghavendra HullurSoftware DeveloperCommented:
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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now