After reading a bit on MySQL commands, I thought I'd try to get this aesthetic thorn out of my side.  Rather than bury this in an old post:

Extending the Dell KACE K1000 System Management Appliance's Computer Inventory to Support User Profile Specific & Other Non-Inventoried Data

http://www.itninja.com/question/extending-the-computer-inventory-to-support-user-profile-specific-other-non-inventoried-data

I put it here so it would hopefully be more visible.  For anyone who is reporting on Custom Fields populated by ShellCommandTextReturn, you can use this workaround to clean up your report output.  Unfortunately, there is apparently still a bug in the (new) Reports engine which isn't processing the MySQL line break character (tried both \n and \r\n), however if you have access to the Classic Reports module, that processes everything correctly (albeit without the automatic column sizing - have to tweak the HTML if you want it a little more pleasing to the eye; I covered this in another one of my posts, if you want to know how to do that).

Anyways, I started with the SQL code from a Custom Fields report generated by the Report Wizard.  If you look at the output, you will see that the line breaks are not being processed correctly (show up as <br/>).

_____________________________________________________________________________________

1) Original generated by Report Wizard:

SELECT MACHINE.NAME AS SYSTEM_NAME,IP, (SELECT MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE FROM MACHINE_CUSTOM_INVENTORY WHERE MACHINE_CUSTOM_INVENTORY.ID=MACHINE.ID AND MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID=6914) AS MACHINE_CUSTOM_INVENTORY_0_6914 FROM MACHINE     ORDER BY SYSTEM_NAME

_____________________________________________________________________________________

Output:

3 JSMITH 192.168.1.50 4/10/2012 8:03:52 AM - Logged in user: jsmith<br/>------------------------------------------------------<br/>C: Local Hard Drive<br/>D: CD/DVD Drive<br/><br/>

_____________________________________________________________________________________ _____________________________________________________________________________________

2) I added REPLACE statement to swap <br/> for line breaks (\r\n).  The line break characters are not processed correctly by (new) Reports engine (BUG?).  However, all instances of <br/> removed (so it is cleaner).

SELECT MACHINE.NAME AS 'Machine', REPLACE((SELECT MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE FROM MACHINE_CUSTOM_INVENTORY WHERE MACHINE_CUSTOM_INVENTORY.ID=MACHINE.ID AND MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID=6914), '<br/>', '\r\n') AS 'Local And Network Drives' FROM MACHINE     ORDER BY Machine

_____________________________________________________________________________________

Output:

JSMITH 4/10/2012 8:03:52 AM - Logged in user: jsmith ------------------------------------------------------ C: Local Hard Drive D: CD/DVD Drive

_____________________________________________________________________________________ _____________________________________________________________________________________

3) Same SQL Select statement (w/REPLACE statement) run from Classic Reports engine.  Everything is processed correctly, so there must be a bug in the (new) Reports engine. Example output below run without "Break on Columns" for cleaner example

_____________________________________________________________________________________

Output:

3             JSMITH                                                     4/10/2012 8:03:52 AM - Logged in user:  jsmith

                                                                                 ------------------------------------------------------

                                                                                  C: Local Hard Drive 

 _____________________________________________________________________________________

I should note that I had to manually re-insert the line breaks in the last example, as the line breaks were removed when I pasted the text into the Blog text editor.  I added a screenshot so you can see the true output (sans true username). 

Hope that helps somebody!

John