Many a time I had previously used OLE for excel based online reporting, but this time it was a graph.

The requirement was to have a Stacked Bar chart, to have a invoice status wise colour difference for same Account Manager.

First I said its not possible, but now I have the confidence to say, same output as in excel report could be achieved from ABAP OLE coding.

The best reference is excel macro recording codes.

Report.png

From the available  help links and documents, I could understand that the type of report is 52

chart type.png

Then the real challenge was to have the legend dynamically with only available statuses from larger list.

So add dynamic coding to add column based on available statuses with value and then hide this status based invoice value column.

Dynami.png

Hide column logic

/wp-content/uploads/2016/06/hidden_975960.png

To use the hidden columns’ data in graph we have to enable the following option in excel ,

finding the equivalent for that from ABAP was another difficulty, finally from an excel macro was able to trace that

UseHiddenRows.png

Then Enabled legend based the Invoice Status ( Colour coding is based on this statuses)

/wp-content/uploads/2016/06/legend_975968.png

Though there are many other reporting option, OLE is powerful.

The  report  exactly met our customer expectation. 🙂

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply