Post reply

limit rows without out multiple sheets

  • February 2, 2012 at 2:59 am

    #391461

    hi experts,

    i have limited the records per page with following code

    =Ceiling((RowNumber(Nothing))/50)

    but when exported to excel data comes in multiple sheets. how to achieve data in single sheet when exported to excel by limiting the records..

  • February 2, 2012 at 5:58 pm

    #1442165

    Sounds like you have a page break somewhere

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]

  • February 3, 2012 at 3:35 am

    #1442263

    yes to limit the records per page we have to use page brake property.. is there any other way to limit the records per page at report level with out using page brake

  • February 6, 2012 at 12:31 am

    #1442910

    hello experts ....

    is there any way to limit records per page at report level and whn we export to excel it should come in single sheet

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

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