Forum Stats

  • 3,826,787 Users
  • 2,260,707 Discussions
  • 7,897,072 Comments

Discussions

crosstab report

User_IPZH9
User_IPZH9 Member Posts: 59 Blue Ribbon
edited Mar 27, 2019 4:36PM in Discoverer

How to removed or hide a column in cross tab report.

The column is not needed only one of the distinct value as a columnn in needed.

Report is showing with correct values in differnt  columns. But need only one of them and hide rest of them

thanks

Answers

  • sbeck-Oracle
    sbeck-Oracle Member Posts: 116 Employee
    edited Mar 27, 2019 6:30AM

    Hello,

    Not exactly sure what you are trying to accomplish.  I believe if there are multiple rows with the same value, you wish to see only one row. The only way to show a single value, is to use a Group Sort, which allows you to hide duplicates.  This may well change the dynamic of the worksheet (results), so be sure the data is what you need.

    Premier support for Discoverer 11g ended June 2014.  Version 11.1.1.7.0 is the final / terminal release of the Discoverer product.

    Discoverer is at end of life. At this point new content should not be created as it makes one more document/report to be manually converted to Discoverer's replacement.

    Regards,

    Sharon

  • mrigg
    mrigg Member Posts: 98 Blue Ribbon
    edited Mar 27, 2019 7:53AM

    Possibly you're looking for the inline/outline option (in Tools/Options/Crosstab)?

  • User_IPZH9
    User_IPZH9 Member Posts: 59 Blue Ribbon
    edited Mar 27, 2019 4:36PM

    CrossTab_colums.JPG

    In the image uploaded, how to hide the columns highlighted in red line. Just need only one column next to it in this section.

    All the remaining section left side is fine.

    Should it be handled in the query (Admin) or can it be managed in the layout (Desktop)

    ie.

    Usage Rate or Amount SUM

           Resource     

               Labor

    thanks for your inputs.