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


  2. Modify SQL of Report
    " 0 As Rank "


  3. Switch on "Show Global Summary"


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


  5. Modify Design of Report


  6. Add Event Code


  7. Main Menu


  8. Report with Serial Number


Copyright © 2017 Satoshi Ashikari All Rights Reserved.