Page 1 of 2
Crosstab - string as Summary field
Posted: Wed Oct 16, 2019 8:55 pm
by kubalak
Hello,
I am asked to have a numeric as well as string field as a summary column. I have prepare the data in SQL in such a way that there is only 1 row per row per column.
In the picture there should be only 1 row per date and the strings should be concatenated and comma delimited.
Thanks for any hints on how to do this.
Re: Crosstab - string as Summary field
Posted: Thu Oct 17, 2019 9:50 am
by Lech Kulikowski
Hello,
Please try to use the Cross-Data component instead of the Cross-Table in that case.
Thank you.
Re: Crosstab - string as Summary field
Posted: Thu Oct 17, 2019 10:32 am
by kubalak
Interesting!! Thanks!! Hopefully I will find some time today to try it out.
Re: Crosstab - string as Summary field
Posted: Thu Oct 17, 2019 12:28 pm
by Lech Kulikowski
Hello
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.
Re: Crosstab - string as Summary field
Posted: Fri Oct 18, 2019 6:20 pm
by kubalak
Wow!! I did it. But I wouldn't be able to without your sample
Got lost a few times along the way.
Anyway, the only minor glitch which I managed to overcome by making the cells a bit bigger and wrapping the content is that I haven't found the way how to synchronize the width of the header cell with the width of the multiple data cells.
But still: Thanks!!
Re: Crosstab - string as Summary field
Posted: Fri Oct 18, 2019 6:38 pm
by kubalak
I have noticed 1 error though:
When I set the format of the sum value to be numeric, the number of digits is not saved into mrt file:
Code: Select all
"TextFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalSeparator": ",",
"GroupSeparator": " ",
"State": "DecimalDigits"
},
but if I edit the mrt file and add it there manually:
Code: Select all
"TextFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalSeparator": ",",
"DecimalDigits": 2,
"GroupSeparator": " ",
"State": "DecimalDigits"
},
the viewer does not have a problem to view it properly. This I found both in the cross-table as well as cross-components.
Re: Crosstab - string as Summary field
Posted: Mon Oct 21, 2019 1:18 pm
by Lech Kulikowski
Hello,
Please try to check the last release build, that issue was fixed.
Thank you.
Re: Crosstab - string as Summary field
Posted: Tue Oct 29, 2019 5:57 pm
by kubalak
I am sad to report that the last build seems to make things even worse. This time it does not register the number of decimal digits even in the data band. Like in the report design attached. I set up number + 2 decimal digits on all the fields in the data band and when I save it, the number of decimal digits is not in the mrt file.
Re: Crosstab - string as Summary field
Posted: Thu Oct 31, 2019 8:25 pm
by Lech Kulikowski
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Re: Crosstab - string as Summary field
Posted: Thu Nov 21, 2019 12:02 pm
by kubalak
My apologies, I have been swamped with other work.
Could you please just try to open the attached report and save it? Without the data? When I save it, nowhere in the report, I find "DecimalDigits": 2 in StiNumberFormatService.
When I change format general on the cell to number without specifying number of digits, I see this in mrt:
Code: Select all
"TextFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 3,
"GroupSeparator": ","
}
But when I toggle on the number of decimal digits and save it, mrt stays the same.
But when I change the number of decimal digits to 2 and save it, mrt changes into this:
Code: Select all
"TextFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"GroupSeparator": ",",
"State": "DecimalDigits"
}
Would this be sufficient for you? To prepare anything else at the moment is beyond my time availability.
Thank you very much in advanced. I work in chrome on os x.