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:
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,