need to know if i can create a report which can transpose rows into columns using skuid

  • 1
  • Question
  • Updated 3 years ago
  • Answered
Hi,
We have a client who uses Skuid framework. They currently have an object structure where they have opportunities which has a child modal object called capital using skuid. So an opportunity can have multiple capital rows. Currently they have a standard report which displays multiple rows for each opportunity due to the data model. They would need to transpose each row as a column in the report. How can this be done using skuid?
E.g
opp name, capital name, capital type, capital amount
101, c1, ct1, 200
101, c2, ct2, 300 
should be displayed as
101, c1, ct1, 200, c2, ct2, 300 as one row..
 Any thoughts on how this can be done?
Thanks
Buyan
Photo of Buyan Kumar

Buyan Kumar

  • 82 Points 75 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
Not sure if this is the best solution, but you could try a field editor. The field editor will duplicate itself for each row in the model. Then you can set up the field editor with css to stack horizontally instead of vertically.

This may help: https://community.skuidify.com/skuid/topics/possible_to_have_field_editors_to_show_different_records
Photo of Buyan Kumar

Buyan Kumar

  • 82 Points 75 badge 2x thumb
@Matt Sones
 Thanks for your reply. Does Skuid have any reporting component which i can use to embed in an existing report and change the layout of the data or would this need to be a separate salesforce page?
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
You need to create a skuid page.