Hi guys.. Can I ask u something, I have this problem on creating report with this layout below :
old layout no | format tape | durasi | begining stock | total recd | total out | final stock | department IT Acounting HRD -------------------------------------------------------------------------------------------------------------------------------------------------- 1 CDR 10 100 0 0 0 0 0 0 0 2 15 150 5 1 4 1 0 0 0 3 CDRW 5 50 3 2 1 1 0 1 0 4 DIGITAL 195 100 7 5 2 0 3 2 0 I wan those layout becoming like this one no | format tape | durasi | begining stock | total recd | total out | | department final stock IT Acounting HRD -------------------------------------------------------------------------------------------------------------------------------------------------- 1 CDR 10 100 0 0 0 0 0 0 0 2 15 150 5 1 1 0 0 0 4 3 CDRW 5 50 3 2 1 0 1 0 1 4 DIGITAL 195 100 7 5 0 3 2 0 2 TAPE_TYPE VARCHAR2(6), TAPEF_CODE VARCHAR2(10), ARR_DATE DATE, QUANTITY NUMBER(7), CODE1 NUMBER(7), CODE2 NUMBER(7), UPDATE_USER VARCHAR2(10) NOT NULL, UPDATE_DATE DATE NOT NULL, ROW_ID VARCHAR2(18) NOT NULL, REMARKS VARCHAR2(254), PO_NUM VARCHAR2(40), TEMP_ARR_DATE VARCHAR2(20), TAPE_TYPE_NAME VARCHAR2(20), STATUS_DONE VARCHAR2(2), COST_PER_TAPE NUMBER(15,2), TAPET_DURATION VARCHAR2(8), NUM1 NUMBER, UPLD_SEQ NUMBER thanks Before, Iwan Setiawan e-mail : [EMAIL PROTECTED] Yahoo mesengger : setiawanthea [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/NhFolB/TM --------------------------------------------------------------------~-> ----------------------------------------------- INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT ----------------------------------------------- IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
