Need Help with a Custom Expression in Report Builder
I need help with creating a custom expression to get the first table to look like the second table. Any suggestions will be appreciated
|
One answer
David Honey (1.8k●1●7)
| answered Nov 30 '22, 8:17 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER I think this is working as designed. The actual results are 3 rows each with 3 populated columns.
Comments I understand it is working as design, however, arent there ways you can do a custom expression within Report Builder? I've Concat multiple rows, to print out as i wanted with a comma separating the attributes before doing an custom expression IE the example above,
I had it print (156 | Red, Blue, Green | Charlie)
however, this is concatenating an attribute with the same ID, into one so like a merge....I'm sure there is some sparql code that will allow me to do this....and thats what I am asking for....
Help with a custom expression to have report builder print out as i need it. Any Ideas?
Also, doing it post process will not allow me to use Report Builder to do my PUB template with the correct information...as the template uses the dta from Report Builder hence why i need it done in Report Builder, not Post Report Builder
You need to watch out for group concat is how to deal with cross-products. In your example:
Expressing this as:
is incorrect because that is effectively saying there are pairs {Red,Charlie}, {Green,Charlie}, and {Blue, Charlie} but that's not the case. If you also did a group contact on the 3rd column and got:
that too would be incorrect because it is effectively saying you got the cross product {Red,Charlie}, {Red,Alpha}, {Red,Delta}, {Green,Charlie}, {Green,Alpha}, {Green,Delta}, {Blue,Charlie}, {Blue,Alpha}, {Blue,Delta}.
In order to express the data correctly, you need to group concat the concat of column 2 and column 3. Something like: 156 | Red:Charlie, Green:Alpha, Blue:DeltaThat would be a correct compact representation of the data. True, I was just giving you a vague example on what I have done before not specific to just this example if that makes sense. Just implied I concatenated other values separated with a comma...but I have not been able to merge a cell together that has the same value as 156 does to just have one number not the 3 156's.
So I'm looking for help to get the ID attribute that has the same ID merged into one cell, and all the other information stays the same. If this is possible with a custom expression.
I need to customize the report in Report Builder so that when I use the .DTA for Pub I get the correct Template in order to create my Document from Report Builder.
Are you familiar with PUB/RPE?
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
What's the meaning of <o:p>?
What does that first column represent?
Why is the first column sometimes showing the <o:p> after the 156 and other times after it?
You'll need to give details of what this data represents.
Those are empty spaces this forum added after copying the chart from MS office...