BUG: CPX881: Comparing two RECFM=VB data sets are getting incorrect results in CPX75I message? Refer to solution… https://t.co/RCLt6fuxx6
Is there a way I can export to a custom Excel template? Bonus points if I can do it from multiple sources.
For instance, I'd like say, six lines populated from a particular aux table with certain fields in certain places, then at line 10, start the listing report with its eight columns of data I want from the main table.
Is such a thing possible in BPM? Or would I have to use an external reporting tool (SSDT et al) to do this?
Accepted AnswerDavid SheaffeOffline0The only thing I can think of without using a 3rd party reporting tool - and not even sure if this would work, or be practical, or suit your needs - would be to create separate listing reports in SBM. Then in Excel, use the Data tab to make connections to the various listing reports, then use lookups, etc to display the data from seperate reports on one worksheet. But doing all that - I would probably go with a 3rd party reporting tool.