Using CRXI - I need some help with formulas along with the "summary" total add up values for the formulas based upon the result of either YES or NO.
MAIN REPORT
Here the basic data:
tblAccounts.AccountName
I'm summarizing this field based on "distinct count"
This provided me with 288 total and distinct accounts.
I have a subreport (data below) with linking by tblAccounts.AccountName.
SUBREPORT DATA
Account Name = Wealth Concepts
SUBREPORT
SO# Technician Time Log Reason SO Date PW Change
15269 John CSA - PM 02/18/13
15269 John Password Changed 02/18/13 YES
Account Name = Wellington Env
SO# Technician Time Log Reason SO Date PW Change
no data NO (should be displayed)
Account Name = Wheelchair Professionals
SO# Technician Time Log Reason SO Date PW Change
17188 BOB CSA - Phone Call 02/25/13 NO (should be displayed)
The main data is based upon a time log where the result = Password Changed
{tblSOLogs.TimeLogReason} = "Password Changed"
I created 2 formulas:
1. {@PasswordChangedSum}Formula:
If {@PasswordChangedYes} = TRUE then "Yes"
2. {@PasswordChangedYes} Formula:
{tblSOLogs.TimeLogReason} = "Password Changed"
What I need to finish the report is the following:
a. Out of the total # of accounts
1. HOw many had a Service Order.
2. Out of the total service orders, how many had password changed = yes?
3. Out of the total service orders, how many had password changed = no?
4. 2 different groups needed:
Password Changed = yes
Password Changed = no
The total number of SO's are to be unique. So if the account has any SO#, then the number 1 would be displayed. There are multiple time log reasons within 1 SO#.
There are some accounts that have no SO # and no time log.
Thanks for the help!
Need to sum the total number of SO's from the above count.
Need to define the total number of SO's by Password Changed = Yes and Password Changed = No and get a total of these also.
Thanks for the help!
MAIN REPORT
Here the basic data:
tblAccounts.AccountName
I'm summarizing this field based on "distinct count"
This provided me with 288 total and distinct accounts.
I have a subreport (data below) with linking by tblAccounts.AccountName.
SUBREPORT DATA
Account Name = Wealth Concepts
SUBREPORT
SO# Technician Time Log Reason SO Date PW Change
15269 John CSA - PM 02/18/13
15269 John Password Changed 02/18/13 YES
Account Name = Wellington Env
SO# Technician Time Log Reason SO Date PW Change
no data NO (should be displayed)
Account Name = Wheelchair Professionals
SO# Technician Time Log Reason SO Date PW Change
17188 BOB CSA - Phone Call 02/25/13 NO (should be displayed)
The main data is based upon a time log where the result = Password Changed
{tblSOLogs.TimeLogReason} = "Password Changed"
I created 2 formulas:
1. {@PasswordChangedSum}Formula:
If {@PasswordChangedYes} = TRUE then "Yes"
2. {@PasswordChangedYes} Formula:
{tblSOLogs.TimeLogReason} = "Password Changed"
What I need to finish the report is the following:
a. Out of the total # of accounts
1. HOw many had a Service Order.
2. Out of the total service orders, how many had password changed = yes?
3. Out of the total service orders, how many had password changed = no?
4. 2 different groups needed:
Password Changed = yes
Password Changed = no
The total number of SO's are to be unique. So if the account has any SO#, then the number 1 would be displayed. There are multiple time log reasons within 1 SO#.
There are some accounts that have no SO # and no time log.
Thanks for the help!
Need to sum the total number of SO's from the above count.
Need to define the total number of SO's by Password Changed = Yes and Password Changed = No and get a total of these also.
Thanks for the help!