Announcement

Collapse
No announcement yet.

Pagination based on group

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Pagination based on group

    Hi All,
    My goal is to have an output based on a group of records with each group having it's own page. Page groups can be anywhere from 1 to several dozen records. As I am not fluent in either php or sc any assistance would be greatly appreciated.
    Below is the SQL statement that seems to get me in the ballpark:

    Code:
    select  prtnum_01, PMDES2_01, DELSTK_01, SUBSTRING(DELSTK_01,1,1) as Dept, SUBSTRING(DELSTK_01,2,2) as shelf from part_master
    where DELSTK_01 not in ('WIP-SPCL','WIP-FRM ','WIP-DR','WIP-BOX','STORAGE','OFFICE','NOLOC','')
    order by  Dept, shelf
    Thanks,
    Last edited by onyxtacular; 04-15-2016, 08:42 AM.
    HA! We're all just a little crazy.
Working...
X