This allows you to specify an username. If you generate an URL in Organizer and elect to use an user, the username will be encoded in the generated URL. You can also specify the username as plain text.

&USERNAME=user
                    

This allows you to specify the user password. If you generate an URL in Organizer and elect to use an user, the password will be encoded in the generated URL. The password can also be specified using plain text.

&PASS=password
                    

This allows you to have the server read the username and password from the session. If this option is enabled the information will be retrieved from session parameters USERNAME and PASS. This option is only available if you will be deploying the URL within a servlet or JSP application.

&USESESSION=true
                    

This allows you to specify the location (context) of the ERES installation. This location is used when the URL re-directs to the login page. The default value is /ERES, and the URL will work without setting this parameter in most deployments. You only need to specify this parameter if ERES is deployed in a context of a different name.

&JSPCONTEXT=/MyReports
                    

This allows you to specify the .tpl or template file that you would like to use to create the chart. Because the .tpl format is saved without data, you can specify different data when using templates. If you do not specify different data ERES will try to reload data from the template's original source.

&TemplatePath=http://machinename:port/ChartFiles/templatefile.tpl
                      

If USERNAME and PASSWORD is not provided, a login screen will appear prompting for one. If the user provided does not have permission for the template, a chart will not appear.

	Note
	You can use both absolute and relative paths for the template file location.

This allows you to specify the .cht or chart file that you would like to use to create the chart. Because the .cht file is saved with the chart data, you cannot specify different data when using chart files.

&ChartPath=http://machinename:port/ChartFiles/chartfile.cht
                      

	Note
	You can use both absolute and relative paths for the chart file location. If either a chart or template file is specified in the URL, then a login is required to access the file.

This allows you to specify a data file that will be used to plot the chart, either text or XML. For more on data file specifications, please see Section 2.4.5 - Data from Text Files.

&DataFilePath=http://machinename:port/chartdata.txt
                      

	Note
	You can use both absolute and relative paths (relative to ERES installation directory) for the data file location. From XML files you can use only those, that are in Quadbase format ( please see Section 2.4.4 - Data from XML and XBRL Files).

This allows you to specify a class file that will retrieve data to plot the chart. For more on using class files please see Section 2.4.6 - Data from Class Files.

&DataSourceClass=package.class
                      

This allows you to specify a database and SQL query to be used to retrieve chart data. The parameter takes five input values: database URL, database driver, username, password, and query. Each input value is separated by a semi-colon. For more on connecting to a database, please see Section 2.4.3 - Data from a Database.

&DBSourceInfo=url;driver;username;password;query
                      

If you do not wish to enter an username or password use the space character “+” instead. Do not drop the input value. The parameter will not run with insufficient inputs. In your SQL statement be sure to substitute the “+” character for any spaces. Also, substitute the word equal or equals for the “=” sign.

This parameter is used if the chart or template file you're using contains a parameterized query. QueryParamName specifies the name of the query parameter you will be supplying a value for. (Parameter names are assigned when you initialize a query parameter. For more on this, see Section 2.4.3.2.2 - Parameterized Queries) It is always followed by the QueryParamSize, and the QueryParamValue parameter.

	Caution
	You must specify all query parameters (or none of them), else your chart will not be displayed.

&QueryParamName=customerID&QueryParamSize=1&QueryParamValue=4
                      

This parameter is used to specify the number of values that will be passed into a particular chart parameter. As detailed in Section 2.4.3.2.2.1 - Multi-Value Parameters, some queries can have multi-value parameters. This URL parameter allows you to specify if the parameter (indicated by the previous QueryParamName parameter) takes multiple values. This parameter is always followed by one or more QueryParamValue arguments for each of the paramater values for a particular parameter. If you do not specify this parameter then it will assume that the number of values to be passed in is one.

This parameter is used if the chart or template file you're using contains a parameterized query. QueryParamValue specifies the value that you would like to pass to the query parameter specified by the QueryParamName argument. For multi-value parameters a separate QueryParamValue argument must be supplied for each distinct parameter value that you're passing in. For more on creating parameterized charts, please see Section 2.4.3.2.2 - Parameterized Queries.

