‏إظهار الرسائل ذات التسميات Arabic. إظهار كافة الرسائل
‏إظهار الرسائل ذات التسميات Arabic. إظهار كافة الرسائل

الثلاثاء، 6 أغسطس 2019

hide column in classic report [Card Template] Using Custom Template and CSS




you can hide column in classic report in stranded template
by 2 ways
by condition
like
Rows returned
select 1 from dual where 1=2or by using
Authorization Scheme to column
but if You try to make the same for some other template like CARD Template
this will not work
so that you can flow this steps
1 : Copy card template
2: edit the new card template and one substituting  #CARD_STATUS#
<li class="t-Cards-item #CARD_MODIFIERS#">
#CARD_INITIALS#

#CARD_TITLE#

#CARD_TEXT#
#CARD_STATUS# ">#CARD_SUBTEXT#
</div>
<span class="t-Card-colorFill u-color #CARD_COLOR#"></span>
</a>
</div>
</li>
--
3: Assign the new template to your report and add case to check any condition
select
'fa-user' CARD_ICON,
ENAME CARD_TITLE,
JOB CARD_TEXT,
MGR LABEL_01,
HIREDATE CARD_SUBTEXT,
SAL COMMENT_TEXT,
CASE
when UPPER(JOB) Like Upper('SALESMAN')
then 'Status_CLASS'
else ''
end CARD_STATUS
from EMP
--
in our case when JOB = SALESMAN
we will set value for our column CARD_STATUS by  'Status_CLASS'
-----
now our template contain class Status_CLASS
only when JOB = SALESMAN
-----
4: add inline css code for our class
.Status_CLASS
{display: none;}
at the end
any raw contain [job =SALESMAN] will add  a new class for our column CARD_SUBTEXT  which will hide content

Oracle Apex classic report template

How to Create lookup table in oracle Apex

oracle apex Error Handling (Arabic)

Custom Authentication in oracle apex ( Arabic)



custom Authentication  in oracle apex ( Arabic)






Print custom PDF Report Using PL/SQL Dynamic Region in Oracle Apex 19.1

Print custom PDF Report Using PL/SQL Dynamic Region in Oracle Apex 19.1



Print custom PDF Report Using Layout [XSL] Designed By Altova StyleVisio...



Print custom PDF Report Using Layout [XSL] Designed By Altova StyleVisio...



Print custom PDF Report Using Report Query and Custom Report Layout [XSL]

Print custom PDF Report Using Report Query and Custom Report Layout [XSL]


Print custom PDF Report Using Report Query and Generic Report Layout

Print custom PDF Report Using Report Query and Generic Report Layout



How to use Oracle Apex [API] Arabic

How to use Oracle Apex [API] Arabic

How to Solve Ords Issue : The request could not be mapped to any database.

 The request could not be mapped to any database.  Check the request URL is correct, and that URL to database mappings have been correctly c...