Skip to Content
avatar image
Former Member

Hiding Row in Webi Report

hi,

How to Hide the rows in a webi report?

Sample output --

Login 01/02/2010/10:45:50

Modified Record 01/02/2010 10:45:50

Modified Record 01/02/2010 10:46:50

Delete Record 01/02/2010 10:55:50

Delete Record 01/02/2010 10:56:50

Modified Record 01/02/2010 10:58:50

Delete Record 01/02/2010 10:59:50

*Required Output*

Login 01/02/2010/10:45:50

Modified Record 01/02/2010 10:45:50

Delete Record 01/02/2010 10:55:50

Modified Record 01/02/2010 10:58:50

Delete Record 01/02/2010 10:59:50

I used a condition in a variable =if(Previous([Activity])=[Activity];0;1) and placing inside report.

But when i am giving block filter i am getting only the distinct activity and Time not as required output.

Please help...

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 20, 2010 at 06:52 AM

    Hi Sathish,

    I am not 100% clear on what you are trying to do but you should be able to use a max() or min() function on the datetime, since it appears you are trying to get the first one (in which case you should use min()).

    Does that help?

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 20, 2010 at 10:28 PM

    The approch should work, make sure to use formula on each column, like

    =If([State]=Previous([State]);"";Min([City]))

    Add comment
    10|10000 characters needed characters exceeded