If you have specified a data source for the generated chart, this argument allows you to map columns from your data file, or database query result set to the chart. Column mapping is specified using index values. Index values are assigned based on the order they appear in your data file from left to right, or the order in which they are selected in your SQL statement. Index values start with 0, so the first column is 0 and the second is 1, etc. To perform column mapping, specify the column index for the respective axes for the chart. If you do not want to map one of the axes use the value -1. Do not leave it blank. Mapping varies for different chart types.

	Caution
	You must specify this parameter along with DataFilePath parameter for proper chart generation.

For Scatter, Surface, and Bubble Charts:

&ColumnMapping=series;xvalue;yvalue;zvalue;subValue
                      

For High-Low, and HLCO Charts:

&ColumnMapping=series;category;high;low;open;close;subValue
                      

For Gantt Charts:

&ColumnMapping=series;category;end;start;-1;-1;subValue
                      

For all other chart types:

&ColumnMapping=series;category;sumby;value;subValue
                      

For more detailed information about column mapping for all chart types, please see Section 3.13.1 - Data Mapping.

This is a Boolean flag that denotes whether the data is to be transposed or not. It is followed by the SelectTranspose parameter which dictates which columns to transpose. By default this is false.

&TransposeData=true
                      

This allows you to specify the columns that you would like to transpose. To select columns, specify the column indices separated by a semi-colon. If you do not specify any columns then all of them will be transposed.

&SelectTranspose=ColumnIndex;ColumnIndex…
                      

For an explanation of how data transposition works, please see Section 2.4.2.1.1 - Transposing Data.

This parameter allows you to supply data for the chart within the URL string. The ChartData parameter specifies the data points and series for the chart. It is generally used in conjunction with the CategoryName parameter which specifies the individual category names for the data points, and the DataType parameter which specifies that data type for your chart data. Stack-type charts with a sum by value, can have the sum by names specified using the SumbyName parameter.

The structure of the ChartData parameter is a series name followed by data points. Each series is separated by the | character, and each data point is separated with a semi-colon. For chart types that require more than one value per data point, the sub-values are separated by a comma. The following examples illustrate how the ChartData parameter is used for various chart types.

For Column, Bar, Area, Line, Pie, and Dial charts, the structure resembles the following:

&ChartData=seriesA;5;3;2|seriesB;2;5;8|seriesC;1;2;3
&CategoryName=morning;afternoon;night&DataType=integer
                      

This generates a chart that has three series, seriesA, seriesB, and seriesC. The chart also has three integer data points, morning, afternoon, and night within each of the series.

For Stack Column Stack Bar, Stack Area, and Percent Column charts the SumbyName parameter has to be specified in addition to the CategoryName and DataType parameters. The structure for these charts resembles the following:

&ChartData=storeA;1,3,5,3;2,5,9,10|storeB;2,6,2,8;3,7,6,8
&CategoryName=weekday;weekend&SumbyName=deli;drinks;bread;cookies
&DataType=integer
                      

This generates a chart with two series, storeA, and storeB, which have two respective points. The individual data points have four sum by segments separated by a comma.

For Bubble, Scatter and Surface Charts, the ChartData parameter value structure is similar to that of the Stack-type charts, however, rather than using the CategoryName parameter for the categories, it uses CategoryLength, an integer value that specifies the maximum length of the series. The structure resembles the following:

&ChartData=groupA;2,5,3;4,6,1;1,6,8;8,9,2|
groupB;1,9,4;7,4,3;9,2,6;2,1,2&CategoryLength=4&DataType=integer
                      

For Surface charts, there are some additional restrictions. First, surface charts cannot contain more than one series. Second, each data point must be of the format x,z,y, the x and z values signify the position on the horizontal plane, while the y value determines the height. And finally, every unique x value must be paired with every unique z value, for example the following is an acceptable data set

0,1,5;
0,2,6;
0,3,5;
1,1,5;
1,2,6;
1,3,5
                      

