Skip to Content

How to display the second record in webi report

Hi Friends,

Recently we are facing issue with displaying the 2 nd record in webi report based on the particular code.

    

      CODE                    DATE                   REVENUE

In the above Image 1st column has code we have to display only 2nd record for each coce

like

MJ-11     01-Jan-2014     14554.4

MJ-19     01-jul-2015        8986.4

MJ-31     24-JUN-2015     6916.9  ect

Any one of you please help me on this....

Regards,

Ramki.

webi.JPG (48.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 04, 2015 at 11:19 AM

    Hello Ramki,

    I have a solution for your requirement,  I did used in one of my projects.

    For this example to illustrate.  I have a sample report that i created using your example dataset.

    I created a variable to show like below:  Running count on Code, Reset the count by every new Code.

    Result: Running count gets reset and starts again on every new code.

    Final Step:  Put a Block Filter to show only Running Count Equals to 2.

    Hope this helps.

    Warm Regards,

    Manohar Singh


    Sample report.PNG (16.1 kB)
    Variable.png (5.8 kB)
    Result.png (20.1 kB)
    Final Step.png (7.1 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2015 at 04:51 AM

    Ramki..

    Explain Bit Clearly..

    U want to restrict bu not showing the 2nd record?

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 04, 2015 at 10:31 AM

    All the answers are questions ... mine too: what is the sorting/ordering criteria on the data? What makes a record to be the second, please?

    Anyway, you have no chance to filter based on position, as your filter would impact the position ... you have to filter based on a criteria such as :

    the oldest, the biggest ...

    Add comment
    10|10000 characters needed characters exceeded