1. Paul Weir
  2. InfoMaker
  3. Friday, 4 November 2022 17:05 PM UTC

I'd like to have a nested report within a main report and to be able to save all rows - from both the nested and primary report - into Excel. Is there any way to do that? When I try, it saves only the rows from the primary report and does not save the rows from the nested report.

 

Paul Weir

Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 4 November 2022 20:56 PM UTC
  2. InfoMaker
  3. # Permalink
Sorry Paul, I missed the fact that this was an IM question. Since IM has no programming capabilities - then the answer is a solid NO. Sorry. This would need to be done via a product enhancement request.
Comment
  1. Paul Weir
  2. Friday, 4 November 2022 20:56 PM UTC
Thanks! How could I request a product enhancement?
  1. Helpful
  1. Chris Pollach @Appeon
  2. Friday, 4 November 2022 20:59 PM UTC
Either send an email to Product@appeon.com with your enhancement request details or open Support Ticket and request an enhancement that way.

FYI: https://www.appeon.com/standardsupport
  1. Helpful 1
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 4 November 2022 18:19 PM UTC
  2. InfoMaker
  3. # 1

Hi Paul;

  This is not currently supported by the SavreAs command. Only the parent DWO's primary buffer is used by the SaveAs to export the datum into Excel format.

  You could work around this by accessing each Child DWO's buffer & copying this to a new DWO instance (say within a DataStore) and then perform a SaveAs() operation on each DS. However, then you would end up with many Excel files vs one integrated one.

  You may want to check out the DW2XLS 3rd party product and see if that can perform the functionality that you are looking for.

Regards ... Chris

Comment
  1. Paul Weir
  2. Friday, 4 November 2022 18:57 PM UTC
Thanks, Chris. So, if I'm just running a report from the Infomaker GUI, does all of what you say still apply? I'm not programming or anything like that.
  1. Helpful
There are no comments made yet.
PowerObject ! Accepted Answer Pending Moderation
  1. Saturday, 5 November 2022 17:06 PM UTC
  2. InfoMaker
  3. # 2

You can loop through the nested reports and save each one as a separate CSV file.

After saving all children, loop through all the saved CSV files and merge them into a single CSV file (maybe use one or two blank lines to separate each).

Open the consolidated CSV file programmatically in PB using OLE Automation and re-save as Excel file.

Delete all temporary CSV files programmatically.

This is possible - I've done this before. However, you may lose some formatting due to export to CSV.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.