<?xml version="1.0" encoding="UTF-8" ?>
<jsp:root
	xmlns:jsp="http://java.sun.com/JSP/Page"
	xmlns:og="hybs-taglib.tld" 
	version="2.0">
<jsp:directive.page language="java" contentType="text/html; charset=UTF-8" />

<og:head headType="result" />
<jsp:directive.include file="/jsp/custom/result_info.jsp" />
<og:comment
	system	= "GF:エンジンサンプル"
	pgid	= "GF6210"
	title	= "レポート出力(Calc)"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>

<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
		select * from GF41
	<og:where>
		<og:and value = "SYSTEM_ID  = '{@SYSTEM_ID}'" />
		<og:and value = "FGJ        = '1'"            />
	</og:where>
		order by SYSTEM_ID,CLM,KBSAKU,LANG
</og:query>

<og:report2
	fileURL          = "{@MODELDIR}"
	listId           = "{@LISTID}"
	outFileURL       = "{@OUTDIR}"
	outFilename      = "{@OUTFILE}"
	headerKeys       = "HKEY1,HKEY2,HKEY3,HKEY4,HKEY5"
	headerVals       = "{@HKEY1},{@HKEY2},{@HKEY3},{@HKEY4},{@HKEY5}"
	footerKeys       = "FKEY1,FKEY2,FKEY3,FKEY4,FKEY5"
	footerVals       = "{@FKEY1},{@FKEY2},{@FKEY3},{@FKEY4},{@FKEY5}"
	pageEndCut       = "{@pageEndCut}"
	useLocalResource = "{@useLocalResource}"
	fgrun            = "{@FGRUN}"
	printerName      = "{@PRTNM}"
	debug            = "{@debug}"
/>

<og:forward page="{@SYS.JSP}/fileDownload" keys="file" vals="{@OUTDIR}/{@OUTFILE}" useRedirect="true" />

<jsp:directive.include file="/jsp/common/htmlend.jsp" />
</jsp:root>
