1. 

   Mark Tetrode, Member

   Hi

   I am doing server side pagination and got it to work, only the result is not so pretty.

   My SQL

   
   
   select inOffset - inLimit into inOffset;
   
   select 'dbr.report', 'sp_DBR_call_data_pivot2', 'inUserId=(inUserId)', 'inDateStart=(inDateStart)', 'inDateEnd=(inDateEnd)', 'inProvince=(inProvince)', 'inLimit=(inLimit)', 'inOffset=inOffset', '"Previous Page"';
   
   select 'dbr.hidecolumns', 'inOffset';
   
   select ceil(inOffset/inLimit) as 'Previous Page', inOffset;
   
   select inOffset + inLimit into inOffset;
   
   select ceil(inOffset/inLimit) as 'Current Page';
   
   select inOffset + inLimit into inOffset;
   
   select 'dbr.report', 'sp_DBR_call_data_pivot2', 'inUserId=(inUserId)', 'inDateStart=(inDateStart)', 'inDateEnd=(inDateEnd)', 'inProvince=(inProvince)', 'inLimit=(inLimit)', 'inOffset=inOffset', '"Next Page"';
   
   select 'dbr.hidecolumns', 'inOffset';
   
   select ceil(inOffset/inLimit) as 'Next Page', inOffset;
   
   

   The result is
   

   I have experimented with select dbr.keepwithnext, 100; but this gives errors, no matter where I put it.

   Also I would like to change the drillimage (the arrow) and if possible, prevent the popup.

   Who else as already made something?
2. 

   myDBR Team, Key Master

   For complete control over how your pager would look like and behave, your can use a template. See a demo.

   --
   myDBR Team

Reply

You must log in to post.