Help on Sorting claims provided

[nathanwiley]

Hello again,

I am needing help showing / sorting out claims not given.

We provide assistance to households who heat with GAS, ELECTRIC, but if we provide a benefit to the GAS and not the ELECTRIC I need to know because you can't get help without an ELECTRIC claim. "without special approval"

Here is what I have,

{vwAVApplications.ApprovedForEAP} and
{vwAVEAPClaims.ProgramYear} = 2010 and
{vwAVEAPClaims.ClaimType} = "Electric, EAP" and
{vwAVApplications.HeatingFuel} in ["Coal", "Kerosene", "LP Gas", "Natural Gas", "Oil", "Wood"]

"Claim Type" I want to show who has received benefits without getting an electric claim.

I hope this is enough info, I am a newbie so thanks in advance for any help.

 

[lbass]

Why isn't electricity included as a heating fuel type?

Do you ONLY want to test fuel types with "Gas" (LP Gas, Natural Gas) in the field for the absence of an electric claim, or do you mean to test ALL fuel types for the absence of an electric claim?

-LB

 

[nathanwiley]

Yes it is a heating fuel, but for the families who heat with something other than electric, they are to receive a benefit on both gas and electric, if they received a benefit on the heat and NOT on the electric there is an error or those files need to be monitored for quality assurance.

Finding these very few files is not easy. So I need to find the families who received only a benefit on their heat source and none on their electric.

We call it, heating benefit without electric claim.

 

[lbass]

Please answer my second question.

-LB

 

[nathanwiley]

Sorry - Second Question "or do you mean to test ALL fuel types for the absence of an electric claim?"

Answer - If any heat source is used except electric. (Our program requires an electric claim with a heating claim, if a heating claim has no electric claim then it could be a mistake)

I hope this helps

 

[lbass]

Change your record selection formula to:

{vwAVApplications.ApprovedForEAP} and
{vwAVEAPClaims.ProgramYear} = 2010 and
{vwAVApplications.HeatingFuel} in ["Coal", "Kerosene", "LP Gas", "Natural Gas", "Oil", "Wood"]

Insert a group on the ID field that identifies the household--let's call it {table.houseID}.

Then write a formula {@ElecClaim} like this:

if isnull({vwAVEAPClaims.ClaimType}) or
{vwAVEAPClaims.ClaimType} <> "Electric, EAP" then 0
else 1

Then go to report->selection formula->GROUP and enter:

sum({@ElecClaim},{table.houseID}) = 0

This will display only those IDs where there is no ClaimType for electricity. If you need to summarize the results across IDs, you should use running totals since non-group selected records are still "in" the report, though not displayed, and would contribute to the more usual inserted summaries.

-LB

 

[nathanwiley]

I will attempt this, but I was told

"is very difficult to do this type of report using the standard feature in Crystal. Being a programmer, Matt can work around that using his advanced knowledge"

They attached a report, but when I open it, I can't see any forumla except "command"

when I go and explore the database with the report it won't show me anything...

Thanks for your help, I will try this and hopefully it works

 

[lbass]

I don't really know what you are referring to. The suggestion I am showing here is simple to implement without using a command. Aren't you the person making the changes?

-LB

 

[nathanwiley]

LB,

It worked, and found an additional one the "command" didn't. Thanks for your expertise...

Thanks so much!!