nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Dynamic Interval For Table Group

PartnerTek

I'm using table groups in my report.I need Time interval for this group; like month,week,day,hour 
Ok I can use constant values for interval "month","week","day","hour" 
 
but I want to use this dynamically. 
I thought if I pass a timeInterval report parameter, I can manipulate interval value. 
But I don't know how to? 
 
Here is the code snippet from Table Group Xml Source. 
<pre class='_prettyXprint _lang-auto _linenums:0'>
<group id="269">
<property name="groupName">DateTimePeriodGroup</property>
<property name="interval">day</property>
<expression name="keyExpr" type="javascript">row["TIME_PERIOD"]</expression>
<structure name="toc">
<expression name="expressionValue" type="javascript">row["TIME_PERIOD"]</expression>
</structure>
<property name="hideDetail">false</property>
<header>
.
.
so on
</pre>
 
<property name="interval">day</property> 
I want to set this value.

Find more posts tagged with

Comments

rmurphy

I would suggest you create a computed column on your data set that looks at the the parameter and creates the appropriate month/week/day value. Then you can group on this computed column.