Messages »

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

2

Discussion | Обсуждение / Re: numberFormat

« on: October 23, 2018, 04:55:49 pm »

Hi,

thanks for your answer.

My solution now is:

Code: [Select]

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

and this works fine for me.
I only thought that there is something with the "numberFormat" function.

Paul

3

Discussion | Обсуждение / numberFormat

« on: October 23, 2018, 12:11:20 pm »

Hello,

depending on the number I would like to have something like
1 -> 001
2 -> 002
.
.
10-> 010
11-> 011
.
.
100->100

and so on.

Howe can I set this within the numberFormat function and is there a Wiki where all possibilities are described?

Thanks Paul

4

Discussion | Обсуждение / Change font in the middel of a TextItem

« on: October 23, 2018, 11:31:57 am »

Hello,

is it some howe possible to chang the font style in the middle of a text.
I mean something like

"This is a text in a TextItem where this part is "Bold" but the rest is normal."

5

Discussion | Обсуждение / Date format in the sql statement

« on: January 11, 2018, 04:38:20 pm »

Hi,

I have problems to create an sql statement
If I try something like this:

Code: [Select]

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.

If I try this:

Code: [Select]

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.

The Problem is:
This

Code: [Select]

'2017-11-28 09:21:29'is the format within my db and this

Code: [Select]

'11/28/17 2:42 PM'is how lime report shows me the date within the preview.

How can I filter my results depending on the date???

6

Discussion | Обсуждение / Re: Text formating

« on: December 18, 2017, 04:43:00 pm »

Ok,

here is my solution. Maybe someone is searching for the same in the future
 

Code: [Select]

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

7

Discussion | Обсуждение / Re: Text formating

« on: December 18, 2017, 02:39:11 pm »

Paul, the question by Fynjy about the init script location in LMDesigner...

Fynjy: смотри файл, там стрелкой указано, где инит скрипт располагать

Ok, Thanks

Paul,

Can I also use the MOD operator within the script, than it would be easier to write a script for an unknown amount of lines

Limereport uses javascript. In javascrip Modulus (%) operator returns only the remainder. 

Thanks, will use this

8

Discussion | Обсуждение / Re: Text formating

« on: December 18, 2017, 11:23:36 am »

Hello Fynjy,
unfortunately, I can not read Russian 

9

Discussion | Обсуждение / Re: Text formating

« on: December 15, 2017, 04:04:40 pm »

Oh
I have over read this important information, now it works  Thanks.

Can I also use the MOD operator within the script, than it would be easier to write a script for an unknown amount of lines
 

10

Discussion | Обсуждение / Re: Text formating

« on: December 15, 2017, 03:50:11 pm »

Hello Alex,
this code doesent work right, I get
1^st
2^nd
...

as a result and not
1^st
2^nd
...

11

Discussion | Обсуждение / Re: Text formating

« on: December 15, 2017, 02:35:59 pm »

Ok, thanks.

But this means, I have to write within the script a case for every single number that I could expect

12

Discussion | Обсуждение / Re: Text formating

« on: December 15, 2017, 12:06:24 pm »

PS.: How can I format a text within LimeReport to get something like this "Hello^Hello "

Paul

13

Discussion | Обсуждение / Text formating

« on: December 15, 2017, 12:00:12 pm »

Hello,
I would like to use a "counter" within a text field like
1^st
2^nd
3^rd
4^th
...
21^st
22^nd
23^rd
24^th
...
and so on.
Is there a possibility to do this in a way, that makes sure that the 2718^th entry is also formatted correct?

Paul

14

Discussion | Обсуждение / Re: Database table with key/value pairs

« on: December 08, 2017, 09:58:07 am »

I have tried to do so, but i failed 
How can I get the Development branch?

15

Discussion | Обсуждение / Re: Database table with key/value pairs

« on: December 07, 2017, 05:05:18 pm »

Hello, I`m back 

I am trying to use the function getFieldByKeyField("Datasource name", "Value field name", "Key field name", "Key value") but the designer tells me, that he can not find the variable getFieldByKeyField. I have installed thid version "https://github.com/fralx/LimeReport.git"