Currently in the Linebreak options, Columns per Line can only choose between 1, 2, 3, and 4.
However sometimes I have one column that would take up an entire line, while the next line could fit a dozen columns of short title. Could there be an option to linebreak after a certain amount of characters? Something like after 150 characters, no more columns. Fit as many columns into 150 characters as possible and then make a new line.
Ex:
current 4 column format:
MV.ORDR_HDR_KEY AS ORDER_ID, PARSE_DATE('%m/%d/%Y', CAST(MV.CREATED_DATE AS STRING)) AS ORDER_CREATE_DATE, PARSE_DATE('%m/%d/%Y', CAST(MV.SUBMITTED_DATE AS STRING)) AS ORDER_SUBMIT_DATE, UPPER(MV.CURRENT_STATUS) AS ORDER_STATUS, AC.ACCT_ID AS ACCT_NO, J.JOB_NO, SI.SITE_NO, SI.ZIP_CODE,
what I'd prefer to see:
MV.ORDR_HDR_KEY AS ORDER_ID, PARSE_DATE('%m/%d/%Y', CAST(MV.CREATED_DATE AS STRING)) AS ORDER_CREATE_DATE, PARSE_DATE('%m/%d/%Y', CAST(MV.SUBMITTED_DATE AS STRING)) AS ORDER_SUBMIT_DATE, UPPER(MV.CURRENT_STATUS) AS ORDER_STATUS, AC.ACCT_ID AS ACCT_NO, J.JOB_NO, SI.SITE_NO, SI.ZIP_CODE,
Instead of having the possibility of one ridiculous long line, I'd rather stop and make a new line.
Hi @eklein86,
it looks like i have forgotten to answer your question. i am sorry. normally I try to answer within 1 working day.
For your question. You could try the "max line length" option
Regards
Guido