Messages »

1

Discussion | Обсуждение / Re: accumulator textitem in data

« on: October 28, 2022, 12:39:53 pm »

I think the question was about running sum, i cant find answer on rest of forum, this question is closest and i didn't want to start a new topic.
if you have a datasource that has for example four rows with some value 10, 10, 100, 1, next to value at each row i would like a running sum. *the values for the example would be 10, 20, 120, 121. For each row accumulated values of previous rows.
How to achieve that?

2

Discussion | Обсуждение / How to skip print dialog and print to default printer

« on: March 07, 2017, 03:43:37 pm »

When executing ReportEngine::printReport() the dialog shows for selection of the printer and additional print button click
How can I skip his dialog and print directly to default printer?

3

Discussion | Обсуждение / Re: printer dialog shows only print to pdf

« on: March 07, 2017, 03:01:23 pm »

Although my name sounds Russian, i don't speak Russian your post was all I needed, thanks...

4

Discussion | Обсуждение / printer dialog shows only print to pdf

« on: March 04, 2017, 10:29:19 am »

Hi, this happens on ubuntu 16.04 64bit. when preview is showed and print icon is clicked the only printer visible is Print to PDF but another printer is installed and visible in system print dialog... (i did not click on print to pdf icon, phe Print to PDF is printer available in linux)
Is there a way to show native print dialog?

5

Discussion | Обсуждение / Re: problem with database connection

« on: February 12, 2017, 02:29:20 am »

LimeReport save pasword as crypted

I checked your code, and since it is "open source" password is really unsafe, because everything needed to decrypt the password is right there in the code.
Send me any of your lrxml files and i will read database credentials within minutes.
You added the possibility to send those credentals as variables, but that complicates a little development, and it is like workaround solution.
It didn't come to my mind that limereport library has integrated designer, i allways assumed that designer is separate application. Anyway i executed lrdesigner from application and there is "qt_sql_default_connection" item in select list.
That is realy strange that standalone lrdesigner is not able to create report for any application. there is some hidden design flaw. Something is not where it should be or something is not named right.
I think that the connection should not be part of report but part of application that runs the report. Standalone LRDesigner should manage its own db connections by name
Qt has a way of creating multiple connections by name

Code: [Select]

QSqlDatabase::database() is actually default connection named "defaultConnection". The full function is

Code: [Select]

QSqlDatabase::database(const QString &connectionName = QLatin1String( defaultConnection ), bool open = true) you should use the same logic, and the same mechanism. That item in the list should be called "defaultConnection" instead of "qt_sql_default_connection", and standalone lrdesigner should be able to create one defaultConnection, and manage/save connection  parameters outside report, maybe in some settings file (even if it is unsafe), or popup ask user dynamicly when needed. So that i you can use lrdesigner for any application you have.
When executing the report, the engine should search for connection by name defined when report was designed.

Code: [Select]

QSqlDatabase::contains(const QString &connectionName = QLatin1String( defaultConnection )) can check for connection, if found it can be used.

Report is part of source code, and database passwords do not belong there
Anyway i am looking forward for your solution for managing report connection.

6

Discussion | Обсуждение / Re: problem with database connection

« on: February 11, 2017, 01:48:38 am »

Code: [Select]

If you need it i can add method that will replace an internal report connection to the connection created by an application.Yes it would be great, i was even thinking if default behavior should be that report uses that default application connection, unless user/programmer creates another connection, or asks the engine to use connection from report (that is kind of unsafe to store connection parameters in report).

 

7

Discussion | Обсуждение / Re: problem with database connection

« on: February 11, 2017, 01:33:21 am »

In LRDesigner, when i open the report, and click on the icon from image (table with green plus sign) i get Datasource dialog, and in Connection dropDownList there is no item named qt_sql_default_connection, There is only one item, the connection i created when i created the report with the name i gave it before in the field Connection Name

8

Discussion | Обсуждение / Re: problem with database connection

« on: February 10, 2017, 07:39:50 pm »

I am using latest tag (1.3.12) from git, and it was built with qt 5.7.1 mingw32
The thing is that i can't find a way to reproduce the problem, as it happens quite randomly, after a lot of reports that executed without any problem. But when it starts, no report can be generated until i restart application or edit lrxml like i explained.
I would like to have username/password saved in lrxml, so that i can use some test/test username password in development and i dont have to change lrxml every time i have to deploy new version. But when the report is executed in production, i would like to use the existing connection overriding the connection set in report.
When you say

add a new datasource you can select "qt_sql_default_connection as the value for the property "Connection"

in lrdesigner there is only field "Connection Name" and it is lineedit (not select)
I was hoping for some function in my code after i create LimeReport::ReportEngine object, but i cant find it.

9

Discussion | Обсуждение / problem with database connection

« on: February 09, 2017, 03:41:23 pm »

I have a strange problem with limereport. Sometimes the executed report shows errors on all fields, like field not found. When i restart application the report executes ok. Report uses the same database connection parameters as my application (database is mysql). With application not able to generate report, and showing those errors, and while application is still running, i edited lrxml file, and used another username/password for database connection and retried executing the report. the report executed ok. Then again without exiting my application i reverted to previous username/password and report executed ok. My username/password has no connection limits but i still believe there is multiple connections problem.
Anyway i don't like the way limereport stores database username/password in the lrxml file and i would like to use existing database connection that is already open in my application. I think that if i could pass my connection to limereport i would solve both issues, although that connection problem must not be ignored and forgotten. Is there a way to use existing db connection? if not consider this as a feature request?

10

Discussion | Обсуждение / Re: undefined reference to QMap<LimeReport::BandDesignIntf*, QString>::values(LimeR

« on: January 09, 2017, 08:40:53 pm »

yes i use git version, first i tried master, and then i tried latest tag 1.3.12. same error in both cases...
i opened  limereport.pro project with qtcreator, clicked build and the error is produced when compiling subdir demo_1, so if there is error in my pro file there is one in  demo_1 also

and i just updated qt from 5.7.0-1 to 5.7.1 and it compiled just fine
thanks

11

Discussion | Обсуждение / undefined reference to QMap<LimeReport::BandDesignIntf*, QString>::values(LimeR

« on: January 08, 2017, 10:00:24 pm »

I am trying to compile from source (git) and i get errors

/home/davidovv/src/LimeReport/build/5.7.0/linux64/release/lib/liblimereport.so:-1: error: undefined reference to `QMap<LimeReport::BandDesignIntf*, QString>::values(LimeReport::BandDesignIntf* const&) const'

/home/davidovv/src/LimeReport/build/5.7.0/linux64/release/lib/liblimereport.so:-1: error: undefined reference to `QMap<QString, LimeReport::GroupFunction*>::values(QString const&) const'

the library is built but the demo isn't
i get the same error when i try to use that lib with my project
as you can see i am building on linux