Skip to Content
avatar image
Former Member

Hide text NOT_EXIST in a crosstab

Hi,

We use BPC embedded with Design Studio and short comment solution. In some cases, Overall total of column "Comments" shows NO_RESULT. We would like then to show an empty cell.

We use a crosstab component.

I tried the following css code that works with a spreadsheet component :

.sapzencrosstab-DataArea > tbody > tr >td [title="NOT_EXIST"] {

font-size: 0px!important;

}

Unfortunately this code doesn't work with a crosstab component (I checked and title="" in this component).

Have you an idea to do this in crosstab ?

thanks

Mat

Add comment
10|10000 characters needed characters exceeded

  • Mat - I'm not familiar with BPC

    Does it use a BEx query? Why would there be a totals column for comments?

    Which version of Design Studio are you using?

    Could you upload a screen shot?

  • Get RSS Feed

5 Answers

  • Mar 14, 2017 at 09:45 AM

    Hi,

    For Crosstab component we have separete CSS class name to check LastRow and LastColumn Total for particular datacell. please find the below css code, which will help out your requirement.

    Please more information, Please check this link http://www.clariba.com/blog/designstudiocrosstabcomponent

    .sapzencrosstab-DataCellTotal, .sapzencrosstab-HeaderCellTotal {
        font-size: 0px !important;
        font-weight: bold;
    }
    
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 14, 2017 at 10:58 AM

    thanks !!!

    Your solution works fine but hide total for all columns. I only want to hide totals (NOT_EXIST) of the comment column because it is a non sense to have a total for text. Of course I want to keep totals for keyfigure columns. If you have an idea...

    Mat

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 14, 2017 at 11:30 AM

    here is what we would like to obtain


    Add comment
    10|10000 characters needed characters exceeded

    • Please try this code,

      .sapzencrosstab-DataCellLastInCol {
          font-size: 0px !important;
       }

      Note: this is for Last Column text to hide. Kindly rearrange your comment column at last in your crosstab and check.

      Regards,

      Vidhya.C

  • avatar image
    Former Member
    Mar 14, 2017 at 12:21 PM

    it didn't work unfortunately. It only hides overall result not intermediary result.

    thanks for your help

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 23, 2017 at 04:19 PM

    Dear Fralti,

    do you have a solution in the meantime for this problem? I am facing the same issue.

    I have already tried to create an exception in the query to get a new CSS-Class to capture the text, but without success.

    Thanks in advance,

    Regards,
    Chris

    Add comment
    10|10000 characters needed characters exceeded