Hello,

I'm new to reporting.

Running the Identity Tracking Password Changes report and I get no
results. The report is empty. I'm trying to find out why.

The RDD: [sentinel.identity.rdd] Identity Currency data sync runs OK and
I have set the start time to 2013 Dec 2 00:00:00

The table it syncs to contains 1483 rows when I look at it using pgAdmin.

First question: What does the summary_time column mean in that table?

When I run the report it reports on the following period:

June 7, 2013 12:00:00 AM to December 3, 2013 11:59:59 PM CET

Where are those dates set? I.e. where can I find them in the report
definition?

How are the FromDate/FromDtQry and ToDate/ToDtQry parameters passed to
the report? Where can I find that information?

The report SQL query from iReport:

************************************************** ***********
SELECT
MAX("$P!{IdentityCurrencyTable}".summary_time) AS LAST_LOGIN_TIME,
USR_ACCOUNT_RPT_V.USER_NAME AS TARGET_USER_NAME,
USR_ACCOUNT_RPT_V.USER_DOMAIN AS TARGET_USER_DOMAIN,
TARGET_USR_IDENTITY.FULL_NAME AS FULL_NAME,
cast(TARGET_USR_IDENTITY.IDENTITY_GUID AS char(36)) AS TARGET_IDENTITY_GUID
FROM
$P!{IdentityCurrencyTable} AS "$P!{IdentityCurrencyTable}"
INNER JOIN CUST_RPT_V ON
"$P!{IdentityCurrencyTable}".rv39 = CUST_RPT_V.CUSTOMER_NAME
LEFT OUTER JOIN USR_IDENTITY_RPT_V AS TARGET_USR_IDENTITY ON
"$P!{IdentityCurrencyTable}".tuident = TARGET_USR_IDENTITY.IDENTITY_GUID
LEFT OUTER JOIN USR_ACCOUNT_RPT_V ON
CUST_RPT_V.CUST_ID = USR_ACCOUNT_RPT_V.CUST_ID AND
"$P!{IdentityCurrencyTable}".dun = USR_ACCOUNT_RPT_V.USER_NAME AND
"$P!{IdentityCurrencyTable}".rv45 = USR_ACCOUNT_RPT_V.USER_DOMAIN
WHERE
("$P!{IdentityCurrencyTable}".summary_time >= $P{FromDtQry} AND
"$P!{IdentityCurrencyTable}".summary_time <= $P{ToDtQry}) AND
(USR_ACCOUNT_RPT_V.CURRENT_F = TRUE OR USR_ACCOUNT_RPT_V.CURRENT_F =
't') AND
("$P!{IdentityCurrencyTable}".xdasclass = 0 AND
"$P!{IdentityCurrencyTable}".xdasid = 6) AND
TARGET_USR_IDENTITY.DEPARTMENT_NAME like $P{Dept} AND
TARGET_USR_IDENTITY.FULL_NAME IS NOT NULL
GROUP BY
USR_ACCOUNT_RPT_V.USER_NAME,
USR_ACCOUNT_RPT_V.USER_DOMAIN,
TARGET_USR_IDENTITY.IDENTITY_GUID,
TARGET_USR_IDENTITY.FULL_NAME
ORDER By
FULL_NAME,
TARGET_IDENTITY_GUID,
LAST_LOGIN_TIME
************************************************** *************