Is there a way to generate a report and export to PDF with catalog variables as rows?

[Andrew Meza]

Hello Community,

I have a report I am trying to export which consist about 22 catalog variables. In the list report I can import all the variables at columns. The problem when I export the data its extremely squished and not really recognizable. Is there a way to get the variables into the rows? It would make reading the report much easier.

how it looks at the moment:

[AnirudhKumar]

Try running your report on the the below tables:

- sc_item_option_mtom

- sc_item_option

[Andrew Meza]

This helps tremendously using the sc_item_option. Thank you! Do you know if there is a way to get the RITM for where these questions were asked from?

[AnirudhKumar]

The RITM details are present on the other table - sc_item_option_mtom

You can't get from sc_item_option to sc_item_option_mtom by dot walking. But you reverse is possible.

Have you tried running the report on sc_item_option_mtom instead?

There is also one other way... using a database view, where you combine the data from both tables. But personally I feel it's a lot easier to run your report on sc_item_option_mtom