Different Between client side Condition and Server Side Condition in Oracle Apex
إظهار الرسائل ذات التسميات Arabic. إظهار كافة الرسائل
إظهار الرسائل ذات التسميات Arabic. إظهار كافة الرسائل
الأربعاء، 14 أغسطس 2019
الثلاثاء، 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
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
الاشتراك في:
الرسائل (Atom)
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...
-
1: add privilege to use UTL_FILE to You User grant execute on utl_file to STOCK; 2 : Create Directory to save File and add privilege t...
-
Interactive Grid Region Static ID 'ig_emp ' Add New raw For Interactive Grid apex.region( "ig_emp" ).widget().inter...