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

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: 2017-09-13

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?

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: 2017-09-14

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

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: 2017-09-17

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

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

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.