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

Grouping in column wise

Morning all,

I was wondering how can you show a group in a column wise format? I have created a group of a formula (Number of days) and it is showing row wise. I'd like to show it as column wise.

For example currently

0

1

2

3

4

5

I would like it to show it like

0 1 2 3 4 5

Any ideas?

regards

Jehanzeb

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2008 at 01:57 PM

    Hi Jehanzeb,

    Is the number of rows fixed with a maximum. For instance if you have 6 columns then you might be able to pivot the data against the rownumber

    Regards

    Alan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I used another approach.

      here how I did it/

      I grouped it by number of days in ascending order.I then used formula (from 0 to 10 days)

      If {@NumofDays}="0" then
      if ({order_header.order_status})>0 then
      if ({order_header.order_status})>-1 then
      ({order_header.order_no})
      

      and placed all of them in the detail section.

      Oh before that as it stated I placed a Numberofdays formula field in the detail section as well. (I then hide the details section)

      Then I used a Summary button and used DistinctCount on the Grand Total.

      After placing all the summaries I ran the report and it worked.

      Regards

      Jehanzeb

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.