Every unique x value (0 and 1) were paired with every unique z value (1, 2 and 3). While the following data set is not acceptable

0,1,2;
0,2,4;
0,3,2;
1,1,2;
1,3,2
                      

because when x = 1, there is no corresponding z value which equals 2. Also note that there is no restriction on the y value. It is not necessary to use the CategoryLength parameter since there can only be one series, for example:

&ChartData=A;
0,0,0;0,1,0;0,2,0;0,3,0;0,4,0;
1,0,0;1,1,0;1,2,0;1,3,0;1,4,0;
2,0,0;2,1,0;2,2,1;2,3,0;2,4,0;
3,0,0;3,1,0;3,2,0;3,3,0;3,4,0;
4,0,0;4,1,0;4,2,0;4,3,0;4,4,0 
                      

Yields the following graph:

For two-dimensional Scatter Charts, each data point has two sub data points. All other charts have three sub data points separated by a comma. In addition, if the number of data points is not the same for all series, the maximum number of data points in a series must be specified. Use the CategoryLength parameter to specify the maximum number of data points, for example:

&ChartData=Trial1;3,1;8,2;20,5;40,10;60,25|
Trial2;6,1;10,1;21,3;28,6;39,11;54,17;65,29
&CategoryLength=7 
                      

For HLCO, High-Low, and Gantt Charts, the ChartData parameter specification is similar to that of the Stack-type charts. For HLCO Charts, 4 sub data points within each individual data point specify the High, Low, Open, and Close values. For High-Low Charts, 2 sub data points specify the High, and Low values. For Gantt Charts, 2 sub data points specify the Start and End values. The ChartData structure resembles the following:

&ChartData=priceA;7,2,3,5;19,5,11,9;15,8,9,8
&CategoryName=day1;day2;day3&DataType=integer 
                      

This data generates a HLCO chart with 1 series priceA, and three integer data points day1, day2, and day3. Each data point has a High, Low, Open, and Close value.

For more information about the various chart types, and data mapping, please see Section 3.13 - Chart Types and Data Mapping.

This parameter allows you to specify the individual category names of the data points. Each category name is separated by a semi-colon. The data points are specified within the ChartData parameter.

&CategoryName=day1;day2;day3…
                      

This parameter allows you to specify the maximum length of the series in scatter, and bubble charts. The argument is specified as a single integer. This needs to be specified when the individual series are not the same length. If CategoryLength is not specified, then the chart will be plotted assuming that the series length is never longer than the first series specified. Hence, if the second series is longer than the first, the additional data points will not be plotted unless the CategoryLength parameter is used.

&CategoryLength=4
                      

This parameter allows you to specify the individual sumby names for the data points. This parameter is used when you're entering data for Stack-type charts.

&SumbyName=deli;drinks;bread;cookies…
                      

This parameter allows you to specify the type of data values that are used by the chart. The default type is float. The arguments that can be specified for this parameter are int, integer, float, double, boolean, date, time, and timestamp. The values are not case sensitive. Date, time, and timestamp types can only be used for Gantt charts.

&DataType=integer
                      

	Note
	DataType is only specified for the value axis. You can use different types of data for the category axis, however they are all treated as strings. To use numeric, or date data without having it converted to string, design the chart using a database or data file.

This allows you to specify the main title of the chart. By default, the chart has no title. However, if you're using a template file the titles will carry over, unless you specify different titles using these parameters.

&MainTitle=Sample+Chart
                      

This allows you to specify the X-axis title.

&XTitle=Time+of+Day
                      

This allows you to specify the Y-axis title.

&YTitle=Sales
                      

This allows you to specify the Z-axis title.

&ZTitle=seriesA
                      

This allows you to specify the width of the generated image in pixels. If you do not specify a width, then the image will have the same width as the chart canvas.

&Width=400
                      

This allows you to specify the height of the generated image in pixels. If you do not specify a height, then the image will have the same height as the chart canvas.

&Height=444
                      

