CrosstabAnalysisTool MembersA Sandcastle Documented Class Library

The CrosstabAnalysisTool type exposes the following members.
Constructors

  NameDescription
Public methodCrosstabAnalysisTool
Initializes a new instance of the CrosstabAnalysisTool class
Back to Top
Methods

  NameDescription
Public methodAppLogLogin
Simplified method for logging application login attempts.
(Inherited from BasePageStandard.)
Public methodAppLogLogout
Simplified method for logging application logout attempts.
(Inherited from BasePageStandard.)
Public methodAppLogPage
Simplified method for logging application page access.
(Inherited from BasePageStandard.)
Private methodBindChartData
Binds form data to the grid.
Protected methodbtnCsv_Click
Processes a download CSV request.
Protected methodbtnRefresh_Click
Refreshes this page with a clean new load.
Protected methodbtnRender_Click
Handles running the crosstab render routine on button click event.
Protected methodbtnSaveView_Click
Event handler for the save button. Saves the view configuration for the page and report.
Protected methodbtnSql_Click
Returns a query result packet for this report query.
Protected methodbtnTab_Click
Processes a download TAB request.
Protected methodbtnXls_Click
Processes a download XLS request.
Private methodBuildForm
Builds any dynamic aspects of the form for display.
Protected methodcbRemoveEmpty_CheckedChanged
Handles setting the remove empty rows/columns boolean flag in the session.
Protected methodcbRemoveNull_CheckedChanged
Handle a change in the remove nulls checkbox.
Protected methodcbRemoveOther_CheckedChanged
Handle a change in the remove others checkbox.
Protected methodcbRemoveUnknown_CheckedChanged
Handles a change in the remove unknowns checkbox.
Public methodCheckForExpiration
Checks to see if the given user account is expired or not
(Inherited from BasePageStandard.)
Public methodCheckForInjection
Checks for sql statements in queries.
(Inherited from BasePageStandard.)
Public methodCheckPagePermission
Calling method for CheckPermissions, loads up a reference to the service client before calling the CheckPermissions method.
(Inherited from BasePageStandard.)
Private methodCheckPassThrough
Checks the session for a pass through request.
Public methodCheckPermissions
Checks the current page permissions by pageName, userId, and userRolesId.
(Inherited from BasePageStandard.)
Protected methodddlColumnHeaderColumn1_SelectedIndexChanged
Column entry 1, column.
Protected methodddlColumnHeaderColumn2_SelectedIndexChanged
Column entry 2, column.
Protected methodddlColumnHeaderColumn3_SelectedIndexChanged
Column entry 3, column.
Protected methodddlColumnHeaderTable1_SelectedIndexChanged
Column entry 1, table.
Protected methodddlColumnHeaderTable2_SelectedIndexChanged
Column entry 2, table.
Protected methodddlColumnHeaderTable3_SelectedIndexChanged
Column entry 3, table.
Protected methodddlRowHeaderColumn1_SelectedIndexChanged
Row entry 1, column.
Protected methodddlRowHeaderColumn2_SelectedIndexChanged
Row entry 2, column.
Protected methodddlRowHeaderColumn3_SelectedIndexChanged
Row entry 3, column.
Protected methodddlRowHeaderTable1_SelectedIndexChanged
Row entry 1, table.
Protected methodddlRowHeaderTable2_SelectedIndexChanged
Row entry 2, table.
Protected methodddlRowHeaderTable3_SelectedIndexChanged
Row entry 3, table.
Protected methodddlStartingColumnHeader_SelectedIndexChanged
Handle a change in the starting column header.
Protected methodddlStartingRowHeader_SelectedIndexChanged
Handle a change in the starting row header.
Private methodDisableExports
Private methodEnableExports
Private methodFailPassThrough
Fails the pass through request, writes a txt file to mark the failure.
Private methodFindDataRow
Private methodFindStartIdx
Protected methodGetActiveFilter
Returns the active filter from the filter object manager if there is one.
(Inherited from BasePageStandard.)
Protected methodGetActiveFilterActiveReport
Returns the ReportObj if there is an active filter with a report at the Session stored index 'reportIndex'.
(Inherited from BasePageStandard.)
Protected methodGetActiveFilterActiveStat
Returns the ReportObj if there is an active filter with a report at the Session stored index 'reportIndex'.
(Inherited from BasePageStandard.)
Protected methodGetActiveFilterId
Returns the active filter's filter ID.
(Inherited from BasePageStandard.)
Protected methodGetActiveFilterReportAt
Returns the active filter's report at the provided index.
(Inherited from BasePageStandard.)
Protected methodGetActiveFilterStatAt
Returns the active filter's statistic at the provided index.
(Inherited from BasePageStandard.)
Protected methodGetActiveReportId
Returns the active report id or new if the report is a new report.
(Inherited from BasePageStandard.)
Protected methodGetActiveReportIndex
Returns the active report index.
(Inherited from BasePageStandard.)
Protected methodGetActiveReportIndexStr
Returns the active report index as a string.
(Inherited from BasePageStandard.)
Protected methodGetActiveStatId
Returns the active report id or new if the report is a new report.
(Inherited from BasePageStandard.)
Protected methodGetActiveStatIndex
Returns the active report index.
(Inherited from BasePageStandard.)
Protected methodGetActiveStatIndexStr
Returns the active report index as a string.
(Inherited from BasePageStandard.)
Public methodGetAdminUserRole
Returns the Admin user role id as a string.
(Inherited from BasePageStandard.)
Protected methodGetFilterObjManager
Returns the filter object manager.
(Inherited from BasePageStandard.)
Protected methodGetHasActiveFilter
Returns true if there is an active filter.
(Inherited from BasePageStandard.)
Protected methodGetHasActiveFilterActiveReport
Returns true if there is an active filter with a report at the Session stored index 'reportIndex'.
(Inherited from BasePageStandard.)
Protected methodGetHasActiveFilterActiveStat
Returns true if there is an active filter with a stat at the Session stored index 'statIndex'.
(Inherited from BasePageStandard.)
Protected methodGetHasActiveFilterReportAt
Returns true if there is an active filter with a report at the provided index.
(Inherited from BasePageStandard.)
Protected methodGetHasActiveFilterStatAt
Returns true if there is an active filter with a stat at the provided index.
(Inherited from BasePageStandard.)
Protected methodGetHasFilterObjManager
Returns true if there is a current filter object manager.
(Inherited from BasePageStandard.)
Public methodGetP4sPsmsUserRole
Returns the P4s Psms user role id as a string.
(Inherited from BasePageStandard.)
Public methodHasPagePerm
Returns true if the user has the current perm enabled.
(Inherited from BasePageStandard.)
Private methodHideReportForm
Hides the report form.
Protected methodIsLoggedIn
Used to test whether the current user is logged in or not.
(Inherited from BasePageStandard.)
Private methodLoadColumnHeaderColumn1
Private methodLoadColumnHeaderColumn2
Private methodLoadColumnHeaderColumn3
Private methodLoadData
Public methodLoadPageFeaturePerms
Loads all the feature perms for this page.
(Inherited from BasePageStandard.)
Private methodLoadParsedData
Private methodLoadRowHeaderColumn1
Private methodLoadRowHeaderColumn2
Private methodLoadRowHeaderColumn3
Private methodLoadTables 
Private methodLoadTables(Boolean)
Protected methodPage_Error
Calls Page_Error from base class, BasePageStandard.
(Overrides BasePageStandard Page_Error(Object, EventArgs).)
Protected methodPage_Load
Standard Page_Load entrance method.
(Overrides BasePageStandard Page_Load(Object, EventArgs).)
Private methodPrepForm 
Prepares the form for use.
Private methodPrepForm(Boolean)
Prepares the form for use.
Private methodPrepNewForm
Prepares the form for use.
Private methodRefreshList
Refreshed the current page, handle all dynamic html here.
Public methodRunAppLogLogin
Async execution of the app login method.
(Inherited from BasePageStandard.)
Public methodRunAppLogLogout
Async execution of the app logout method.
(Inherited from BasePageStandard.)
Public methodRunAppLogPage
Async execution of the app page method.
(Inherited from BasePageStandard.)
Private methodSetSession (Inherited from BasePageStandard.)
Private methodShowNoColumnsForm
Shows the no columns found form.
Private methodShowNoDataForm
Hides all forms and shows the no data form.
Private methodShowNoFiltersForm
Hides all forms and shows the no filters form.
Private methodShowReportForm
Hides all forms and shows the regular report form.
Back to Top
Fields

  NameDescription
