Skip to Content
0

Hide text NOT_EXIST in a crosstab

Mar 14, 2017 at 06:41 AM

95

avatar image
Former Member

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

10 |10000 characters needed characters left 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?

0
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Vidhya V Mar 14, 2017 at 09:45 AM
0

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;
}

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 14, 2017 at 10:58 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Can you send me the screen shot? What you excepting.

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

here is what we would like to obtain



design.png (30.3 kB)
Show 1 Share
10 |10000 characters needed characters left 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

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

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

thanks for your help

Share
10 |10000 characters needed characters left characters exceeded
Christian Hauswald Nov 23, 2017 at 04:19 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded