BMC - How do I get calculated fields output in a single row

Hi Bharath,

I'm assuming the table data is something like this:

in which case I would use the Yellowfin feature called Freehand SQL Report with the following code:

SELECT
    SysName, 
    MAX(CASE WHEN Role = 'Business Solution Owner' THEN FullName END) AS BSO,
    MAX(CASE WHEN Role = 'IT Solution Owner' THEN FullName END) AS ISO
FROM
    SystemName
GROUP BY
    SysName
ORDER BY
    SysName ;

which would then yield the following report:

I hope you like my solution!

regards,

David

Hi Dave,

Thanks for trying that, but our free hand sql does not allow select, from clause :(

-Bharath

Hi Bharath,

thanks for the screen capture, I can see that you are talking about Freehand SQL Calculated Field, whereas I am talking about Freehand SQL Report:

regards,

David

Hi Dave,

Sorry we are 7.3, don't have the free hand sql feature :( .

-Bharath

Hi Bharath,

I have checked an instance of a 7.3 BMC build and it definitely has the Freehand SQL Report feature.

I have attached a short video to demonstrate this to you.

regards,

David

Hi Bharath,

just wondering how you got along with this matter?

regards,

David

Hi Bharath,

just wondering how you got along with this matter?

regards,

David

Hi Bharath, hope things are going well over there.

Just wanted to let you know I'll be closing this request due to inactivity.

However, if you ever wanted to re-visit this or have anything else I can help you with, please let me know.

Regards,

David