I have this query result:
Code: Select all
TITLE CODE
--------------------------------
ABCDE-AA-XXX-PD-001 A
ABCDE-AA-XXX-PD-001 B
ABCDE-AA-XXX-PD-001 C
ABCDE-AA-XXX-PD-001 D
GBSRH-AF-DXY-PD-001 1
GBSRH-AF-DXY-PD-001 2
GBSRH-AF-DXY-PD-001 3
GBSRH-AF-DXY-PD-001 4
GBSRH-AF-DXY-PD-001 5
GBSRH-AF-DXY-PD-001 6
Code: Select all
TITLE REVISIONS
-----------------------------------------------------------
ABCDE-AA-XXX-PD-001 A B C D
GBSRH-AF-DXY-PD-001 1 2 3 4 5 6
So, I concluded that this can be done in Stimulsoft without using PIVOT since this one that I want to achieve is a Stimulsoft report.
Thanks much!