[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

"Global" formula across multiple reports?  is this possible in CR XI?

Asked by itneonatal in Crystal Reports Software

Tags: forumla, global, XI

I have a formula that translates a GUID used in a database to an office location.  This is used across MANY reports.  Is it possible to somehow define this formula globally so I cna change it in one location and all my reports update?  Please note, I'm VERY new to Crystal and inheritted an existing setup.  The formula is listed below if you are interested. 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:

IF {location_mstr.location_id} = "8A0A72C1-69DB-4E0C-AA9D-92D46B1EC8F4"
THEN "CT-NOR"
ELSE IF {location_mstr.location_id} = "9D971E61-2B5A-4504-9016-7FD863790EE2"
    THEN "NJ-CS,"
ELSE IF {location_mstr.location_id} = "CEC517D8-7D80-434C-9AC9-52BB8D748912"
    THEN "NJ-COM,"
ELSE IF {location_mstr.location_id} = "9C1B12F0-807D-415D-B241-E458356D7EA6"
    THEN "NJ-KIM,"
ELSE IF {location_mstr.location_id} = "FFCB7447-6B37-4484-B3E4-4E2352E88CC8"
    THEN "NJ-MTS,"
ELSE IF {location_mstr.location_id} = "33C0B756-179E-4287-AA31-961F30E71BFE"
    THEN "NJ-RB,"
ELSE IF {location_mstr.location_id} = "F72A32E7-6956-4656-825A-6085DD509176"
    THEN "NJ-RWJ,"
ELSE IF {location_mstr.location_id} = "C56B6770-EF0D-4522-816C-A0A601AF6AD0"
    THEN "PA-CC,"
ELSE IF {location_mstr.location_id} = "3D68B2EE-8724-4A82-BA26-63AE365B2588"
    THEN "PA-EPH,"
ELSE IF {location_mstr.location_id} = "87BFE2A8-64B2-4988-8DAF-516B3EE32B99"
    THEN "PA-MS,"
ELSE IF {location_mstr.location_id} = "D086CC2F-70F7-4983-B092-701260432ABB"
    THEN "PA-RID,"
ELSE IF {location_mstr.location_id} = "3FCB0D7F-7FA0-4FD9-AD3C-C2E9F38C80F0"
    THEN "OH-KET,"
ELSE IF {location_mstr.location_id} = "718A271B-BE2C-4AB0-8ECD-6D4EEDAC9539"
    THEN "OH-SV,"
ELSE "XX- UNDEFINED LOC"
[+][-]11/06/09 07:52 AM, ID: 25760160Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/06/09 08:24 AM, ID: 25760506Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/06/09 08:41 AM, ID: 25760684Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/06/09 08:52 AM, ID: 25760786Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/06/09 09:30 AM, ID: 25761124Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/06/09 10:53 AM, ID: 25761916Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/06/09 01:15 PM, ID: 25763118Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091021-EE-VQP-81 - Hierarchy / EE_QW_3_20080625