1. Roland Smith
  2. InfoMaker
  3. Tuesday, 17 September 2024 19:04 PM UTC

One of our customers is expecting that when saving a grid report to XLSX, the headers be what is in the header instead of the column name all lower case.

Is there a way around this in InfoMaker?

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 17 September 2024 19:49 PM UTC
  2. InfoMaker
  3. # 1

Hi Roland;

  This is easy to do of course in PB as the PB App can share the current DWO buffer with a DataStore that has a duplicate DWO it it where the headers are customized to accomplish what the IM user wants. Of course, IM does not have this capability.

   Suggestion: What about creating a small PB App that runs the IM report (aka DWO) and performs the above task for the IM user reporting wise over to Excel?

Regards .. Chris

Comment
There are no comments made yet.
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Wednesday, 18 September 2024 15:16 PM UTC
  2. InfoMaker
  3. # 2

Hi Roland

Apart from changing the SQL query to be as near to their requirements there is not a lot you can do, it might be possible to Capitalise the Headings through a macro of something after the XLSX has been saved?

Good luck

David

Comment
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 19 September 2024 17:48 PM UTC
  2. InfoMaker
  3. # 3

I tried saving as HTML and then opening it in Excel. That works, although you have to turn grid lines on manually.

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.