Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
CrossTab cell formatting?
Migrateduser
Hi,<br />
<br />
I have report with several graphs and one crosstab. The layout of the crosstab is as follows<br />
<br />
<p class='bbc_indent' style='margin-left: 40px;'><p class='bbc_indent' style='margin-left: 40px;'>ColumnName[colIndex]</p></p>
DataFrom | DataType[rowIndex] || Data<br />
<br />
It should look something like<br />
<br />
<p class='bbc_indent' style='margin-left: 40px;'>Monday Tuesday ......</p>
Paris Furniture 1200 2000<br />
<p class='bbc_indent' style='margin-left: 40px;'>Candies 120 220</p>
<p class='bbc_indent' style='margin-left: 40px;'>ROI 5.5% 7.0%</p>
<br />
London Furniture 2200 2700<br />
<p class='bbc_indent' style='margin-left: 40px;'>Candies 220 320</p>
<p class='bbc_indent' style='margin-left: 40px;'>ROI 6.5% 8.0%</p> <br />
etc<br />
<br />
The data is produced by a database query and all computation is done (in Java) before pushing the data to the <br />
report.<br />
<br />
A line of data to the report looks like:<br />
<br />
{dataFrom:sales, dataType:candies, columnName:Monday, columnIndex:1, data:1200,.....}<br />
<br />
Everything works okay, for the exception of the rows (and a specific columns) containing percentages. All data, including percentage is pushed in the double datatype from Java, i.e. 0.055 for 5.5%. The report design data type is decimal.<br />
<br />
The requirement of the rows and columns containing percentages is that its shows the %-sign and if value is positive the color of the cell/number should be green, if negative then red.<br />
<br />
I have managed to get the colors on the correct row and column cells containing the percentages. However I am unable to get the % sign into those same cells.<br />
<br />
In the crosstab script I have <br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
function onCreateCell( cellInst, reportContext )
{
if( cellInst.getDataValue("columnName")=="ComparedToPreviousMonth" ||
cellInst.getDataValue("dataType")=="ROI")
{
// cellInst.getStyle().setNumberFormat("##.##%");
if(cellInst.getDataValue("data_TypeGroup/dataType_columns/columnName") < 0)
cellInst.getStyle().setColor("RGB(253,120,120)");
if(cellInst.getDataValue("data_TypeGroup/dataType_columns/columnName") > 0)
cellInst.getStyle().setColor("RGB(0,139,8)");
}
}
</pre>
As I said the coloring works correctly for the given rows and columns. But if I remove the comment on the line with setNumberFormat, then every cell in the whole crosstab gets formatted with % and extra zeros. <br />
<br />
It appears that setNumberFormat somehow affects every cell while the coloring works as expected, for the specified row and column cells. <br />
<br />
How should I solve this problem?
Find more posts tagged with
Comments
There are no comments yet