This is a Boolean flag that will cause the chart (not including labels, legend, etc.) to be shrunk and/or repositioned to fit on the canvas. By default, this is false.

&FitOnCanvas=true
                      

This allows you to specify the X and Y position of the lower left-hand corner of the chart to the lower left-hand corner of the chart canvas or image. The two arguments, numbers between 0 and 1 separated by a semi-colon, specify the X and Y positions respectively. 0;0 places the chart at the lower left-hand edge of the image, and 1;1 places the chart at the upper right-hand edge. By default, the chart relative position is 0.2;0.2

&ChartRelativePosition=0.23;0.18
                      

This allows you to specify the size of the chart (relative width and height) relative to the chart canvas or image. The two arguments, numbers between 0 and 1 separated by a semi-colon, specify the width and height respectively. 1;1 causes the chart to be the same size as the image, and 0;0 will have no chart. By default, the chart relative size is 0.6;0.6.

&ChartRelativeSize=0.63;0.7
                      

This allows you to specify whether the chart is two-dimensional or three-dimensional. By default the chart is two-dimensional. The argument for this parameter is either 2D or 3D.

&ChartDimension=3D
                      

This parameter allows you to select which chart type to use. By default, a Column Chart type is used. The arguments for this parameter can be: Column, Bar, Line, Pie, Area, Overlay, Box, Radar, Dial, StackColumn, StackBar, StackArea, PercentColumn, Scatter, Bubble, Surface, HLCO, HiLow, and Gantt.

&ChartType=StackArea
                      

	Note
	For Overlay, Box, and Radar charts, you can only open existing charts through the ChartPath parameter, you will not be able to specify ChartData for these chart types.

This allows you to specify the way in which three-dimensional charts should be drawn. There are five options that are specified with an integer argument from 1 to 5. 1 draws the chart as a wire frame without filling in the surfaces. 2 draws a border around the chart frame. 3 draws a border and applies Gouraud shading. 4 draws the chart with Gouraud shading, but doesn't draw a border. 5 draws the 3D chart as standard (without borders or specialized shading). (This is also the default).

&3DDrawMode=2
                      

For more information about three-dimensional rendering options, see Section 3.14.4 - The Navigation Panel.

This parameter allows you to select the image format in which you would like to render the chart. Options are GIF, JPG, PNG, PDF, and SVG. The default type is JPG.

&DisplayType=GIF
                      

	Note
	If you're generating a parameter page for the chart (see Section 6.2.2.2.5 - Parameter Page Parameters) you can specify this argument more than once in an URL to give the user a drop-down list from which to select the image format. If you specify more than one format without generating a parameter page, the chart will be generated using the format specified in the first argument.

This is a Boolean flag that allows you to specify whether the chart should be written as a file on the server-side, or streamed back to the client. If this argument is set to true, then the ExportPath argument should also be used to indicate where the file should be written.

&ExportOnServer=true&ExportPath=C:\ERES\ExportFiles\chart.gif
                      

This allows you to specify a file path to export the chart to. This argument should always be used with the ExportOnServer argument. When a file path is specified, the chart will be exported in the selected format to the server-side.

	Caution
	When using ExportPath parameter and the file with the same name already exists, it is replaced without any warnings.

This is a Boolean flag that allows you to specify if the image buffer is used.

&UseBuffer=true
                      

This allows you to specify which of the two available image generation methods the server should use. You can specify either B for the buffer method or F for the frame method. Each method can result in faster performance depending on the system, the size of the generated image, and the number of data points in the chart.

&ExportMethod=B
                      

This is a Boolean flag that allows you to set the background of generated GIF images transparent. This parameter only works if the display type is set to GIF.

&GIFTransparent=true
                      

This parameter allows you to specify the compression of PNG images. The lower the compression is set, the faster the file will be generated. Lower compressions produce much larger files. There are four compression settings that can be specified using an integer argument. 0 is default compression. This level is the mid-level compression. 1 is fast compression. This generates the PNG file with minimal compression, causing fast file generation with a fairly large file. 2 is maximum compression. This generates a fully compressed PNG file, causing the file to be very small, but taking more generation time. 3 is zero compression. This generates a PNG file without any compression. It is generated very quickly, but has a very large file size.