Protected fieldbnp
bnp control.
Protected fieldbtnCsv
btnCsv control.
Protected fieldbtnRefresh
btnRefresh control.
Protected fieldbtnRender
btnRender control.
Protected fieldbtnSaveView
btnSaveView control.
Protected fieldbtnSql
btnSql control.
Protected fieldbtnTab
btnTab control.
Protected fieldbtnXls
btnXls control.
Protected fieldcbRemoveEmpty
cbRemoveEmpty control.
Protected fieldcbRemoveNull
cbRemoveNull control.
Protected fieldcbRemoveOther
cbRemoveOther control.
Protected fieldcbRemoveUnknown
cbRemoveUnknown control.
Protected fieldddlColumnHeaderColumn1
ddlColumnHeaderColumn1 control.
Protected fieldddlColumnHeaderColumn2
ddlColumnHeaderColumn2 control.
Protected fieldddlColumnHeaderColumn3
ddlColumnHeaderColumn3 control.
Protected fieldddlColumnHeaderTable1
ddlColumnHeaderTable1 control.
Protected fieldddlColumnHeaderTable2
ddlColumnHeaderTable2 control.
Protected fieldddlColumnHeaderTable3
ddlColumnHeaderTable3 control.
Protected fieldddlRowHeaderColumn1
ddlRowHeaderColumn1 control.
Protected fieldddlRowHeaderColumn2
ddlRowHeaderColumn2 control.
Protected fieldddlRowHeaderColumn3
ddlRowHeaderColumn3 control.
Protected fieldddlRowHeaderTable1
ddlRowHeaderTable1 control.
Protected fieldddlRowHeaderTable2
ddlRowHeaderTable2 control.
Protected fieldddlRowHeaderTable3
ddlRowHeaderTable3 control.
Protected fieldddlStartingColumnHeader
ddlStartingColumnHeader control.
Protected fieldddlStartingRowHeader
ddlStartingRowHeader control.
Protected fielddGrid
dGrid control.
Protected fielddvReport
dvReport control.
Protected fielddvReportNoData
dvReportNoData control.
Protected fielddvReportNoFilters
dvReportNoFilters control.
Protected fieldfhp
fhp control.
Protected fieldfileName
The current page as a file name.
(Inherited from BasePageStandard.)
Protected fieldfileNameShort
The current page as a file name with no extension.
(Inherited from BasePageStandard.)
Protected fieldforceNoColumnTest
Driven by a web config setting to force a no data returned test on every data loading/viewing page.
(Inherited from BasePageStandard.)
Protected fieldforceNoDataTest
Driven by a web config setting to force a no data returned test on every data loading/viewing page.
(Inherited from BasePageStandard.)
Protected fieldforceNoReportTest
Driven by a web config setting to force a no data returned test on every data loading/viewing page.
(Inherited from BasePageStandard.)
Protected fieldForm1
Form1 control.
Protected fieldignoreInjection
Ignore the injection checks while true.
(Inherited from BasePageStandard.)
Protected fieldignoreTimeout
If set to true ignores timeout processing and redirection.
(Inherited from BasePageStandard.)
Private fieldIS_POSTBACK (Inherited from BasePageStandard.)
Protected fieldisLoggedIn
Is set to true if the user is currently logged in.
(Inherited from BasePageStandard.)
Private fieldisPassThrough
Used to indicate that the web page is in pass through mode.
Protected fieldkey
A secret key needed to talk to the web service client.
(Inherited from BasePageStandard.)
Protected fieldlblCellsPerBlock
lblCellsPerBlock control.
Protected fieldlblColHeader
lblColHeader control.
Protected fieldlblColumnHeaderColumn1
lblColumnHeaderColumn1 control.
Protected fieldlblColumnHeaderColumn2
lblColumnHeaderColumn2 control.
Protected fieldlblColumnHeaderColumn3
lblColumnHeaderColumn3 control.
Protected fieldlblColumnHeaderTable1
lblColumnHeaderTable1 control.
Protected fieldlblColumnHeaderTable2
lblColumnHeaderTable2 control.
Protected fieldlblColumnHeaderTable3
lblColumnHeaderTable3 control.
Protected fieldlblRemoveEmpty
lblRemoveEmpty control.
Protected fieldlblRemoveNull
lblRemoveNull control.
Protected fieldlblRemoveOther
lblRemoveOther control.
Protected fieldlblRemoveUnknown
lblRemoveUnknown control.
Protected fieldlblRenderColumns
lblRenderColumns control.
Protected fieldlblRenderRows
lblRenderRows control.
Protected fieldlblRenderTime
lblRenderTime control.
Protected fieldlblRowCount
lblRowCount control.
Protected fieldlblRowHeader
lblRowHeader control.
Protected fieldlblRowHeaderColumn1
lblRowHeaderColumn1 control.
Protected fieldlblRowHeaderColumn2
lblRowHeaderColumn2 control.
Protected fieldlblRowHeaderColumn3
lblRowHeaderColumn3 control.
Protected fieldlblRowHeaderTable1
lblRowHeaderTable1 control.
Protected fieldlblRowHeaderTable2
lblRowHeaderTable2 control.
Protected fieldlblRowHeaderTable3
lblRowHeaderTable3 control.
Protected fieldlblStartingColumnHeader
lblStartingColumnHeader control.
Protected fieldlblStartingRowHeader
lblStartingRowHeader control.
Protected fieldlblTotalCells
lblTotalCells control.
Protected fieldStatic memberMAX_CELLS_PER_BLOCK
The maximum cells per block this cross tab page supports.
Protected fieldStatic memberMAX_TOTAL_CELLS
The current maximum total cells allowed.
Protected fieldStatic memberMAX_XLS_COLS
The maximum number of columns a worksheet can have.
Protected fieldStatic memberMAX_XLS_ROWS
The maximum number of rows a worksheet can have.
Protected fieldmaxBulkExpRows
The maximum number of rows supported in a bulk export operation/
(Inherited from BasePageStandard.)
Protected fieldmaxExpRows
Sets the maximum number of rows donwloads will be supported on.
(Inherited from BasePageStandard.)
Protected fieldmaxJsonCols
The maximum number of JSON columns supported in converting a DataTable to JSON format.
(Inherited from BasePageStandard.)
Protected fieldmaxJsonRows
The maximum number of JSON rows supported in converting a DataTable to JSON format.
(Inherited from BasePageStandard.)
Protected fieldmaxRowReturn
Sets the maximum row return for the data grid view.
(Inherited from BasePageStandard.)
Protected fieldmaxToolRows
The maximum number of rows allowed in complex tools.
(Inherited from BasePageStandard.)
Protected fieldmessage
message control.
Protected fieldmfp
mfp control.
Protected fieldmmp
mmp control.
Private fieldMSG (Inherited from BasePageStandard.)
Protected fieldpageFeaturePerms
List of features permissions granted by page.
(Inherited from BasePageStandard.)
Protected fieldpageIntro
pageIntro control.
Protected fieldrootDir
THe current parent directory of the page.
(Inherited from BasePageStandard.)
Protected fieldrowsFound
Represents the number of rows found for the given report.
Protected fieldrUrl
The current URL of this page.
(Inherited from BasePageStandard.)
Protected fieldrUrlLower
The current URL of this page in lowercase form.
(Inherited from BasePageStandard.)
Protected fieldScriptmanager1
Scriptmanager1 control.
Private fieldSession
Static self reference to the current Session. New keyword lets the system know we are intentionally overriding the Session.
(Inherited from BasePageStandard.)
Protected fieldsessionPrefix
Stores the local page's session prefix, used for advanced session management.
(Inherited from BasePageStandard.)
Protected fieldsvc
A P4S3 Web Service client.
(Inherited from BasePageStandard.)
Protected fieldtempDir
The local temp directory for this web application.
(Inherited from BasePageStandard.)
Protected fielduserId
The active userId.
(Inherited from BasePageStandard.)
Protected fielduserRoleId
The current user's role id.
(Inherited from BasePageStandard.)
Back to Top
See Also