Sql Reporting Service

  • Hi,

    I Need to generate a report by keeping one background image and Assign the values at Particular Place Holders.Based on the Number of Rows i need to break the Page.Per Page it should be 20.The remaining Rows i have to show in another Page.

    I tried with Ceiling(rowNumber(nothing)/20).But it is showing an error " Rownumber should not be used for sorting")

    Any Suggestions

    Thanks in Advance

  • Add a CInt() around the expression. Also, are you putting the expression in the correct place? See:

    Books Online: Expression Examples - Page Breaks

    K. Brian Kelley
    @kbriankelley

  • Hi, Thanks for your Suggestion.

    That problem got solved.I done it by breaking the image into 3 Parts.One image in page Header one image in page footer and one image in Body.

    Is there any better way of doing this one.

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

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