cancel
Showing results for 
Search instead for 
Did you mean: 

Total Of Columns in Query

Former Member
0 Kudos
358

Hi All

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

Accepted Solutions (0)

Answers (1)

Answers (1)

barend_morkel2
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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

barend_morkel2
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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