#!#About
#!#Version:
#!#Build date:
#!#Close
#!#%1 Results
#!#You have popups blocked.
#!#You should allow popups from this host in your browser or ask your system administrator to disable the application's popup mechanism.
#!#Click</a> to generate your report.
#!#No pivot quantities are available.
#!#Maybe a favorite is out of date or the template has been modified.
#!#No chart quantities are available.
#!#No comparison quantities are available.
#!#You may not check NOT when allowing all values for <i>
#!#You must enter a %1% (or range thereof) for the <i>%2%</i> filter.
#!#You must enter a %1% (or range thereof) for the <i> %2% - %3%%4% </i> filter.
#!#1- You must enter a valid date-range (submitted: 
#!#1- The start date you specify for the date range cannot be later than the end date (specified 
#!#2-You must enter a valid date-range for the comparison (submitted: 
#!#2-The start date you specify for the comparison date range cannot be later than the end date.
#!#You must specify a value for the <i> %1% </i> filter.
#!#You must specify a value for the <i> %1% - %2%</i> filter.
#!#You cannot do a pivot report using <i> %1% </i> as an analysis criterion.
#!#v.
#!#by
#!#Mapping:
#!#Analysis:
#!#Group by:
#!#(No grouping)
#!#Order by:
#!#View Top by:
#!#Viewing
#!#The 'group by' and 'analyze by' variables in a grouped analyze report must be different.
#!#Grouped reports are not allowed under your current license -
#!#Analysis reports are not allowed under your current license -
#!#Comparison reports are not allowed under your current license -
#!#Charting is not allowed under your current license -
#!#Pivot reports are not allowed under your current license -
#!#Grouped and Pivot charts are not allowed under your current license -
#!#You cannot compare based on <i>detail</i> - showing regular report instead
#!#Internal note: You changed the button descriptions, and now you need to change the hardcoded values
#!#Time to Execute Page
#!#Time to Setup Cache
#!#Time to Run Report Loop  (Main Report Select)
#!#Breakdown
#!#Time to Execute SQL Statement (analysis_sql.asp)
#!#Time to Calculate SQL (analysis_calculate.asp)
#!#Time to check report metadata  (analysis_report_metadata.asp)
#!#Time to Render Html
#!#You cannot graph a grouped pivot report.
#!#You cannot (yet) produce a grouped chart based on <i>detail</i>.
#!#You are trying to generate a plot of more than 1000 elements.
#!#Try narrowing your criteria.
#!#vertbar
#!#horizbar
#!#line
#!#pie
#!#No Matching Records Found
#!#You are trying to compare across more than the system limit of %1% quantities.
#!#Grand Total
#!#You have reached the system limit of %1% quantities.
#!#You have reached the system limit of <i> %1% x %2% = %3% </i> quantities.
#!#You cannot generate a <I>Detail</I> report - There must be at least one quantity with the <i>Detail</i> option enabled.
#!#You cannot perform this type of report on <I>Detail</I>.
#!#You cannot generate a <I>Detail</I> report for <i>%1%</i>: " & _ 				"<i>%1%</i> should have the <i>Detail</i> option enabled.
#!#January
#!#February
#!#March
#!#April
#!#May
#!#June
#!#July
#!#August
#!#September
#!#October
#!#November
#!#December
#!#Jan
#!#Feb
#!#Mar
#!#Apr
#!#Jun
#!#Jul
#!#Aug
#!#Sep
#!#Oct
#!#Nov
#!#Dec
#!#S
#!#M
#!#T
#!#W
#!#F
#!#Use setReturnFunction() to define which function will get the clicked results!
#!#Use setReturnMonthFunction() to define which function will get the clicked results!
#!#You clicked: year=
#!#Use setReturnQuarterFunction() to define which function will get the clicked results!
#!#Use setReturnYearFunction() to define which function will get the clicked results!\nYou clicked: year=
#!#Invalid display type!
#!#Must be one of: date,week-end,month,quarter,year
#!#calendar.select: To use this method you must also include 'date.js' for date formatting
#!#calendar.select: This function can only be used with displayType 'date' or 'week-end'
#!#calendar.select: Input object passed is not a valid form input object
#!#Your session has timed out. Please log in again.
#!#Choose comparison ranges
#!#name
#!#Compare
#!#Cancel
#!#Choose mapping
#!#Mappings
#!#Shaws Intranet
#!#Mapping # %1% no longer exists
#!#The %1% specified must be numeric for this mapping (current %2% is <i>'%3%'</i>)
#!#Invalid %1% specification - <i>'%2%'</i> is a value for <i> %3%</i> which has no corresponding data
#!#The mapping <i> %1% </i> has not been validated by your System Administrator.
#!#You may encounter errors (%3% Proceed?</A>)
#!#Comparison reports are not possible in this schema.
#!#Choose date-ranges for comparison
#!#Cookies & Javascript
#!#Back to Login
#!#How to Enable Cookies
#!#To enable cookies, follow the instructions below for the browser version you are using.
#!#Enabling Cookies in Microsoft Internet Explorer
#!#Microsoft Internet Explorer 6.0+
#!#Select &quot;Internet Options&quot; from the Tools menu.
#!#Click on the &quot;Privacy&quot; tab.
#!#Click the &quot;Default&quot; button (or manually slide the bar down to &quot;Medium&quot;) under &quot;Settings&quot;.
#!#Click &quot;OK&quot;.
#!#Microsoft Internet Explorer 5.x
#!#Click on the &quot;Security&quot; tab.
#!#Click the &quot;Custom Level&quot; button.
#!#Scroll down to the &quot;Cookies&quot; section.
#!#To enable:
#!#Set &quot;Allow cookies that are stored on your computer&quot; to &quot;Enable&quot;.
#!#Set &quot;Allow per-session cookies&quot; to &quot;Enable&quot;.
#!#Microsoft Internet Explorer 4.x
#!#Select &quot;Internet Options&quot; from the View menu.
#!#Click on the &quot;Advanced&quot; tab.
#!#Scroll down to find &quot;Cookies&quot; within the &quot;Security&quot; section.
#!#Select &quot;Always accept cookies&quot;.
#!#Enabling Cookies in Netscape/Mozilla
#!#Netscape 7.1/Mozilla 1.x
#!#Select &quot;Preferences&quot; from the Edit menu.
#!#Click on the arrow next to &quot;Privacy &amp; Security&quot; in the scrolling window to expand.
#!#Under &quot;Privacy &amp; Security&quot;, select &quot;Cookies.&quot;
#!#Select &quot;Enable all cookies&quot;.
#!#Netscape Communicator 4.x
#!#Find the &quot;Cookies&quot; section in the &quot;Advanced&quot; category.
#!#Select &quot;Accept all cookies&quot; (or &quot;Enable all cookies&quot;).
#!#Mozilla Firefox (1.0 final release and earlier)
#!#Go to the Tools menu.
#!#Select &quot;Options&quot;.
#!#Select the &quot;Privacy&quot; icon in the left panel.
#!#Check the box corresponding to &quot;Allow sites to set cookies&quot;.
#!#Click &quot;OK&quot; to save changes.
#!#Enabling Cookies in Opera
#!#Opera 8.x
#!#Select &quot;Preferences&quot; from the Tools menu.
#!#Click &quot;Cookies&quot; in the left panel.
#!#Under the &quot;Cookies&quot; heading, choose &quot;Accept all cookies&quot; in the drop down box.
#!#Opera 7.x
#!#Select &quot;Preferences&quot; from the File menu.
#!#Click &quot;Privacy&quot;.
#!#Under the &quot;Cookies&quot; heading, select &quot;Enable Cookies&quot;.
#!#Choose &quot;Automatically accept all cookies&quot; in the drop down box.
#!#How to Enable Javascript
#!#To enable javascript, follow the instructions below for the browser version you are using.
#!#Enabling Javascript in Microsoft Internet Explorer
#!#Select the &quot;Internet Options&quot; from the Tools menu.
#!#From the list of zones at the top of the Security options select the internet icon.
#!#Select the button &quot;Custom Level&quot;.
#!#In the new window that pops up, scroll down to &quot;Active Scripting&quot;.
#!#Select &quot;Enable&quot;.
#!#Click &quot;Ok&quot; at the bottom of the Security Settings window.
#!#Click &quot;Ok&quot; at the bottom of the Internet Options window.
#!#Select &quot;Internet	Options&quot; from the Tools menu.
#!#Select the button &quot;custom&quot;.
#!#Select &quot;Internet	Options&quot; from the View menu.
#!#Select the button &quot;custom&quot; and click on the &quot;settings&quot; button.
#!#Enabling Javascript in Netscape/Mozilla
#!#Click the arrow next to &quot;Advanced&quot;.
#!#Click &quot;Scripts &amp; Plugins&quot;.
#!#Check &quot;Navigator&quot; beneath &quot;Enable Javascript for&quot;.
#!#Click &quot;Reload&quot;.
#!#Click &quot;Advanced&quot; in the list of options on the left hand side of the Preferences window.
#!#On the right hand side select	the checkbox &quot;Enable Javascript&quot;.
#!#Select &quot;Options&quot; from the Tools menu.
#!#Choose &quot;Web Features&quot; from the left navigation.
#!#Select the checkbox next to &quot;Enable JavaScript&quot;.
#!#Enabling Javascript in Opera
#!#Select &quot;Quick Preferences&quot; from the Tools menu.
#!#Click &quot;Content&quot; in the left panel.
#!#Check &quot;Enable Javascript&quot;.
#!#Select &quot;Quick Preferences&quot; from the File menu.
#!#Under &quot;Multimedia&quot; tick the checkbox &quot;Enable Javascript&quot;.
#!#Change password
#!#Current&nbsp;Password
#!#New&nbsp;Password
#!#Confirm&nbsp;Password
#!#Restricted to Sales Rep Initials
#!#Restricted to Sales Group Initials
#!#Full Access
#!#Update
#!#Current password incorrect.
#!#You must enter the new password twice.
#!#Sunday
#!#Monday
#!#Tuesday
#!#Wednesday
#!#Thursday
#!#Friday
#!#Saturday
#!#Sun
#!#Mon
#!#Tue
#!#Wed
#!#Thu
#!#Fri
#!#Sat
#!#Favourites
#!#OK to delete
#!#Delete not permitted in this deployment
#!#Report Name
#!#Edit
#!#Email
#!#Delete
#!#&lt; Back
#!#Documents Listing
#!#Home
#!#An Error has occured! Please Check the document virtual path and document system path" &_   "in System Settings or contact your administrator.
#!#Execution in progress
#!#Cancelling...
#!#Generating&nbsp;report...
#!#Search by %1
#!#Search
#!#Show All
#!#Case-sensitive
#!#Search results
#!#No match
#!#Selection
#!#Done
#!#Logout :
#!#Help Topic '%1%' not found
#!#Please report this error to <i>Interactive Reporting</i>
#!#Advanced Report Design
#!#This mapping may not be valid
#!#mapping
#!#Then By
#!#Analyze By
#!#Order By
#!#Group By
#!#View
#!#Filter By
#!#Hide
#!#Show
#!#Reset
#!#Analyze
#!#Pivot
#!#Chart
#!#Horz. Bar
#!#Vert. Bar
#!#Pie (Ungrouped)
#!#Line Graph
#!#Time to Render Page
#!#seconds
#!#Time to render GUI
#!#Time to render mappings 
#!#Time to render report selection
#!#Time to render filters
#!#Report Design
#!#Report Wizard
#!#Choose Chart Format
#!#Choose Analysis Report Parameters
#!#Choose the parameters upon which you wish to report
#!#Choose Pivot Report Parameters
#!#Choose Comparison
#!#Choose Date Ranges
#!#Filter data
#!#Choose Report Configuration
#!#Select report grouping" & setHelpPopup("Wizard_GroupBy", "") & ", ordering" & setHelpPopup("Wizard_OrderBy", "") & " and display quantities
#!#All
#!#Vertical Chart
#!#Graph your data in a vertical bar graph.  This graph allows you to easily compare data values visually.
#!#Horizontal Chart
#!#Graph your data in a horizontal bar graph.  This graph may be better for printing on standard paper.
#!#Pie Chart
#!#Create a pie chart to better visualize what data contributes the most to your total results.
#!#Line Chart
#!#Line charts are good for tracking data over a long period of time.  Use a line chart to see how data fluctuates.
#!#Then drilldown into
#!#First examine
#!#Login
#!#Please sign-in...
#!#Name:
#!#Password:
#!#Use <b>demo</b> as the name and password to log in.
#!#To use this site properly, you will need to enable both JavaScript  and Cookies on your browser.
#!#To use this site properly, you will need to enable JavaScript on your browser.
#!#To use this site properly, you will need to enable Cookies on your browser.
#!#Click here</font></a> for instructions
#!#Logging-in
#!#Invalid username or password
#!#Logins permitted only from your local machine - 
#!#Logon not allowed from 
#!#Your password has expired.
#!#Please set another.
#!#Mapping #%1%, to which this user is assigned, no longer exists.
#!#Mapping Refresh
#!#This mapping has been updated by your system administrator - %1% continue?</a>
#!#Mapping '<i>%1%</i>' is invalid - there are no fields mapped.
#!#Please contact your system administrator.
#!#There are no fields mapped - impossible to proceed
#!#Hash
#!#SQL Error
#!#Connection String:
#!#Check that:
#!#Your database connection is valid.
#!#Your database is accessible.
#!#Edit Report
#!#Save Report As Favourite
#!#You must specify a title for the report
#!#If you wish to send a report you must specify an email address
#!#Invalid email address specified.
#!#Report Title
#!#Schedule E-mail
#!#E-mail address
#!#Format
#!#HTML
#!#Excel
#!#Save
#!# The title '%1%' has already been used for another saved report.
#!# Please choose another.
#!#An internal error has occurred: 
#!#There was an error while connecting to your database
#!#Statement
#!#A SQL error has occurred while accessing your data-source
#!#details
#!#Error parsing expression (first argument)
#!#Error parsing expression (second argument)
#!#Error parsing expression (third argument)
#!#Internal error: call to selectSessionOrRequestVariable(,,) must specify 'session' or 'request'
#!#Redbrick issue: Cannot parse SQL statement for top selection:
#!#Execution interrupted!
#!#Top 20
#!#Top 50
#!#Bot. 20
#!#Bot. 50
#!#Wizard
#!#Advanced
#!#Simple
#!#with
#!#Date Range
#!#Custom
#!#Yesterday
#!#Today
#!#Week Before Last
#!#Last Week
#!#This Week
#!#Last Month
#!#This Month
#!#Last Quarter
#!#This Quarter
#!#Last Year
#!#This Year
#!#Year to Last Month
#!#Yr to Lst Mon. (Lst Yr)
#!#This Month (Last Yr)
#!#Last Month (Last Yr)
#!#YTD (This Yr)
#!#YTD (Last Yr)
#!#Start
#!#Date
#!#End
#!#Could not lock database after 1 seconds. <br> Please retry your request.
#!#Ascending
#!#Descending
#!#Detail
#!#By Day
#!#By Week
#!#By Month
#!#By Quarter
#!#By Year
#!#%1 By %2
#!#Day
#!#Week
#!#Month
#!#Quarter
#!#Year
#!#NOT
#!#Internal Error: At least one 'detail field' must have been specified as showInDetailReport='Yes'.
#!#%1 Date
#!#Comparison
#!#according to
#!#ordered by
#!#You can't make a pie chart of 
#!#You can't make a grouped pie chart.
#!#You can't produce a stacked % chart of a percentage-based quantity
#!#The two variables you plot in a pivot report must be different - you have set both to
#!#The two variables you display in a grouped pivot report must each be different from the grouping variable
#!#You have more than the system limit of columns.
#!#Try a more restrictive query.
#!#Total
#!#Welcome
#!#Select report type
#!#Standard Report
#!#Create an analytical report of all your data.  Drill down to specify your data and sort your information as needed.
#!#Similar to a regular report but helps you clearly visualize your data.
#!#Pivot Report
#!#A pivot report allows you to compare two different data sets against one another. This allows you to discover unique correlations in your data.
#!#Comparison Report
#!#A comparison report shows differences in your data set over two different periods of time.
#!#Advanced Reporting
#!#Use the traditional Interactive Reporting interface to generate reports.
#!#Recommended for experienced users only.
#!#View Favourites
#!#Select from one of your previously saved 'Favourites' reports.
#!#Next
#!#Logout
#!#Mapping '%1%' is invalid - There are no fields in the Template '%2%' to be mapped
#!#Mapping '%1%' is invalid - The field '%2%' is not a valid Template field
#!#To create a mapping you need to map the <I>%1%</I> in the <i>%2%</i> table.
#!#To create a mapping for the <I>%1%</I> table you must first create a mapping for <I>%2%</I> in the <I>%3%</I> table.<br>
#!#To create a mapping for the <I>%1%</I> table you must first map the <I>%2%</I> in the <I>%3%</I> table.<br>
#!#The child field <i>%1%</i> in the <i>%2%</i> table has a datatype of <i>%3%</i>.
#!#The master field <i>%4%</i>in the <i>%5%</i> table has a datatype of <i>%6%</i>.
#!#They must <b>match</b><br>
#!#Rename
#!#None
#!#Text Box
#!#Text Box (w/codes)
#!#Combo Box
#!#Combo Box w/codes
#!#Combo Box (w/o All)
#!#Combo Box w/codes (w/o All)
#!#Multi-Select Combo Box
#!#Multi-Select Combo Box w/codes
#!#Multi-Select Combo Box (w/o All)
#!#Multi-Select Combo Box w/codes (w/o All)
#!#Clone
#!# '%1%' is used as %2% security field in template '%3%' and should be mapped
#!#Create New Mapping
#!#Create  a New Mapping
#!#Edit Mapping
#!#Modify/Update the Mapping <i>%1%</i>
#!#%1 Mapping
#!#You have reached the maximum number of mappings permitted by your license - 
#!#Description
#!#Template
#!#Currency Symbol
#!#Leave Blank to use Server Default
#!#Database Type
#!#Access
#!#DB2
#!#FairCom/Attache
#!#Firebird
#!#Foxpro
#!#Informix
#!#Interbase
#!#MYOB
#!#Mysql
#!#Oracle
#!#PervasiveSQL
#!#Redbrick
#!#SQL Server
#!#Other
#!#Database Connection
#!#DSN
#!#Data Source
#!#DSN %1% no longer available
#!#Username
#!#Password
#!#DB String
#!#Mappings cannot be created without a Template." & _ 		 " There are currently no Templates available.
#!#Cannot be blank
#!#Invalid type - Cannot contain '""'
#!#Name already in use - choose another
#!#Administration
#!#MSXML download
#!#To import a Template or Mapping, XML functionality is required on your server.
#!#To install MSXML
#!#click here
#!#Back to %1% Import Template %2% 
#!#Import Mapping
#!#Administrator Login
#!#Administrator sign-in...
#!#Use <b>demo</b> as the password to log in.
#!#Invalid administrator password
#!#Look & Feel
#!#Design a Custom Appearance for your Reports
#!#Use a Built-In Template
#!#Design My Own
#!#CSS
#!#Style Sheet
#!#sample.css
#!#Click %1%here%2% for help on how to construct your custom style sheet.
#!#Mappings Maintenance
#!#List of Current Mappings
#!#Database
#!#Export
#!#Save As Preset
#!#Cloning is not allowed - You have reached the maximum number" & _ 			" of mappings permitted by your license
#!#Preset key cannot contain ""
#!#This mapping is a clone of another - please rename before continuing
#!#This mapping has already been cloned - please rename the clone before continuing
#!#Specify Mapping
#!#Details of Mapping <i>%1%</i>
#!#Mapping Editor (Master Screen)
#!#Change
#!#Server Default
#!#Validate & Save
#!#For Interbase/Firebird Support to work Correctly with IR you need to define the following UDF.
#!#Map Main Transaction Table
#!#Mapping Editor (1 of 2)
#!#Select the Data you wish to Map/Alter
#!#Table
#!#Where
#!#  For best results with the WHERE clause, prefix all database columns with 
#!#SQL
#!#Filter Option
#!#Title
#!#Back
#!#Hide System Tables
#!#Show System Tables
#!#If you select sql then you must enter a sql select statement
#!#MySQL does not permit custom SQL
#!#Informix does not permit custom SQL.
#!#Create a view to represent your custom SQL, and select it from the drop down list.
#!#FairCom does not permit custom SQL.
#!#%1 does not permit custom SQL.
#!#You cannot have a semi-colon at the end of your SQL.
#!#Your SQL statement must start with the SQL keyword SELECT.
#!#There is a problem in the SQL statement you entered.
#!#The database returned the following specific error <br><i>
#!#Field Mapping
#!#Mapping Editor (2 of 2)
#!#Connect the Source (Data) Fields with the Destination (IR) Fields
#!#Source
#!#Connect
#!#Destination
#!#Filter Required
#!#Find
#!#Visible
#!#Display
#!#Finish
#!#When the <i>Filter Required</i> option is selected the <i>Display</i> cannot be set to ""None""
#!#The options of the field '%1%' must be modified.
#!#You must select both a source and a destination field.
#!#You have already created a mapping for 
#!#Please delete the old mapping first. 
#!#You cannot map 2 source fields into the same destination.
#!#The field <i> %1% does not have an underlying date type.
#!#Correct sorting and date-based filtering are not possible.
#!#Please modify your query to cast <i> %1% </i> to a date or reconfigure your datasource.
#!#The field <i> %1% does not have an underlying numerical type.
#!#If you are sure this mapping is correct, please modify your query to cast <i> %1% </i> to a numerical type or reconfigure your datasource.
#!#'%1%' is used as user/group security field in template '%2%' and cannot be deleted
#!#'Change ' %1% ' filter option
#!#You must specify a non-empty description.
#!#Description already in use for another field.
#!#Mapping Export
#!#Export Mapping
#!#Destination file
#!# The mapping '%1%' must first be validated
#!#Mapping Import
#!#Import a Mapping by Choosing from a Source File
#!#Source file
#!#Import
#!#Error Uploading File
#!#Error importing mapping:
#!#Error: not a mapping
#!#Error: A mapping named ' %1% ' is already installed.
#!#Template '%1%' not installed - please import it before importing this mapping.
#!#Import failed: Template '%1%' does not contain valid fields.
#!#Save Preset
#!#This mapping has already been saved as a preset
#!#Save a Mapping as a Preset
#!#Preset Key:
#!#The '%1%' mapping is based on the '%2%' template, which should also be exported.
#!#Admin Home
#!#Templates
#!#Users
#!#System Settings
#!#Back To Report
#!#Help
#!#Create
#!#This section provides a list of the current mappings in the system.
#!#A mapping connects your data with  one of Interactive Reporting's Templates.
#!#Within this section a user can create, update, modify or delete a mapping.
#!#This section provides a list of the templates used in the system.
#!#Within this section a user can create,   update, modify or delete a template.
#!#This section provides a list of the users in the system.
#!#As well as dealing with the creation and modification of users details  this section also deals with security in your system.
#!#Here you can restrict a user's access to a partial view of the data or even as to which machine they may view the data from.
#!#This detailed section contains system specific data such as the administrator password, license key, year start date, session timeout and many other system related information.
#!#The Look & Feel section allows for the customization of Interactive Reporting.
#!#Interactive Reporting facilitates the easy  change of background color, font and image.
#!#Link to Interactive Reporting's main page.
#!#Clicking on this link will automatically open a copy of the Administrators Manual.
#!#Interactive Reporting Web Page
#!#Link to Interactive Reportings home site.
#!#On this site you can find a FAQ section, contact information, new products and much more.
#!#Run SQL commands against a Mapping
#!#This utilitiy allows you to connect to an arbitrary mapping and run arbitrary sql commands.
#!#Select Resultsets will also be displayed.
#!#Immediate mode sql tool.
#!#Good for Interactive development.
#!#Run SQL commands against an ODBC Source
#!#This utilitiy allows you to connect to an arbitrary odbc source and run arbitrary sql commands.
#!#Datapump Tool
#!#Transfer Data from one ODBC Datasource to another.
#!#Preset Mappings
#!#as Preset
#!#Table: Set Datasource
#!#Table: Connect Datasource
#!#Create New Template
#!#Edit Template 
#!#Import Template
#!#Upgrade Template
#!#Variable
#!#Calculated Variable
#!#Lookup
#!#SQL Mapping
#!#SQL ODBC
#!#Choose Database
#!#Choose Fields
#!#Transfer Completed
#!#Add New User
#!#Edit User
#!#Add New
#!#Preset Mappings Maintenance
#!#List of Current Preset Mappings
#!#Template Type
#!#Preset Key
#!#Schemas
#!#Templates Maintenance
#!#List of Current Templates
#!#No Related Mappings
#!#Go To Mapping
#!#There is a mapping based on this Template.
#!#All related Mappings and Presets should be deleted first before deleting a Template.
#!#Format Detail Report
#!#Select which Fields Should Appear at the <i>%1%</i> Report
#!#Format Compare Report
#!#Format Comparison Delta Report
#!#Comparison Delta
#!#Format Chart Report
#!#Format Pivot Report
#!#Choose
#!#Submit
#!#Specify Schema
#!#Variables
#!#Calculated Variables
#!#Lookups
#!#Reports
#!#Details of Template <i>%1%</i>
#!#Template Editor (Master Screen)
#!#Principal Table
#!#Delete not permitted in this deployment.
#!#'%1%' is used in the Calculated Variable '%2%'
#!#'%1%' exists in the mapping(s) '%2%'.
#!#OK to delete '%1%' from the mapping(s) and the list?
#!#OK to delete '%1%' ?
#!#'%1%' is used in the mapping(s) '%2%'.
#!#Add
#!#Order
#!#Formula
#!#Conditional Sum
#!#Sum
#!#Weighted Sum
#!#Min
#!#Max
#!#Count
#!#Fields
#!#Detail Report
#!#Chart Report
#!#Add/Edit Lookup
#!#Add Lookup
#!#Add a New Lookup
#!#Edit Lookup
#!#Update/Modify Lookup <i>%1%</i>
#!#'%1%' is used in mapping '%2%'.
#!#OK to delete '%1%' from the mapping and the list?
#!#Internal Name
#!#Analysis Label
#!#Data Type
#!#Text
#!#Text with Lookup
#!#Left
#!#Right
#!#Key Label
#!#Description Label
#!#Attributes
#!#Invalid Type - Cannot contain '%1%' 
#!#You cannot change the Data Type of the Lookup in this deployment
#!#The Key and Description labels should have different names
#!#The Attribute Names should not be equal to the " & _ 					"<i>Key</i> or <i>Description</i> labels
#!#Duplicate Attribute Names are not allowed
#!#This name is used by another Lookup
#!#This name is used for a Variable
#!#This name is used for another Lookup
#!#This name is used for a Calculated Variable
#!# '%1%' is not permitted
#!#Edit/Add Measures
#!#Add Calculated Variable
#!#Check table: 
#!# schema_items, row: %2% = %3% and %4% = %5% 
#!#Tablename '%1%' of Schema Items Subform is not a valid name.
#!#It should be renamed '%2%'
#!# '%1%' is not a valid value for 'Field Type' of the Schema Item Subform of the table '%2%'.
#!# It should be equal to either 'PrincipalKey' or 'PrincipalDescription'. 
#!# Check the row of Schema Item Subform with %3% = %4% and %5% = %6%
#!#Measure '%1%' does not exist - it must first be added.
#!#Check the row of Report Variables with %2% = %3% and %4% = %5%
#!#The Detail Field of Report Variables should always be equal to 'Yes'
#!#Check row of Report Variables with %1% = %2% and %3% = %4%
#!#Please use another name - '%1%' is a reserved keyword.
#!#Execute SQL against a mapping
#!#Run Arbitrary SQL Commands for the Mapping of your Choice
#!#Execute SQL against an ODBC data source
#!#Run Arbitrary SQL Commands for an ODBC Source of your Choice
#!#Initial Commands
#!#Export to Excel
#!#Execute
#!#General
#!#Preferences
#!#Update/Modify your System Settings
#!#Administrator Password
#!#Session Timeout
#!#minutes
#!#Year Start
#!#Year Display Offset
#!#Week Start
#!#Default Start Date
#!#Default End Date
#!#Documentation Virtual Path
#!#Documentation System Path
#!#Integrated Windows Authentication
#!#Windows Domain
#!#Password Update Interval
#!#days
#!#'0' for never
#!#Email Source
#!#SMTP Server
#!#SMTP Port
#!#URL
#!#Email Problem Reports
#!#Display Execution Popup
#!#Default comparison method
#!#Percentage Change
#!#Default ordering method
#!#Code
#!#Filter value ordering
#!#Filter value search-type
#!#Case-Insensitive
#!#Max. number of rows
#!#Max. number of columns
#!#Background image filename
#!#Default Font Size
#!#License Key
#!#Customer Company Name
#!#You must specify a valid Default Start Date
#!#You must specify a valid Default End Date
#!#You must specify a numeric timeout value
#!#You must specify a positive timeout value
#!#A - You must specify a positive integral number of days
#!#B - You must specify a positive integral number of days
#!#C - You must specify a positive integral number of days
#!#You must specify a numeric value for the SMTP Port
#!#You must specify a positive SMTP Port
#!#You must specify a numeric value for the Max. number of rows
#!#You must specify a positive Max. number of rows
#!#You must specify a numeric value for the Max. number of columns
#!#You must specify a positive Max. number of columns
#!#The Email Address in the <i>Email Source</i> field is invalid
#!#The Email Address in the <i>Email Problem Reports</i> field is invalid
#!#You must specify a Customer Company Name
#!#You must enter a license key
#!#Update License Key
#!#You must specify a License Key
#!#You must specify a valid License Key
#!#User Maintenance
#!#List of Current Users
#!#Current Logins
#!#Num. Logins
#!#since
#!#Full Name
#!#Edit user details
#!#You have reached the maximum number of users permitted by your license - 
#!#Modify/Update <i>%1%'s</i> Details
#!#Add a New User
#!#Login-Name
#!#Logon&nbsp;Domain
#!#Subnet
#!#Class A
#!#Class B
#!#Class C
#!#Exact
#!#Documentation Access
#!#Access All
#!#Allow Access
#!#Access Level
#!#User Key
#!#Secondary User Key
#!#Group Key
#!#Restricted to User Key
#!#Restricted to Secondary User Key
#!#Restricted to Group Key
#!#All mappings must be validated
#!#The mapping must first be validated
#!#Login-Name cannot be blank
#!#Login-name already in use - please choose another.
#!#You must set a password
#!#You cannot Restrict to Secondary User Key.
#!#No 'Secondary User' has been selected in template '%1%'.
#!#You must specify a User Key if you wish to set this Access Level for mapping %1%
#!#You must specify a Secondary User Key if you wish to set this Access Level for mapping %1%
#!#You must specify a Group Key if you wish to set this Access Level for mapping %1%
#!#Error retrieving mapping description for mapping #%1
#!#Mapping Tasks
#!#Main Transaction Table
#!#View Preset Mappings
#!#Administration Links
#!#Administration Home
#!#Interactive Reporting
#!#Administrator Manual
#!#Template Tasks
#!#User Tasks
#!#Reset login counter
#!#Labels
#!#Choose Databases
#!#Transfer Data from one ODBC Source to another
#!#Table/Field
#!#Destination name
#!#Transfer
#!#Drop
#!#Index
#!#Verifying selections...
#!#has no fields selected - unable to transfer
#!#Selections OK
#!#No tables to transfer
#!#Creating indexes for table: 
#!#Created index
#!#on table
#!#Creating table:
#!#Created table:
#!#Dropping table: 
#!#Dropped table:
#!# if len(trim(getUtilities().nullfix2(session("choose_" & database & ".useDSN"))))=0 then 	session("choose_" & database & ".useDSN")="Yes" end if  showErrorMessage session("choose_" & database & ".error"), false session("choose_" & database & ".error")="" %>  <table> 	<tr> 		<td valign=top class="label"><font size=+2><i><%=database%></i></font></td> 	</tr> 	<tr> 		<td valign=top class="label">
#!#</td> 		<td align=left valign=top> 			<%selectedVal=""%> 		    <select name=<%=database%>.database_type> 				<option <%=selectSessionVariable("choose_" & database & ".database_type","Access", selectedVal)%>>
#!# 				<option <%=selectSessionVariable("choose_" & database & ".database_type","SQLServer", selectedVal)%>>
#!# 				<option <%=selectSessionVariable("choose_" & database & ".database_type","Oracle", selectedVal)%>>
#!# 				<option <%=selectSessionVariable("choose_" & database & ".database_type","DB2", selectedVal)%>>
#!# 				<option <%=selectSessionVariable("choose_" & database & ".database_type","Informix", selectedVal)%>>
#!# 				<option <%=selectSessionVariable("choose_" & database & ".database_type","Redbrick", selectedVal)%>>
#!# 				<option <%=selectSessionVariable("choose_" & database & ".database_type","Excel", selectedVal)%>>
#!# 				<option <%=selectSessionVariable("choose_" & database & ".database_type","Foxpro", selectedVal)%>>
#!# 				<option <%=selectSessionVariable("choose_" & database & ".database_type","MYOB", selectedVal)%>>
#!# 				<option <%=selectSessionVariable("choose_" & database & ".database_type","Mysql", selectedVal)%>>
#!# 				<option <%=selectSessionVariable("choose_" & database & ".database_type","Interbase", selectedVal)%>>
#!# 				<option <%=selectSessionVariable("choose_" & database & ".database_type","Firebird", selectedVal)%>>
#!# 				<option <%=selectSessionVariable("choose_" & database & ".database_type","Faircom", selectedVal)%>>
#!# 				<option <%=selectSessionVariable("create_mapping.database_type_preset","PervasiveSQL", selectedVal)%>>
#!# 				<option <%=selectSessionVariable("choose_" & database & ".database_type","Other", selectedVal)%>>
#!# 			</select> 			<font color=red><%=session("choose_" & database & ".database_type.error")%></font> 		</td> 	</tr> 	<tr><td colspan=2 height=10></td></tr> 	 	<tr> 		<td class="welcomedesc" colspan=2>
#!#</td> 	</tr> 	<tr> 	<% 	if isobject(odbcList) then%> 		<td valign=top><input type=radio name=<%=database%>.useDSN <%if session("choose_" & database & ".useDSN")="Yes" then response.write "CHECKED"%> value="Yes"><b>
#!#</b></td> 		<td align=left valign=top> 			<table> 				<tr> 					<td align=right><i>
#!#</i></td> 					<td> 					<% 						set odbcSources=odbcList.getDataSources(SQL_FETCH_FIRST_SYSTEM)%> 						<select name=<%=database%>.dsn> 						<% 						dsnStillExists=false 						for each key in odbcSources.keys 							selectedStatus="" 							if key=session("choose_" & database & ".dsn") then 								selectedStatus="SELECTED" 								dsnStillExists=true 							end if%> 							<option <%=selectedStatus%> value="<%=key%>"><%=key%> 						<%next 						set odbcSources=nothing 						%> 						</select> 						<%if useDSN="Yes" and not dsnStillExists then%> 							<font color=red>
#!# <i><%=session("choose_" & database & ".dsn")%></i> no longer available</font> 						<%end if%> 					</td> 				</tr> 				<tr> 					<td align=right><i>
#!#</i></td> 					<td><input type=text name=<%=database%>.database_username value="<%=session("choose_" & database & ".database_username")%>" size=14></td> 				</tr> 				<tr> 					<td align=right><i>
#!#</i></td> 					<td><input type=password name=<%=database%>.database_password value="<%=session("choose_" & database & ".database_password")%>" size=14></td> 				</tr> 			</table> 		</td> 	</tr> 	<% 	else 		session("choose_" & database & ".useDSN")="No" 	end if 	%>  	<tr> 		<td valign=top><input type=radio name=<%=database%>.useDSN  <%if session("choose_" & database & ".useDSN")="No" then response.write "CHECKED"%> value="No"><b>
#!#</b></td> 		<td align=left valign=top><input type=text name=<%=database%>.database_string size=40 value="<%=session("choose_" & database & ".database_string")%>"><font color=red><%=session("choose_" & database & ".database_string.error")%></font> 	</tr> 	 	<tr><td colspan=2 height=10></td></tr> 	<tr> 		<td valign=top class="label">
#!# 'Store session values session("choose_" & database & ".database_type")=request(database & ".database_type") session("choose_" & database & ".useDSN")=request(database & ".useDSN") session("choose_" & database & ".dsn")=request(database & ".dsn") session("choose_" & database & ".database_username")=request(database & ".database_username") session("choose_" & database & ".database_password")=request(database & ".database_password") session("choose_" & database & ".database_string")=request(database & ".database_string")  'Should check database connection - redirect back if there is an error %> <BR><font size=+1><b>
#!#</b> <i><%=database%> ...</i></font> <% if database="source" then 	getSourceConn(true) else 	getDestinationConn(true) end if %> <i>
#!#</i>  <% for i=1 to 2 	initial_command=trim(request(database & ".initial_command" & i)) 	if len(initial_command)>0 then%> 		<BR><font size=+1><b>
#!#</b> <i><%=initial_command%> ...</i></font> 		<% 		errMsg="" 		if database="source" then 			call sourceExecute(false, initial_command, errMsg) 		else 			call destinationExecute(false, initial_command, errMsg) 		end if 		if len(trim(errMsg))>0 then%> 			<font color=red><%=errMsg%></font> 			<%response.end 		else%> 			<i>
#!#TRANSFERING DATA...
#!#Another transfer?
#!#Select a different database?
#!#Back to Administration?
#!#Error when inserting data
#!#Transfer to
#!#completed
#!#rows in
#!#Transfer complete
#!#Transferring table:
#!#There was an error trying to connect to your database
#!#The reason is that your database is not accessible <br> 				or your database connection setup is invalid
#!#When trying to connect the following error was generated 
#!#Report Display
#!#Horiz. Bar (Grouped)
#!#Horiz. Bar (Stacked)
#!#Horiz. Bar (Stacked %)
#!#Vert. Bar (Grouped)
#!#Vert. Bar (Stacked)
#!#Vert. Bar (Stacked %)
#!#Horiz. Bar
#!#Display Quantity
#!#Comparison Display
#!#%-Var
#!#Var
#!#IR Links
#!#User Documentation
#!#Error: Topic '%1%'
#!#%1 by 
#!#Go
#!#&copy; Copyright Interactive Reporting 2005
#!#LICENSE EXPIRED
#!#%1 days remaining
#!#Show/Hide Frame
#!#Report Tasks
#!#Print Report
#!#Save Report
#!#&lt;&lt;Back
#!#The application does not function beyond 2036 - is your system date correct?
#!#You have exceeded the maximum number of simultaneous licensed users - 
#!#Allocated new License
#!#timer
#!#current id
#!#Please contact %1%  to obtain a valid license or to purchase more licenses.
#!#Do you already have a new license?
#!#Your license has expired
#!#You do not have a license installed
#!#Invalid license installed
#!#License not appropriate to 
#!#License not appropriate to this version
#!#License
#!#Installation
#!#demo license
#!#Your
#!#expired on
#!#Never
#!#Demo - expires
#!#Add a New Calculated Variable
#!#Edit Calculated Variable
#!#Update/Modify Calculated Variable <i>%1%</i>
#!#Type
#!#Number
#!#Currency $$
#!#Percentage %
#!#Top/Bottom Order By
#!#% of Total
#!#Charting
#!#Order Position
#!#Font Color
#!#Click Here to Pick up the color
#!#Font Size
#!#Font Style
#!#bold
#!#italic
#!#Threshold Value
#!#Threshold Colour
#!#Number of Digits
#!#Condition
#!#value if true
#!#Divided by ( / )
#!#Measure must be unique
#!#This name is used for a Lookup
#!#This name is used for a Number
#!#The 'iif' function cannot be used with the <i>Conditional Sum</i> option
#!#The option 'Comparison Delta' can only be checked if 'Comparison Report' is checked
#!#You must specify a numeric value
#!#You must specify a positive number of digits
#!#There is a parenthesis missing
#!#The <i>Weighted Sum</i> function requires a Non Blank denominator
#!#The <i>%1%</i> function requires a Blank denominator
#!#There is division by 0
#!#Mathematical operators are not allowed at the beginning or end of the expression
#!#Incomplete formula in the expression
#!#'today' does not take any arguments
#!#The '%1%' function must have 2 arguments
#!#There is an argument missing in the '%1%' function
#!#The first argument of '%1%' must be a Date
#!#The argument of '%1%' must be integer
#!#The arguments of the '%1%' function must be existing Date Lookups
#!#'%1%' is an invalid date
#!#The arguments of the '%1%' function must be Dates or Integers
#!#The subterms of the expression must be existing Variables or Lookups
#!#Only Variables or only Dates should be used in the expression
#!#The 'iif' function must have 3 arguments
#!#There is an argument missing in the 'iif' function
#!#Create  a New Template
#!#Modify/Update the Template <i>%1%</i>
#!#Edit Schema
#!#Num Default Dropdowns
#!#Default Analyze By
#!#Restricted Analyze By
#!#User Security
#!#Secondary User Security
#!#Group Security
#!#To choose values for the Advanced option \n fields you must first add Lookups.
#!#When you add \n your Lookups you can select the values \n you want from the dropdown lists.
#!#Edit/Add Numbers
#!#Add Variable
#!#Add a New Variable
#!#Edit Variable
#!#Update/Modify Variable <i>%1%</i>
#!#Currency
#!#Default Value
#!#Required
#!#No
#!#Yes
#!#Upper case letters are not allowed
#!#Number must be unique
#!#This name is used for a Calculated Variable.
#!#Must be a Number or Empty
#!#Schema Export
#!#Export Schema
#!#Schema Import
#!#Import a Template by Choosing from a Source File
#!#Error importing template:
#!#Error: not a template
#!#A template by this name is already installed.
#!#Would you like to upgrade it?
#!#No Such Template
#!#Warning: Clone Failure
#!#There is an empty cell in %2% of %3%.
#!# Check row with 
#!# '%1%' is not an allowed value of '%2%' in %3%.
#!# Check row with %4%=%5% and %6%=%7% 
#!#%1% in %2% of Template <i> %3% </i>should not be empty.
#!#%1% in %2% should not be empty.
#!#Check row with %3% = %4%
#!#Check row with %3% = %4% and %5%= %6%
#!#The Principal Table name '%1%' is not a valid name.
#!#It should correspond to a name from the ""Table Name"" field.
#!#schema_table_id %1% of schema_items does not exist in schema_tables.
