1
Discussion | Обсуждение / Re: Change font in the middel of a TextItem
« on: October 23, 2018, 05:00:01 PM »
Thanks,
have forgotten the html functionality
Paul
have forgotten the html functionality
Paul
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
$S{
if ( $S{$D{test.COUNT(*)}+1} <10)
"00"+$S{$D{test.COUNT(*)}+1};
else if ( $S{$D{test.COUNT(*)}+1} <100)
"0"+$S{$D{test.COUNT(*)}+1};
else
$S{$D{test.COUNT(*)}+1}
}
SELECT DISTINCT ID as OrderID, Name, ProductId, Creationdate
FROM ttorders
where productid = $D{products.productid} and creationdate >= '11/28/17 2:42 PM'
I get the error: ORA-01843:not a valid month.SELECT DISTINCT ID as OrderID, Name, ProductId, Creationdate
FROM ttorders
where productid = $D{products.productid} and creationdate >= '2017-11-28 09:21:29'
I get the error: ORA-01861: literal does not match format string.'2017-11-28 09:21:29'
is the format within my db and this'11/28/17 2:42 PM'
is how lime report shows me the date within the preview.function formatNumber(number)
{
var modNumber = number % 10;
switch(modNumber)
{
case 1 :
{
tensDigit = number.toString().charAt(number.toString().length-2);
switch(tensDigit)
{
case "1":
result = "<sup>th</sup>"
break;
default:
result = "<sup>st</sup>"
break;
}
}
break;
case 2 :
result = "<sup>nd</sup>"
break;
case 3 :
result = "<sup>rd</sup>"
break;
default:
result = "<sup>th</sup>"
break;
}
return number.toString()+result;
}
Paul, the question by Fynjy about the init script location in LMDesigner...Ok, Thanks
Fynjy: смотри файл, там стрелкой указано, где инит скрипт располагать
Paul,QuoteCan I also use the MOD operator within the script, than it would be easier to write a script for an unknown amount of linesLimereport uses javascript. In javascrip Modulus (%) operator returns only the remainder.