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; } } }

Cross Tab Formatting

birtprofi

Find more posts tagged with

Comments

mwilliams

Think you can put together a quick example with the sample database or a flat file, that I can run and test on, that has your issue?

birtprofi

Hi Michael, 
 
I made a new sample report and within this, the script to design my border works correct. So I tried different things and now I have solved my problem. But I dont know why. Because normally javascript work the code from first to last. See my commentar //first and //second 
 
So If I made a function like this: 
(With this the border line don?t works correct) 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>

function onCreateCell( cellInst, reportContext )
{
//first set the background color of summarize/measure field and invert the color to black or white

if( cellInst.getCellID() == 4703)
{
var nr = reportContext.evaluate("measure['Dienstplan::DP_COLOR']");
if (nr != null)
{
var hex=""+hexe(nr);
cellInst.getStyle().setBackgroundColor("#"+hex);
}
if (nr == null){
cellInst.getStyle().setBackgroundColor("white");
}
}

if( cellInst.getCellID() == 4703)
{
if (rgbinvert(nr) > 127)
{
cellInst.getStyle().setColor("black");
}
else {
cellInst.getStyle().setColor("white");
}
}

// second draw the border line

if( cellInst.getCellID() == 4703)
{
var linie = reportContext.evaluate("dimension['Group2']['Day Of Week']");
if (linie == 7)
{
cellInst.getStyle().borderRightStyle = "solid";
cellInst.getStyle().borderRightWidth = "medium";
cellInst.getStyle().borderRightColor = "black";
}
}</pre>
 
But if I change the first and second script, then everything works perfect: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>function onCreateCell( cellInst, reportContext )
{
// second draw the border line

if( cellInst.getCellID() == 4703)
{
var linie = reportContext.evaluate("dimension['Group2']['Day Of Week']");
if (linie == 7)
{
cellInst.getStyle().borderRightStyle = "solid";
cellInst.getStyle().borderRightWidth = "medium";
cellInst.getStyle().borderRightColor = "black";
}

//first set the background color of summarize/measure field and invert the color to black or white

if( cellInst.getCellID() == 4703)
{
var nr = reportContext.evaluate("measure['Dienstplan::DP_COLOR']");
if (nr != null)
{
var hex=""+hexe(nr);
cellInst.getStyle().setBackgroundColor("#"+hex);
}
if (nr == null){
cellInst.getStyle().setBackgroundColor("white");
}
}

if( cellInst.getCellID() == 4703)
{
if (rgbinvert(nr) > 127)
{
cellInst.getStyle().setColor("black");
}
else {
cellInst.getStyle().setColor("white");
}
}

</pre>
If someone is interested I have attached the sample report without color, but with the border line on day 7 of each week, with the sample database and scripted date Database. (for tests use 01.01.2005 - 31.01.2005) -> Report Version 3.7.0 
 
best regards 
Rafael