# Urgent - Ignition Reports need help with subcatogery

**URL:** <https://forum.inductiveautomation.com/t/urgent-ignition-reports-need-help-with-subcatogery/100746>\
**Category:** Ignition\
**Tags:** reporting, perspective\
**Created:** [January 10, 2025, 7:24pm UTC](https://forum.inductiveautomation.com/t/urgent-ignition-reports-need-help-with-subcatogery/100746 "2025-01-10T19:24:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sravanthi\_Avasarala](https://avatars.discourse-cdn.com/v4/letter/s/4491bb/32.png) [@Sravanthi\_Avasarala](https://forum.inductiveautomation.com/u/Sravanthi_Avasarala)\
**Post date:** [January 10, 2025, 7:24pm UTC](https://forum.inductiveautomation.com/t/urgent-ignition-reports-need-help-with-subcatogery/100746/1 "2025-01-10T19:24:34Z")

</div>

I am returning the below table from SQL and this is how it should look like

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/f/3ffafcae923194ac81fcbc95488cce3c9433dd21.png)  
However when I tried doing this using Ignition perspective my table looks like below. I am not sure how to leave the space and make it as subsection. I also need help in making the parent section as bold font and its children as normal font.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/c/7cdefc3a0858f74167abd540854bc17a8eeb5e48.png)

Any help would be greatly appreciated!

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [January 10, 2025, 8:46pm UTC](https://forum.inductiveautomation.com/t/urgent-ignition-reports-need-help-with-subcatogery/100746/2 "2025-01-10T20:46:28Z")

</div>

1. You've titled your post as Reports but tagged it as Perspective. The Reporting module and Perspective module are not related. Which is it? (Edit to fix.)
2. Please show your SQL query so we know what the returned data format will be. (What determines whether a row is indented or not?) Please see [Wiki - how to post code on this forum](https://forum.inductiveautomation.com/t/wiki-how-to-post-code-on-this-forum/77831).
3. You have the option to use subview in a table row. See [Displaying a Subview in a Table Row | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/appendix/components/perspective-components/perspective-display-palette/perspective-table/displaying-a-subview-in-a-table-row).
4. "Urgent" in your question title isn't really appropriate (and the nature of the question doesn't appear at all urgent as the table is readable). Most of the contributors on this site are volunteers and will answer questions of interest when they have time.

---

<div class="post-metadata">

**Author:** ![Ujwal\_Wankhede](https://avatars.discourse-cdn.com/v4/letter/u/4af34b/32.png) [@Ujwal\_Wankhede](https://forum.inductiveautomation.com/u/Ujwal_Wankhede)\
**Post date:** [January 11, 2025, 4:00am UTC](https://forum.inductiveautomation.com/t/urgent-ignition-reports-need-help-with-subcatogery/100746/3 "2025-01-11T04:00:59Z")

</div>

The simplest trick would be to use the Dynamic Key for Font. Merge the label with ALT + 255 to insert tab for subsection labels.  
Report ss

 ![TableDynamic](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/4/642cae03e2c82cf7449cd7e72196f2bfba1c6513.png)  
 ![TableDynamicFont](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/a/aa8fd6866a8b027bd167586f81dbfec576e46a22.jpeg)  
Sample Report  
[tableReport.zip](https://forum.inductiveautomation.com/uploads/short-url/yqEEa8oMqeksKqNj765HcsTLs6t.zip) (12.1 KB)