Skip to Content
author's profile photo Former Member
Former Member

Grouping of Rows in a Query

Hi Experts,

I have a requirement as follows:

100 User Group

A100 Users xxxx 100 ..... 50

A101 Users yyyy 100 ... 60

Total 110

50 Users Group

A50 Users zfdcfs 50 ..... 25

A50 Users adcga 50 .... 15

Total 45

20 Users Group

B20 Users hadcf 20

B20 Users sghdf 20

My problem is I have several Hierarchies for Users Group, but I can use none as they are grouped differently. Secondly I don't even have the indicator or anything in the InfoProvider to identify them as 100, 50, 20. My first question is - is there any way to create a different grouping at the reporting level and also generate total for each group ? My Second question is - I need to show 100, 50,20 in the report which is noway avaialble in the infoprovider, is it possible to create any contanst CKF or RKF, which I can use for display and also for calculation?



Message was edited by:

Paromita Das

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 07, 2007 at 04:10 PM

    Can you create your own Hierarchy and group the users as per your application needs?

    If there is a good reason for not creating a new hierarchy then you can look at alternatives.

    Good luck, BB

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.