Skip to content

Navigate the Reports catalog and avoid parameter gotchas

What the screen looks like

Sidebar > REPORTS opens to a flat row of category tabs — LOCAL, EMPLOYER, MEMBER, and a fourth tab that follows the logged-in account's Fund rather than its role: Union/All fund accounts see ACCOUNTING, H&W fund accounts see H & W, ETF fund accounts see ETF. Each tab is just a list of report-name buttons — there's no grid, no filter, no record to select first. Clicking a report name opens an SSRS report modal with its own parameter screen (dropdowns, checkbox-pickers, date fields depending on the report), a View Report button, and Print/Cancel controls.

The report modal intercepts every click until you close it

The modal's iframe sits in front of the rest of the page and swallows clicks aimed at anything else — including the next Reports tab — until it's explicitly dismissed via its own Cancel/close control. Clicking around it instead of closing it first will hang or time out. This has been confirmed on the Per Capita Summary report and is assumed to hold for every other report in this module, since they all share the same SSRS modal mechanism.

Quickbooks Extract: the signed QB-format export

Quickbooks Extract (FDD Reports Common 5.13) is a signed report that packages posted bank deposits — selected by Fund Group and a From/To date range — into IIF (Intuit Interchange Format) transactions for posting as general journal entries in QuickBooks. It covers only payments received (not HRA claim payouts or adjustments), produces one transaction per deposit with a TRNS record for the bank account and an SPL record per GL code, and still requires a manual step outside PRIZM: downloading the report and re-saving it as IIF before QuickBooks will import it. It appears under Reports\Accounting, Reports\H&W, and Reports\ETF, with the Fund Group dropdown's choices following which tab it was opened from.

A fund-segregation question here is usually a GL-code mapping question, not a bug

IUOE-2667 confirmed the QB extract segregates strictly by each transaction type's configured Fund mapping (per the signed FDD), not by the transaction's real-world content — a transaction type mapped to Union will appear in the Union extract even if it's operationally a different fund's money. If a transaction looks like it's in the "wrong" fund's export, check that transaction type's Fund mapping before assuming the report is broken; remapping it is a Change Order, not a defect fix.

Things to watch out for

Checkbox-picker parameters fail in two different ways, and they look identical

Every multi-value report parameter (Employer, Invoice Number, Jobsite, and others shaped like them) uses the same checkbox-picker widget, but the "No X Selected" placeholder it defaults to behaves two different ways depending on the specific parameter:

  • Hang-forever placeholders (seen on Employer, Invoice Number): checking a real value without first unchecking the placeholder makes the report hang on "Loading..." forever, with no error and no timeout.
  • Literal-filter placeholders (seen on Jobsite): the same-looking default isn't a hang risk — it's a genuine filter for records with no value in that field. Since most real data has a value, leaving the default renders a silently blank report ("Page 1 of 1," nothing underneath, no error) that looks identical to a true zero-match result. Check "(Select All)" instead of trusting the default.

There's no way to tell which failure mode a given parameter uses just by looking at it — treat every "No X Selected" default with suspicion. To close a picker popup without discarding your selection, click the field's own label text — never press Escape, which reverts the selection.

Period dropdowns are not a fixed calendar list

A report's Period (or similar date-range) dropdown can reshuffle which periods are available between one run and the next, with no action of yours touching it — this has been observed directly in the shared UAT environment (a period present in one run was gone a few minutes later with nothing in between but unrelated activity elsewhere in the system). Don't assume a period you saw earlier is still there; re-check the dropdown's live contents before relying on a specific one.

Give a report time to finish rendering before trusting a blank result

SSRS report render timing is inconsistent across reports — some populate in 2-3 seconds, others (Journal Entry by GL Code, specifically) have shown a genuinely blank/zero-row result at 4 seconds that fully populated by 6 seconds with the identical query. An early screenshot or a quick glance isn't proof a report has no data — give it time, especially on reports you haven't run before.

Fund scoping follows the top-nav Fund switcher, not just the report category

Which category tab you see (ACCOUNTING vs. H & W vs. ETF) is already Fund-determined. Several reports under ACCOUNTING/H&W/ETF have a Fund Group parameter of their own inside the report (a plain dropdown, not a checkbox-picker) that's tied to whichever Fund is active in the top-nav switcher when you open the report — check that it's set to the fund you actually mean before reading the results, rather than assuming the category tab alone scoped it.

See Run a dues delinquency or Assessment report, Run a Membership PerCap or Activity report, and Run an H&W or compliance report for what's known about specific reports built on top of these mechanics.

Who can do this

Role Access
Super User View Only
Business Agent View Only
Management View Only
Membership Staff View Only
Accounting View Only
Contract View Only
H&W Staff View Only
ETF Staff View Only

Every role that can see the Reports module at all gets the same View Only access to the LOCAL/EMPLOYER/MEMBER/ACCOUNTING/ETF categories — there's no Add/Update anywhere in this module, by design; a report is read-only output, never an editable record. (The one category that isn't uniformly visible — H&W — is covered on its own page: see Run an H&W or compliance report.)

Anyone running any report in this catalog — a Business Agent pulling a delinquency letter batch, an Accounting user cross-checking a GL report, a Membership Staff member printing mailing labels — is working through the same underlying SSRS widget mechanics. This page covers those mechanics once, since they recur on nearly every report screen rather than being specific to any one of them.