Post reply

Finding equivalent of Crystal's Next function in Reporting Svcs

  • May 26, 2008 at 5:28 am

    #190997

    Hii,

    Can anyone tell me how to find the next instance of a field in reporting services. I know it can be done in rpt using the Next FUNCTION but in rdl I am yet to find its equivalent. Thanks in advance :)

    -Meghna

  • May 27, 2008 at 2:15 am

    #820402

    Hii Meghna,

    There is no way we can find Next record in reporting svcs.

  • May 27, 2008 at 7:40 am

    #820558

    What were you trying to do?

  • May 27, 2008 at 10:33 pm

    #820957

    Actually i m doing migration frm crystal to SSRS so i cannot modify the stored proc , i need the function or some way to get the nxt value of the field which i pass frm the front end.

    have u done this , or can u give me logic of hw its possible?

    In SSRS , there is no inbuilt NEXT function as in crystal report.

    Any help will be highly appreciated!

    -Meghna

  • May 29, 2008 at 11:23 am

    #821886

    if you can invert your logic, you can use Previous() to find a value from the prior row.

    row 41, person=john: Crystal's next( person ) returns 'sally'

    row 42, person=sally: SSRS' previous( person ) returns 'john'

  • May 29, 2008 at 10:30 pm

    #822094

    No, i want the next row of the current field, can u tell me how to implement this?

  • July 11, 2008 at 4:23 pm

    #841884

    Hi Meghana,

    I am also trying to find the next function in RS. Have you found any alternatives?

    Thanks.

  • July 13, 2008 at 10:52 pm

    #842185

    Yes i got the solution from my colleague , wait will ask him and post you quickly.

    Thanks

    -Meghna

  • July 30, 2008 at 3:46 pm

    #850896

    Hey, I'm having the same question/problem. Have you come up with a solution?

  • July 30, 2008 at 11:15 pm

    #850989

    I am yet to hear the solution from Meghna.

  • March 4, 2009 at 12:18 am

    #952893

    Hi Ravi,

    Did you have any information regarding NEXT function? If yes, then please send ASAP.

    Thanks,

    Hemant

  • March 24, 2009 at 5:39 am

    #965076

    Hi Meghna,

    Whether you got solution for this issue, Please reply ASAP

    Regards,

    Poorni

  • March 24, 2009 at 5:49 pm

    #965737

    Hi Hemant,

    Send me an email on ravitalele@yahoo.com.

    Ravi

  • March 24, 2009 at 11:19 pm

    #965792

    HERE WE GO!!

    BELOW IS THE ATTACHED XML CODE OF RDL WHICH IMPLEMENTS ABOVE

    THANKS

  • September 7, 2009 at 7:55 pm

    #1050271

    Although it is not a technical solution, but may work for you;-)

    1- Sort your data set vise versa (i.e. if it is sorted by PK descending, then sort it by PK ascending and vise versa)

    2- Use Previous function.

    :hehe:

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply