posts - 84, comments - 54, trackbacks - 0, articles - 0
             :: 首頁 :: 新隨筆 :: 聯系 :: 聚合  :: 管理

          How to conditionally hide rows in Cognos report?

          Posted on 2007-08-07 17:23 馬達+斯加 閱讀(491) 評論(0)  編輯  收藏 所屬分類: Java Report


          Data

          Estate

          Block

          Customer

          Status

          ALC

          1

          AAA

           

          ALC

          1

          BBB

          Settle

          ALC

          1

          CCC

           

          ALC

          2

          DDD

          Settle

          ALC

          2

          EEE

           

          RequirementCount records by estate, block, hide customer with status = ‘Settle’ when display.

          Estate

          Block

          Customer

          Status

          ALC

          1

          AAA

           

          ALC

          1

          CCC

           

          Settled case:

          1

           

           

          Total case:

          3

           

           

          ALC

          2

          EEE

           

          Settled case:

          1

           

           

          Total case:

          2

           

           

           

          It is a piece of cake that implementing this report in Crystal report, but it spent me much time in Cognos ReportNet—I can’t find out how to hide a whole row.

          At first, I have tried to control visibility of the fields with conditional variable. But, there still existed a blank row though all the fields were hidden.

          Estate

          Block

          Customer

          Status

          ALC

          1

          AAA

           

          ALC

          1

          CCC

           

           

           

           

           

          Settled case:

          1

           

           

          Total case:

          3

           

           

          ALC

          2

          EEE

           

           

           

           

           

          Settled case:

          1

           

           

          Total case:

          2

           

           

          Another way I have tried is wrapping all fields with conditional block. The blank rows were still there, just with smaller height.

           

          Finally, I gave up finding out which option could be used to hide the whole row. I have amended the SQL with COUNT(…) OVER (PARTITION BY …):

          SELECT estate, block, customer, status, count(customer) over (partition by estate, block) as totalCase FROM table ORDER BY estate, block.

          The retrieved data with the amended SQL:

          Estate

          Block

          Customer

          Status

          totalCase

          ALC

          1

          AAA

           

          3

          ALC

          1

          BBB

          Settle

          3

          ALC

          1

          CCC

           

          3

          ALC

          2

          DDD

          Settle

          2

          ALC

          2

          EEE

           

          2

          In the last step, A filter was added to the details in the report: status <> ‘Settle’, and the calculation of grouping area ‘Total Case’ was set to Average.

           

          主站蜘蛛池模板: 兰溪市| 肃南| 敦煌市| 郯城县| 临西县| 乐都县| 泰州市| 洛阳市| 肇州县| 湘潭县| 湄潭县| 青河县| 偃师市| 寿光市| 崇仁县| 东山县| 临夏县| 五常市| 义马市| 台湾省| 井陉县| 同仁县| 雷山县| 勃利县| 巴马| 西昌市| 石城县| 津南区| 田林县| 彭水| 大悟县| 阜宁县| 保靖县| 泗阳县| 稻城县| 宜川县| 南靖县| 原阳县| 仪陇县| 芒康县| 唐山市|