&PNGCompression=1
                      

This parameter allows you to specify the quality of generated JPEG images. As quality increases, so does the generated file size. The argument for this parameter is an integer between 1 and 99. 1 is minimum quality, and 99 is the maximum. By default the quality is set to 99.

&JPEGQuality=99
                      

This is a Boolean flag that indicates whether or not to return a parameter page instead of a chart. This option only works it the chart contains query parameters. If this argument is set to true then the URL will return the parameter page, and ignore any parameter values passed into the URL. By default this argument will be false.

&ForHTMLParamPage=true
                      

This allows you to specify a CSS file to format the generated parameter page.

&ParamPageCssStyle=http://machinename:port/files/ParamPage.css
                      

	Note
	You can use both absolute and relative paths to the CSS file.

This parameter allows you to specify a title for the parameter page.

&ParamPageTitle=Select+Chart+Options
                      

This parameter allows you to specify the font to use for the parameter page title.

&ParamPageTitleFontName=Arial
                      

This parameter allows you to specify the font size for the Parameter page title. The size is specified as HTML size (i.e. <font size=3>) rather than point size. It ranges from 1 to 7, where 1 is the smallest and 7 is the largest.

&ParamPageTitleFontSize=5
                      

This allows you to apply a font style to the text of the parameter page title. The style is specified as an integer from 0 - 3. The numbers indicate the following styles: 0 - Plain, 1 - Bold, 2 - Italic, 3 - Bold + Italic.

&ParamPageTitleFontStyle=1
                      

This parameter allows you to specify the font color for the parameter page title. The color is specified with a six digit hexadecimal number like in HTML.

&ParamPageTitleFontColor=404040
                      

This parameter allows you to specify the font to use for the prompt text in the parameter page.

&ParamPageTextFontName=Arial
                      

This parameter allows you to specify the font size for the Parameter page prompt text. The size is specified as HTML size (i.e. <font size=3>) rather than point size. It ranges from 1 to 7, where 1 is the smallest and 7 is the largest.

&ParamPageTextFontSize=3
                      

This allows you to apply a font style to the parameter page prompt text. The style is specified as an integer from 0 - 3. The numbers indicate the following styles: 0 - Plain, 1 - Bold, 2 - Italic, 3 - Bold + Italic.

&ParamPageTextFontStyle=0
                      

This parameter allows you to specify the font color for the parameter page prompt text. The color is specified with a six digit hexadecimal number like in HTML.

&ParamPageTextFontColor=000000
                      

This parameter allows you to specify the thickness of the border drawn around the prompts in the parameter page. The thickness is specified in pixels. Specifying 0 will draw no border around the prompts.

&ParamPageBorderThickness=1
                      

This parameter allows you to specify the color for the border drawn around the prompts in the parameter page. The color is specified with a six digit hexadecimal number like in HTML.

&ParamPageBorderColor=C6C6C6
                      

This parameter allows you to specify the background color for the table containing the prompts in the parameter page. The color is specified with a six digit hexadecimal number like in HTML.

&ParamPageTableBackgroundColor=FFFFFF
                      

This parameter allows you to specify the alignment in the page for the table containing the prompts. Options are LEFT, RIGHT, and CENTER. The default alignment is CENTER.

&ParamPageAlignment=LEFT
                      

This parameter allows you to specify the layout of the parameter page. You can either align the parameter prompts vertically (default) or horizontally. The options for this parameter are HORIZONTAL and VERTICAL.

&ParamPageLayout=HORIZONTAL
                      

This is a Boolean flag that allows you to show/hide the reset button for the parameter form. By default the button is shown.

&ParamPageResetEnabled=false
                      

This is a Boolean flag that allows you to draw only the outer border for the parameter prompt table. This parameter will have no effect if the border thickness is set to zero.

&ParamPageOuterBorder=true