Group Name in Reports

Hi,

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.

Hi @saurabh60292,

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.

Regards,
Aleksey

1 Like

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

@vlad.minaev, could you please give a tip?

@saurabh60292 Could you please attach more detailed log? (just copy more text before the exception above).

@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

@saurabh60292

Please install git and make sure it’s available in the command line. It’s required for Polymer UI build process.

1 Like

Hi,

Here is the variable (path) = C:\Program Files\Git\bin;C:\Program Files\Git\cmd
and here is the git version from the command line:

$ git --version
git version 2.16.2.windows.1

is that correct?

Also do I need node.js installed for this?

Regards,
Saurabh

You need just git. Node.js will be downloaded by gradle

1 Like

Hi,

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

RuntimeException: Wrong range value Sheet1!#REF!

while using excel template?

Thanks,
Saurabh

Hi,

DOCX template doesn’t support grouping. You can use grouping only with XLS/XLSX templates.

RuntimeException: Wrong range value Sheet1!#REF!

Could you provide your XLSX template?

Thanks,
Andrey

1 Like

helpful, Thank you very much
_RuntimeException: Wrong range value Sheet1!#REF!_ was resolved after I added the bands in Formulas->Name Manager

Thank You Guys , this thread is resolved now.
Below are the doubts cleared:

  • Grouping of records can only be done in XLS/XLSX template.
  • Git need to be installed in local for the git cloned polymer projects.
  • Band structure need to be correct to use in template.