<%-- title : graph1.jsp Copyright (c) Avman Systems, Inc. All rights reserved Update Log 10/12/02 ajay & nand chamges --%><%@ taglib prefix="RR" uri="RRSupport.tld" %> <% String datasrc = (String) session.getAttribute("datasrc"); String rptid = request.getParameter("rptid"); String graphid = request.getParameter("graphid"); %> SELECT graphid, rptid, graphtitle, valuerptfldid, namerptfldid, graphtype, graphorient, showlegend, backgroundcolor, comments, Sumvaluefld, sortfldid, blocksize, graphsize, rowspace, showitems, showvalue, pieHeight, piewidth, num1 as func, num2 as valuefield2, text1 as func2, num3 as valuefield3, num4 as func3 From graphinf where graphid = <%=graphid%> SELECT RPTFLDS.RPTFLDID, RPTFLDS.FLDDESC FROM RPTFLDS where rptid = <%=rptid%> SELECT s.rptfldid as sortfldid, f.flddesc as sortflddesc FROM sortinfo s, rptflds r, fldinfo f where s.printtot =1 and s.rptfldid = r.rptfldid and r.rptid = <%=rptid%> and f.fldid = r.fldid SELECT dbtables.Tbltype as tbltype FROM dbtables, tblinfo, rpttbl WHERE tblinfo.dbtid=dbtables.dbtid and tblinfo.tblid = rpttbl.tblid and rpttbl.rptid = <%=rptid%>

Create/Modify Graph <%String selected=""; if (graphname.getInt("valuerptfldid") <= 0) selected = "selected"; String selected2=""; if (graphname.getInt("valuefield2") <= 0) selected2 = "selected"; String selected3=""; if (graphname.getInt("valuefield3") <= 0) selected3 = "selected"; %> <% if(GetSourceType.Field("tbltype").equalsIgnoreCase("Query")) { %> <%--<% String sumvalueyn = "0"; %> <% String sortlvlField = "0"; %>--%> <% } else { %> <% if(GetSortFlds.RecordCount > 0) {%> <% } else { %> <% } %> <% } %>

Graph Name:
Notes:	<%= graphname.Field("comments")%>
Name Source Column (Category):
Data Source Column (Range):	>Count of Records	Function :	<%out.flush();%>
Additional Data (Optional):	>(Skip this field) >Count of Records	Function :	<%out.flush();%>
Additional Data (Optional):	>(Skip this field) >Count of Records	Function :	<%out.flush();%>
Sum of Data Column:	<% if( graphname.Field("sumvaluefld").equals("1")) { %> <% } else { %> <% } %>
[Check box, only if the values of data column are to be totalled in the graph]
Sum Sort Field :
[Sort column at which the totals of data column is to be calculated.]
Graph Type:	<%out.flush();%> <%----%> <% if (graphname.Field("graphtype").equalsIgnoreCase("Piechart")) {%>      <% } else { %> <% } %>

<% if (!graphid.equals("0")) { %> <% } %> <% graphname.close(); LstReportFields.close(); GetSortFlds.close(); GetSourceType.close(); %> <%-- --%>

<%-- <% if (graphid.equals("0")) { %> <% } else { %> <% } %> --%>