Total Of Columns in Query

[Former Member]

Hi All

how can i show the total of a column at the buttom of page, when i run the query?

[barend_morkel2]

Hi Dany,

There are a couple of ways to achieve this. I'll show you 1 way.

Let's say you this run this query from OINV:

SELECT DocTotal

FROM OINV

Add the values to the matrix and then you can add another line as the total by running this query:

SELECT SUM(DocTotal)

FROM OINV

You can also run through the matrix an count the total row by row...

[Former Member]

Hi Barend,

I want to use the query generator within SAP Bo and SDK.

and i want to show the total of the column at the bottom of the report viewer (in the gray cells at the bottom)and not in a normal line at the end (like using cube).

thank you

[barend_morkel2]

Ok,

1. Access the form (110) in the case of the query generator reprto window.

2. Access the matrix object.

3. Access and sum the columns you are interested in. (run through them row by row.)

4. Access the gray cells and add the values to them (you can get the object ID of ech gey cell using the VIEW->Debug information - this will be helpful to access the columns you are interested in, as well)

Then run throug

[Former Member]

Hi Barend,

my question is: i want the total of columns in the gray cells that are at the bottom of the Form 110. (not in another form). without using SDK.

thank you a lot

[AlexGrebennikov]

Dany, did you try to hold CTRL and click on the column title?

[barend_morkel2]

Dany,

This forum is specifically for developers (SDN - SAP Developers network). Thus if you are looking for solutions that does not require development please state it in your question. This will aid us in understanding your requirements better.

[Former Member]

Hi Alexey,

Thank you for your answer, it's helpful.

but

is there an automatic solution without ctrl+click the title?

thank you

[barend_morkel2]

Only by sending the ctrl+click event - but for that you will have to use the SDK...