Question

Add Sub Report UAT

  • 3 March 2022
  • 1 reply
  • 65 views

Userlevel 3
Badge +8

Hi, It seems I am not able to add a sub report to an existing report in Report Customizer anymore. The Add Sub Report button generates the query screen, but there is no way to Submit or Add. I’ve tried resizing, used different reports, etc. but cannot see the buttons at the bottom (at least that’s where they previously were). Suggestions?

 


1 reply

Userlevel 3
Badge +5

Hi

 

  • Try to clear cache in Developer menu.

 

  • You can try change language (or site if you have multi site on the same environnement) too .

Just for adding your subreport, after that, you can return to your habitual language.

 

  • You can try create a new report and adding it on your report.

 

  • Alternatively , you can try this:

Open a report containing a sub report. Copy the subreport and past into your new report.

Do not open the sub report yet.

You must modify name and query name source before in sub report propreties. 

Open the new sub report and delete all contens. Save

Save your report and close all.

Go to the query folder (“DAL”) into your UI folder name of your sub report.

You can try all querys for your UI. Look for a file with .query and open with notepad++ for example the query file .query.

Replace in the query section <sql_statement>(Oracle or MSS section server depend your database) the query by your own query ans save the file.

Clear cache and open the report with the customizer. You can now edit the subreport and you can add fields on it.

 

Hope this help you

 

 

 

 

Reply