Problems with Grouping/Sorting
Hi all,
I am currently working on a report that requires grouping as well as sorting of the dynamic data.
The data source includes the following columns:
- EventName (string)
- Date (Date)
- ItemNo (int)
- Name (string)
My objective is to group the items by "EventName", while sorting according to "Date" (otherwise I would only get an alphabetical, not chronological order). The final result is expected to be a report including a table with all the data (see example attached). The table lines are created by selecting the border lines in the properties of the individual text object including the data.
Thus, I included the following items in the report:
- Group Header (Group Condition is "EventName"; Sort: "Do not sort")
- DataBand (DataSource selected, Sort according to "Date", then by "EventName", then by "ItemNo")
However, I experienced the following problem:
Although I grouped my data by EventName, this had no effect on the DataBand. When Sorting according to date - although I expected them to by sorted only within the previously created groups - the group order got lost and the items were mixed up again.Therefore, I had to include the EventName into the SortOrder.
In order to achieve the desired layout, I set the "duplicates"-property in the TextObjects to "merge" as I wanted to only show the EventName once, as well as the Date only once within one event. However, as the grouping has no effect on the data, two events on the same date (that should be two different groups, therefore showing the date for each event once) were also merged.
My question is: is there any possibility to include some sort of "hierarchy" in my data source, therefore setting the "merge"-property only within the previously created data groups?
I hope the attached examples help to understand my issue.
Your support is highly appreciated, thank you very much in advance!
regards
Manuel
Attachments:
DataSource:
I am currently working on a report that requires grouping as well as sorting of the dynamic data.
The data source includes the following columns:
- EventName (string)
- Date (Date)
- ItemNo (int)
- Name (string)
My objective is to group the items by "EventName", while sorting according to "Date" (otherwise I would only get an alphabetical, not chronological order). The final result is expected to be a report including a table with all the data (see example attached). The table lines are created by selecting the border lines in the properties of the individual text object including the data.
Thus, I included the following items in the report:
- Group Header (Group Condition is "EventName"; Sort: "Do not sort")
- DataBand (DataSource selected, Sort according to "Date", then by "EventName", then by "ItemNo")
However, I experienced the following problem:
Although I grouped my data by EventName, this had no effect on the DataBand. When Sorting according to date - although I expected them to by sorted only within the previously created groups - the group order got lost and the items were mixed up again.Therefore, I had to include the EventName into the SortOrder.
In order to achieve the desired layout, I set the "duplicates"-property in the TextObjects to "merge" as I wanted to only show the EventName once, as well as the Date only once within one event. However, as the grouping has no effect on the data, two events on the same date (that should be two different groups, therefore showing the date for each event once) were also merged.
My question is: is there any possibility to include some sort of "hierarchy" in my data source, therefore setting the "merge"-property only within the previously created data groups?
I hope the attached examples help to understand my issue.
Your support is highly appreciated, thank you very much in advance!
regards
Manuel
Attachments:
DataSource:
Comments
Thanks for your reply - I created a ticket as suggested, however, I was hoping that someone in this forum could provide me with a solution...
regards
Manuel