Welcome, Guest. Please login or register.
Did you miss your activation email?

Show Posts

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.

Messages - Paul Traut

Pages: [1] 2 3 4
1
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
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,
Quote
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  ;D 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<sup>st</sup>
2<sup>nd</sup>
...

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

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 "HelloHello "???

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
1st
2nd
3rd
4th
...
21st
22nd
23rd
24th
...
and so on.
Is there a possibility to do this in a way, that makes sure that the 2718th 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  :D

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"

Pages: [1] 2 3 4