• Hi,

    Thanks for the reply.

    I have achieved that by storing the result into temp table and then assigning that field value to the attribute/control on the report which will work as a page number like =Field!SrNo.Value & ' of ' & Field!SrNo.Value

    But the new requirement is if viewer shows 5 pages and while exporting to PDF if the page gets increased then for ex. for 3rd record it splits the page in to two. so the idea is to show like 1 of 2 next page 2 of 2 ; even though the pdf document has 7 or any number of pages but for individual record if the page gets split then it should work as per example I mentioned.

    Is there any trick or provision in SSRS?

    Thanks.

    Gunjan.