Satoshi's Data Labo            
Development Memo

How to output report with Serial Number (by PHPRunner)

This is a sample database system, in which I output simple query result report with Serial Number. 

  1. Prepare Two Tables and One Report

    /REP01.png


  2. Modify SQL of Report
    " 0 As Rank "


    /REP02.png


  3. Switch on "Show Global Summary"

    /REP03.png


  4. Set Custom View Property to Rank Field
    $_SESSION["Rank"] += 1;
    $value = $_SESSION["Rank"];


    /REP04.png


  5. Modify Design of Report

    /REP05.png


  6. Add Event Code
    $_SESSION["Rank"]=0;


    /REP06.png


  7. Main Menu

    /REP07.png


  8. Report with Serial Number

    /REP08.png


Copyright © 2017 Satoshi Ashikari All Rights Reserved.