Shared Variable in Subreport Showing as False Instead of Actual Value 1

[strider1973]

I am working in Crystal 8.5. I have a subreport that I am listing the types of charges for a particular meeting that the report is based on. For example, the subreport would show:

Room and Tax: Master
Food and Bev: Master
Incidentals: Individual
etc...

I want to pull the result for Room and Tax, in this case "Master", and work with it on the main report. I do not need this same value for any other category. In the subreport I created a formula field like so:

WhilePrintingRecords;
Shared NumberVar HotelBillOpt;
If {BillCategory.BillCatName} = "Room & Tax" then
HotelBillOpt = {BillCategory.BillCatNum}

Where the BillCatNum will be 1 or 2 representing Master or Individula. When I run the report the shared variable will show False or true instead of the 1 or 2. What am I doing wrong here?

Thanks,
S

 

[synapsevampire]

Try Changing it to:

WhilePrintingRecords;
Shared NumberVar HotelBillOpt;
If {BillCategory.BillCatName} = "Room & Tax" then
HotelBillOpt := {BillCategory.BillCatNum}
else
HotelBillOpt := 0;
HotelBillOpt

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[strider1973]

Thanks k, that formula works for me!