cancel
Showing results for 
Search instead for 
Did you mean: 

How to hide a empty row in a crosstab

Former Member
0 Kudos

Hi,

I am creating a web i report based on Bex Query , The following cross tab  as shown in attached pic is showing one more extra row , which i am not delete or hide , kindly let me know any way to hide a extra row in the cross tab

Thanks ,

Charu

Accepted Solutions (0)

Answers (2)

Answers (2)

sateesh_kumar1
Active Contributor
0 Kudos

Hi ,

Check by any chance Break is applied on any of the object . It may be a footer row !! .

or

you could replace any constant with null in the object and filter that constant out on block .

if (isnull([object])) then * else [object] or use trim() to find if any leading spaces causing the issue .

Thanks

Former Member
0 Kudos

Thanks Sateesh I managed to generate * values in place of null as shown in screenshot but when I try to apply filter or conditional formatting I get " Unable to get first page of report error"

any thoughts pls?

sateesh_kumar1
Active Contributor
0 Kudos

Then something wrong with the calculations defined / table format .

try deleting one by one variable , make sure you have formulas copied to notepad .

Thank you.

amitrathi239
Active Contributor
0 Kudos

Right click on the ERA value object and apply filter where is not null...

Former Member
0 Kudos

Thanks but it did not work, It gives error"Unable to get the first page of the report"

amitrathi239
Active Contributor
0 Kudos

Try to add same filter in webi query and see

Former Member
0 Kudos

I am sorry  but could not undertand as value in the body is report variable , I can apply filter on it or  on the block , can u please explain

amitrathi239
Active Contributor
0 Kudos

If this variable then apply block level filter..

Former Member
0 Kudos

Thanks Amit ,  but applying the block level filter gives me this error

Unable to get the first page of report WIJ20003

amitrathi239
Active Contributor
0 Kudos

What is your variable in formula?

Former Member
0 Kudos

Hi Amit,

The formula of the variable is runningsum((sales quantity);row);[material group]

Where Material Group is the reset dimension

Thanks,

Charu