Update 4/6/2023: Upgrade: changed so that only shown rows are used against MaxRecords counts.
Update 10/31/2022: Bug fix: using Help Mode to display Content Codes
Update 7/7/2022: Upgrade: upgraded support for delimited download files in qualifying values.
Update 4/8/2022: Upgrade: when using filter negating, ex "!active" (to negate any records with 'active' in the value), it 'was' case sensitive. It is no longer case-sensitive.
Update 10/29/2021: Upgrade: upgraded character encoding (re-escaping) for web form values.
Update 9/29/2021: Upgrade: upgraded to .NET 4.8 to support TLS 1.2/1.3.
Update 7/19/2021: Adjustment: changed how AD properties are enumerated.
Update 7/7/2021: Bug fix: replacing flags (like yyyymmdd) in filenames when downloading report.
Update 5/3/2021: Doc fix: removed duplicated lcc:loginUserId sections.
Update 4/22/2021: Upgrade: Removed some debug information lines.
Update 4/21/2021: Upgrade: Added query flag UserCanHideColumns.
Update 4/19/2021: Upgrade: (windows mode) Form recreated after each search (instead of closing). Report paths flags (date/time) updated with current time on each new report creation. Added column flags 'httpLink', 'httpLinkTarget'.
Update 3/19/2021: Upgrade: (web mode) Added query flag 'AutoScrollToRecords'.
Update 3/1/2021: Upgrade: (web mode) Added which portal id is being accessed.
Update 2/26/2021: Upgrade: Improved 'AddColumn' module to handle adding decimal numbers better.
Update 2/25/2021: Update: Added note in whitepaper about domain account usage in SQL connections. Added column flag AddColumnResetAtColumnChange.
Update 2/24/2021: Upgrade: Added column flag AddColumn.
Update 2/22/2021: Upgrade: reformat multi-line values in reports to single line, i.e. replace new line with space.
Update 2/17/2021: Upgrade: new column flag "MaskValue". Bug Fix: when using Login Id/Password in Logic File and LDAP, security was not holding between page refreshes in 'web' mode.
Update 2/10/2021: Change: lcc:helpMode can be activated when not in Debug Mode. Upgrade: (web mode) jump to report after filters applied.
Update 2/9/2021: Upgraded: allow forward slash in filter values, so that dates can be entered. Added line break in 'web' mode, on column values containing new lines.
Update 2/8/2021: Upgraded: added User Filter Flags. Added ability to find records that have 'empty' values, or negate rows that have certain values. See section "User Filter Flags".
Update 2/5/2021: Upgraded: added Flag Replace section, capability.
Update 2/4/2021: Program released.
lccQueryReporter is a console, web, windows program created to provide a way to allow end users/batch files/etc. to run queries and produce reports.
Web Mode
Windows Mode
Console Mode