This is one region in the report which is separated by dotted line.On right side of page I have other regions. Kokila RT wrote:The report layout got changed.- Col Val A - 1 B - 2 C - 3 D - 4 - Col Val A - 1 B - 2 C - 3 D - NULL This is the updated layout.The row D should only be displayed when the value is NOT NULL.
![move column in apex sql move column in apex sql](https://2.bp.blogspot.com/-yVdWBawElN4/Wpfr_i0GmdI/AAAAAAAAB24/HQ3h45tvqpcsyGOiLOGrzOkE7_QQFdn8QCLcBGAs/w1200-h630-p-k-no-nu/Port-U%CC%88bersicht_-_Securtiy_Datenbank__SDB___Assetklassen_des_Grundnetzes.png)
If the report is being rendered as a table, how do you expect this to function when cells are conditionally removed from some rows? What APEX version, theme, and report template is being used? Output when D have valueĪnd I dont want to show the Row D when D is not null.Īre we discussing columns or rows? Is data to be rendered when the column has a value or not? Please provide unambiguous clarification of the requirements. The stated requirements are confusing and contradictory: I need to Show the column D only when the value is NOT null. I dont want to show the Row D when D is not null.
![move column in apex sql move column in apex sql](https://hardlikesoftware.com/weblog/wp-content/uploads/2019/11/apex_ig_cookbook_v6.png)
Output when D have value Col Val A - 1 B - 2 C - 3 D - 4 Col Val A - 1 B - 2 C - 3 D - NULL select A,B,C,D from table1 I need to Show the column D only when the value is NOT null. I have a classic Report based on SQL query.
#MOVE COLUMN IN APEX SQL HOW TO#
Please update your forum profile with a recognisable username instead of "user517787".Īlways include the information described in these guidelines when asking a question: how to get answers from forum My requirement is below.
![move column in apex sql move column in apex sql](https://tajuddin.chittagong-it.com/wp-content/uploads/2018/05/create-report.jpg)