Messages »

1

Requests | Пожелания / Re: Lime Report without X

« on: February 02, 2023, 02:25:35 PM »

Hello all

I am still hoping to get an answer. I am still having problems as I want to create reports without X.

HulkHagen

2

Requests | Пожелания / Re: Lime Report without X

« on: September 20, 2022, 01:33:19 PM »

Is LimeReport still alive?
The last change of code (in GitHub) was one month ago and Mr. Arin Alexander was not active in this forum for at least 2 months.

3

Requests | Пожелания / Lime Report without X

« on: September 06, 2022, 03:54:24 PM »

Hello

Is it possible to run Lime Reports without X, so it can be started/used with QCoreApplication?

With a lot of friendly greetings, HulkHagen

4

Discussion | Обсуждение / Syntax for group functions (COUNT, SUM, MIN, MAX, AVG)

« on: March 02, 2022, 11:14:36 AM »

Hello everybody

I am trying to use the COUNT-function but without success. I was not able to find anything function-related in the user manual. What is the correct syntax? What is the purpose of the "DataBand"-Parameter? Is it the band where the query is located in? Or the band the result is displayed? Or the target band where the amount should be displayed?

My goal: I want to output a list of serials in a text field AND display the amount of serials in a different text field.
Displaying the serials works fine by using "$D{production_order.SERIAL}" in a text field.

My SQL-statement of "production_order"

Code: [Select]

SELECT serial
FROM orders
WHERE orderId = $D{orders.id}

I want to display the amount of serial numbers without invoking a second SQL-statement with "Select count(*) ...".


I watched the video on limereport.ru and and adjusted my command to the syntax shown in the video.

Code: [Select]

$S{COUNT("$D{production_order.SERIAL}","DataBand1")}But I get:

Code: [Select]

SyntaxError: Parse errorI tried a lot and tested to omit some of the quotation marks as I seen it in some other forum posts. I also tried different DataBands, but it did not help. If I omit the quotation marks completely:

Code: [Select]

$S{COUNT($D{production_order.SERIAL},DataBand1)}I get:

Code: [Select]

Function COUNT not found or have wrong arguments

What am I doing wrong? Or is there another way to achieve my goal, maybe by using custom scripts/functions?
I am using version 1.4.49


Thanks in advance