Change Formula Variables Without CR

[BradB]

I have a report where the variables in the formula change every month. I have a user that would like to manipulate these changes on her own. The user does not have a copy of CR. I would like to have her enter the data in some format, and the forumla pick up the data and use it. I was curious on whether or not I could use a database or a text file to import these varibles into the forumla.

Here's one of the formula's that they would have to change. The CASE variables and the percentages change every month.

Unallowable
Select {financial.jd_ref1}
Case "1127":
(Sum ({@Medicaid}, {financial.jd_ref1})*.5)
Case "3182":
(Sum ({@Medicaid}, {financial.jd_ref1})*.35)
Case "1157":
(Sum ({@Medicaid}, {financial.jd_ref1})*.35)
Case "1159":
(Sum ({@Medicaid}, {financial.jd_ref1})*.65)
Case "131":
(Sum ({@Medicaid}, {financial.jd_ref1})*.35)
Case "3212":
(Sum ({@Medicaid}, {financial.jd_ref1})*.33)
Case "2105":
(Sum ({@Medicaid}, {financial.jd_ref1})*.34)
Case "2103",
"3165",
"3160",
"3224",
"3130",
"3032",
"3208",
"3200",
"1407",
"1154",
"3223",
"3070",
"3155",
"3045",
"3147",
"3183",
"1166",
"3023",
"1164",
"3094",
"3068",
"1193",
"1158",
"1351",
"3217",
"3204",
"3178",
"3226",
"3067",
"3071",
"1132",
"487",
"3195",
"3218",
"3216",
"3055",
"3051",
"489",
"3207",
"1155",
"3135",
"3154",
"3084",
"3004",
"3213" :
Sum ({@Medicaid}, {financial.jd_ref1})*1

 

[synapsevampire]

It makes sense to use a table for this sort of thing.

The table would have:

uniqueID //all tables shouold have a unique ID
jd_ref1
percent

Now you can join this table to your financial table to look up the values.

The formula would change to:

(Sum ({@Medicaid}, {financial.jd_ref1})*{financialpercent})

The idea shouldn't be to import values, it should be to make the current database more intelligent.

Since you didn't supply any technical information, it's difficult for anyone to state the best means to make this additional data available, but I would suggest adding a table to the current database.

-k