How to add sql formatting commands in live report

Sun_Livelink_Admin_(sunmic01admin_-_(deleted))

HiI need to add the this command to supress one column display.COLUMN X NOPRINTIt works with other sql editors but fails with 'invalid sql' error in live reports.

Find more posts tagged with

Comments

Lindsay_Davies

Message from Lindsay Davies via eLinkHi Seetha,As far as I am aware 'column' is an Oracle SQL*Plus formatting command,not a SQL statement in itself.Livereports only handle sql statements.I assume you are choosing AutoLivereport as you Livereport outputformat.In this case, simply do not select column X from your table.If that does not make sense in your context, please post the full SQL oran export of your Livereport object.RegardsLindsayOpen TextUK-Support -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 11 September 2006 19:13To: eLink RecipientSubject: How to add sql formatting commands in live reportHow to add sql formatting commands in live report Posted by Valluri,Seetha on 09/11/2006 02:07 PMHiI need to add the this command to supress one column display.COLUMN X NOPRINTIt works with other sql editors but fails with 'invalid sql' error inlive reports.[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Sun_Livelink_Admin_(sunmic01admin_-_(deleted))

thanks for your reply Lindsay,The sql has multiple unions with three colums to sort., each display colum is again an expression of which one is a date field in character format. I need to display the date as character but sort it as date. So I was trying to supress an additional 'date' column.the sample sql is likeSELECT work_workid AS "id" , TO_CHAR(work_dateinitiated, 'ddMonYY') AS "Date I" FROM WWORK WHERE work_workid IN (1, 2,3,4,5)UNION SELECT work_workid AS "id", TO_CHAR(work_dateinitiated, 'ddMonYY') AS "Date I"FROM WWORKWHERE work_workid IN (12,13,14,15 )) ORDER BY work_dateinitiated