Creakinator
Programmer
Some day I hope to understand how to do things in CR. Right now I am so grateful for the helpful folks in this forum.
I have a report that has this data
Incident_Type Case# Approval Type Assigned date Esig date Turn around time
Burglary 11-1111 analyst 11/11/2011 11/12/2011
Burglary 11-1111 Verifier 11/13/2011 11/14/2011
I would like the report to show this data:
Incident_Type Case# Assigned date Esig date Turn around time
Burglary 11-1111 11/11/2011* 11/14/2011** 3***
* The analyst Assigned date I tried using a formula "if {X_APPROVAL.APPROVAL_TYPE} = "ANALYST" then {X_APPROVAL.ASSIGNED_DATE}" and put it in the 4th group footer
**The verifier Esig date I tried using a formula "if {X_APPROVAL.APPROVAL_TYPE} = "VERIFIER" then {X_APPROVAL.ASSIGNED_DATE}" and put it in the 4th group footer
***The turn around time = Verifier Esig date - analyst Assigned date
My above mentioned tries didn't help me.
The date data is in one table called x_approval with these field;
x_approval.assigned_date
x_approval.esig_date
x_approval.approval_type
The incident_type is coming from another table - v_parentCase_info
Here's the select criteria:
{LIST_ENTRY.LIST} = "INCIDENTS" and
{CASES.TEMPLATE} = "LATENT_PRT" and
{X_APPROVAL.APPROVAL_TYPE} in ["ANALYST", "VERIFIER"]
I uploaded the relationship screen and group selection (upper right of image) to mediafire if that will help you.
Sql 2005 with an ODBC connection
Thank you.
Christy
I have a report that has this data
Incident_Type Case# Approval Type Assigned date Esig date Turn around time
Burglary 11-1111 analyst 11/11/2011 11/12/2011
Burglary 11-1111 Verifier 11/13/2011 11/14/2011
I would like the report to show this data:
Incident_Type Case# Assigned date Esig date Turn around time
Burglary 11-1111 11/11/2011* 11/14/2011** 3***
* The analyst Assigned date I tried using a formula "if {X_APPROVAL.APPROVAL_TYPE} = "ANALYST" then {X_APPROVAL.ASSIGNED_DATE}" and put it in the 4th group footer
**The verifier Esig date I tried using a formula "if {X_APPROVAL.APPROVAL_TYPE} = "VERIFIER" then {X_APPROVAL.ASSIGNED_DATE}" and put it in the 4th group footer
***The turn around time = Verifier Esig date - analyst Assigned date
My above mentioned tries didn't help me.
The date data is in one table called x_approval with these field;
x_approval.assigned_date
x_approval.esig_date
x_approval.approval_type
The incident_type is coming from another table - v_parentCase_info
Here's the select criteria:
{LIST_ENTRY.LIST} = "INCIDENTS" and
{CASES.TEMPLATE} = "LATENT_PRT" and
{X_APPROVAL.APPROVAL_TYPE} in ["ANALYST", "VERIFIER"]
I uploaded the relationship screen and group selection (upper right of image) to mediafire if that will help you.
Sql 2005 with an ODBC connection
Thank you.
Christy