Skip to Content
0
Former Member
Feb 20, 2008 at 08:03 PM

Reports with conditions - overcoming SAP bugs w.r.t Incorrect Results

26 Views

Hi

We have a problem, which has been around for quite some time now, and has recently been confirmed by SAP.

In reports with conditions, the overall result and result lines are incorrect, in that their values are calculated on the entire resultset, rather than the filtered / conditioned resultset. I am told this "error" has been around a while, and we even went as far as getting SAP personell in to see our problem, and they agreed that in terms of the way we wanted the totals to display, the SAP standard approach is wrong.

That is where I entered the scene, and my challenge has been to build JavaScript which will then determine the values correctly.

We are working on a 2004s system, so this could probably be done in Table Interface class in previous systems.

I have now completed the JavaScript, and it works quite nicely, updating the required values whenever the page loads (including if columns are dragged in or removed etc.)

The only problem I have now, is that when the report is exported to PDF / Excel, the updated values are not exported, but rather the "incorrect" values.

My code has been written such that it executes once the page has completely loaded, and only changes the HTML output.

Has anyone done something similar, and more importantly, found a way to update the stream that is sent to PDF or Excel.

I would be most appreciative of any constructive input.

Cheers,

Andrew