Populating Blank Fields

[cpaw]

Hello,
I am using CR 9 with the following fields:

Occurrence # Date Procedure # Provider #
1 1/12/2004 1.NR.28 1284
2 1.NF.81
3 2.AG.19
4 8/12/2004 1.TX.18 5541
5 31/12/2004 1.GB.20 5481
6 2.FS.81

The provider number only has to be entered on the first procedure if the same provider did multiple procedures at the same time. I need a count of the each procedure by provider #. How do I do this with a blank provider number??

Thanks in advance.

cp

 

[kskid]

Try this.

Group on Provider#

In the detail section, right click on procedure# and Insert a summary and select a distinct count of procedure number.

-LW

 

[cpaw]

That would work, however, I need to know each procedure by provider #.

For example:
Occurrence 1 has a Provider #
Occurrence 2 would be the Provider # from Occurrence 1
Occurrence 3 would be the Provider # from Occurrence 1

cp

 

[kskid]

If the provider# is blank or null for Occurrance 2 and 3, how do you know that they belong to the provider identified in occurance 1?

I assumed you just suppressed duplicates on the date and provider# fields.

-LW

 

[cpaw]

No it is not suppressed. These fields are not required to be filled in.

If the provider did multiple interventions you only need to fill in the date and provider number for the 1st intervention for that date.

cp

 

[kskid]

From an application standpoint, that may be true but from a database perspective, there has to be a way to associate occurances 2 and 3 with provider 1284.

Create a new report and list all the fields. In the record selection formula, select a couple of provider numbers and see what you get

-LW

 

[lbass]

Replace the provider # with a formula {@provno}:

numbervar x;

if not isnull({table.provider#}) then
x := {table.provider#} else
x := x;
x

Then you could group on this formula (I think) and insert a summary a count on your procedure field, or use a running total that resets on change of {@provno}.

-LB

 

[cpaw]

I am still getting blank fields using the formula. I changed it as the provider # is a string to stringvar x;

 

[lbass]

I tested this, and it should work. Please post the exact formula you used. You created this in the formula area, right? And then placed it on the report canvas instead of {table.providerno}?

-LB

 

[lbass]

Or do you have "Convert null values to default" checked in report options? If so, or in case you have some spaces instead of nulls, change the formula to:

stringvar x;

if not isnull({table.provider#}) or
trim({table.provider#}) <> "" then
x := {table.provider#} else
x := x;
x

-LB

 

[cpaw]

Yes, the report options has "convert null values to default" checked off. So I ran this formula and I am still getting blanks.

stringvar x;

if not isnull ({I10_Abstract_And_Intervention_VR.IntervProviderNumber}) or
trim ({I10_Abstract_And_Intervention_VR.IntervProviderNumber}) <> "" then
x := {I10_Abstract_And_Intervention_VR.IntervProviderNumber} else
x := x;
x

 

[lbass]

Try unchecking it.

-LB

 

[cpaw]

Unchecking it did not do anything! I ran this formula:

if {I10_Abstract_And_Intervention_VR.IntervProviderNumber} <> "" then
{I10_Abstract_And_Intervention_VR.IntervProviderNumber} else
if next ({I10_Abstract_And_Intervention_VR.IntervProviderNumber}) = "" then
previous ({I10_Abstract_And_Intervention_VR.IntervProviderNumber})

This formula will populate the second blank field; however, not the third. Suggestions??

cp

 

[lbass]

Please paste your version of my formula into this thread. There is no reason that I can think of for it not to work.

-LB

 

[cpaw]

I pasted my version of your formula in the 15:29 reply.

cp

 

[lbass]

Sorry. Please try this. First uncheck "Convert null values to default". Then use:

stringvar x;

if not isnull ({I10_Abstract_And_Intervention_VR.IntervProviderNumber}) then
x := {I10_Abstract_And_Intervention_VR.IntervProviderNumber} else
x := x;
x

-LB

 

[cpaw]

Thank-you very much, that worked!!