Topic
10 replies Latest Post - ‏2013-02-14T18:21:05Z by DanielWagemann
SystemAdmin
SystemAdmin
1959 Posts
ACCEPTED ANSWER

Pinned topic How to hide the subtotal

‏2013-02-07T21:13:59Z |
Hi all,
Cognos 10.1.1, Sql server 2012, Relational model , report studio.

I have created a sample report where I need to hide the subtotal as attached on this post.

I have to hide the subtotal where if the report has one row.

First column is element 1 and the second column is element 2.
So I group on element 1 column to get the subtotal based on the element 1 only.
Now I need to hide the subtotal if the element 1 is only 1 row.

someone please help me to solve this issue.

Thanks,
Winson.
Updated on 2013-02-14T18:21:05Z at 2013-02-14T18:21:05Z by DanielWagemann
  • SystemAdmin
    SystemAdmin
    1959 Posts
    ACCEPTED ANSWER

    Re: How to hide the subtotal

    ‏2013-02-07T21:16:05Z  in response to SystemAdmin
    attached.
    • SystemAdmin
      SystemAdmin
      1959 Posts
      ACCEPTED ANSWER

      Re: How to hide the subtotal

      ‏2013-02-07T21:17:18Z  in response to SystemAdmin
      look like the attachment not working.
      • SystemAdmin
        SystemAdmin
        1959 Posts
        ACCEPTED ANSWER

        Re: How to hide the subtotal

        ‏2013-02-08T14:04:44Z  in response to SystemAdmin
        attached
        • SystemAdmin
          SystemAdmin
          1959 Posts
          ACCEPTED ANSWER

          Re: How to hide the subtotal

          ‏2013-02-08T14:38:57Z  in response to SystemAdmin
          for some reason it is not getting upload it so I have to upload it to some other site and post the link here.

          Please someone help me with this issue.
          http://www.2shared.com/file/wDi10OVm/comparison.html

          Upload the attachment on the above link.

          Thanks,
          • DanielWagemann
            DanielWagemann
            849 Posts
            ACCEPTED ANSWER

            Re: How to hide the subtotal

            ‏2013-02-09T00:36:12Z  in response to SystemAdmin
            Assuming you are using a relational package you can do a calculation to get the running-count for your high level grouping.

            
            maximum(running-count([OrderMethod])
            


            You can then do an advanced conditional style where this calc=1 then have a box type of none.

            Be sure to add the calc to the properties property of the List otherwise you will get the CRX error.

            I have tested the above and it works.
            • SystemAdmin
              SystemAdmin
              1959 Posts
              ACCEPTED ANSWER

              Re: How to hide the subtotal

              ‏2013-02-13T21:02:16Z  in response to DanielWagemann
              Thanks Daniel.

              Actually did not work since I have element 1 & element 2 subtotal (like similar to order number) since I have 2 columns controlling the subtotal it is not working.
              if you take a look at the sample report which i have it on this link

              http://www.2shared.com/file/wDi10OVm/comparison.html

              Upload the attachment on the above link.

              Yes this is relational model and list report.

              the solution which you provide it should work if I have just one column.

              Thanks,
              • DanielWagemann
                DanielWagemann
                849 Posts
                ACCEPTED ANSWER

                Re: How to hide the subtotal

                ‏2013-02-13T21:30:57Z  in response to SystemAdmin
                I will see if I can find my sample spec for this and actually post it. Now that the forum allows attachments again. It won't be until tomorrow though.
              • DanielWagemann
                DanielWagemann
                849 Posts
                ACCEPTED ANSWER

                Re: How to hide the subtotal

                ‏2013-02-13T22:22:02Z  in response to SystemAdmin
                It took a minor adjustment but the approach still works .... see attached pls
                • SystemAdmin
                  SystemAdmin
                  1959 Posts
                  ACCEPTED ANSWER

                  Re: How to hide the subtotal

                  ‏2013-02-14T17:52:01Z  in response to DanielWagemann
                  Thanks Daniel. Excellent work. It works like a charm.
                  I really don't think I could of solve this issue with out ur help.

                  Thanks for ur help and the valuable time.

                  Winson.