I am using DatasetType as ‘SQL’ to generate report. I am able to fetch the records from db and able to create the report file, but how can I group (with group name) the records in reporting doc file. Do I need to use JPQL for this? Cuba documentation is not much help for this.
It doesn’t make difference how you fetch data via SQL, JPQL or define resulting map in Groovy. It mostly about your template and bands structure. If I understand you right, have a look at the [XSLX] Orders for customers report in this project.
Thanks. But I am getting below error while starting application:
org.gradle.process.internal.ExecException: Process ‘command ‘C:\Users\spandey\Downloads\sample-report-generation-master\sample-report-generation-master\modules\polymer-client.gradle\nodejs\node-v8.1.2-win-x64\node.exe’’ finished with non-zero exit value 1
@minaev below are the error I am getting. Though Git is intalled and variable path for git is set already.
:app-polymer-client:installBowerPackagesbower fetch#^2.0.2 ENOGIT git is not installed or not in the PATH
FAILED
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task ':app-polymer-client:installBowerPackages'.
> Process 'command 'C:\Users\spandey\Downloads\sample-report-generation-master\sample-report-generation-master\modules\polymer-client\.gradle\nodejs\node-v8.1.2-win-x64\node.exe'' finished with non-zero exit value 1
* Try:
Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output.
BUILD FAILED
Total time: 2 mins 57.511 secs
[18:00:12.092] Task 'deploy, start' failed
org.gradle.process.internal.ExecException: Process 'command 'C:\Users\spandey\Downloads\sample-report-generation-master\sample-report-generation-master\modules\polymer-client\.gradle\nodejs\node-v8.1.2-win-x64\node.exe'' finished with non-zero exit value 1
Like in this project, grouping in report has been done in excel template. Is it possible to group them in docx template?
And why I am getting exception