Hiding Report Header Section — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Hiding Report Header Section

Received Response
135
Views
4
Comments
Saro
Saro Rank 5 - Community Champion

Hi friends,

I have the report with no column headings like below

image_setup.PNG

Is it possible to hide the empty column heading space row header @ the top of the report so that my report will look like below

image_setup2.PNG

Thanks in advance.

Regards,

Saro

Answers

  • Hi,

    In the properties of your table view you have setting for that.

    Set it to "Column Labels" = OFF.

    Capture.PNG

  • Saro
    Saro Rank 5 - Community Champion

    Gianni, thanks ;-)

    But the thing is mainly, i do want to hide the column labels because i want to export that report to CSV format in which the column labels on is creating an unnecessary comma @ the top of the first row while exporting like below

    ,,<-----------------comma created due to header
    TPT,4125
    TPT,27725
    

    So i thought, if i do hide the column header like you said of column labels to be off, then the column header is hiding in the report but while exporting the same report in the csv then again it is forming the comma @ the start like below:-(

    ,,
    TPT,4125
    TPT,27725
    

    Is there any other workaround for this to exclude the heading comma while exporting into CSV.

    Thanks,

    Regards,

    Saro

  • Hi,

    Can't export in Excel ?

    Because CSV is into the "data" group of export options, and these formats doesn't export the visualization you define in the "Results" tab of your analysis but export the content of your "Criteria" tab.

    If you add in "Criteria" 5 columns to your analysis but in the "Results" tab you define a table view with just 2 columns and 3 of them as excluded, when you export in Excel you will export a table with 2 columns, when you export in CSV you will get 5 columns.

    CSV export the content of the Criteria and there it's impossible to remove column headings as columns must have a name (even if you put an empty text as name it's still a name).

  • Saro
    Saro Rank 5 - Community Champion

    Thanks Gianni, for the explanation:-)