Post reply

Record Number Crystal Vs SSRS

  • February 25, 2009 at 5:07 am

    #384011

    Hi All,

    I want to created Calculated Field Recnum

    with same logic as in Crystal as below:-

    @recnum : totext(recordnumber,0) + ":"

    in SSRS i m taking RowNumber("ContainerName")

    If i put it static it works.

    It is not working in case if i take it as Caclulated Field.

    Thanks in advance.

    Regards,

    Chirag

  • February 26, 2009 at 7:57 am

    #950609

    You cannot get row num as a calc field in the data set because at this stage data set does not have the record. It is available only when rendering.

    If it is possible to generate row num at the query, try this http://support.microsoft.com/kb/186133 or just google to add row nums to the query. It will be available to you in the data set.

    View Siva Gurusamy's profile on LinkedIn

    "Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation

Viewing 2 posts - 1 through 1 (of 1 total)

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