Search results for query: *

Thanks, guys. The problem was in the mind set of the programmer. Being an old Fortran, Pascal, etc. programmer, I'm used to putting just about anything I like in an IF-THEN-ELSE statement. The idea that the THEN has to end in the same type of variable as the ELSE because it is "returning" a...

I'm converting a formula from Basic to Crystal syntax. I'm using CR 10 against an Avatar (AKA NetSmart) hospital information system. The routine is supposed to calculate the number of days the person has been certified. The error message I'm getting is "A number is required here" and...

Is there a reason, like a grand total, to put all 10 reports in one? Could you print each of the 10 reports separately and just bind the paper together?

I should say that this is Basic syntax in 8.5. I remarked out all the lines of code in @R&B except the declarations, the WhilePinting Records, SubtotalCharge = 0, TestDate = {view...} and DumDate (AKA Dummy) = {@FindFee}. In @R&B formula = DumDate; in @FindFee formula = TestDate. I get the...

Thanks Scott. The objective is to calculate a room and board charge. FindFee selects which per day charge was in effect so that can be multiplied by the number of days to get the charge. If both the admission date and discharge date fall within the time period for a specific rate, the charge...

I'm trying to use a formula like a subroutine using Global variables to pass values back and forth. Does that work? Here is what I have: REM @R&B REM assumes everyone is discharged WhilePrintingRecords Global TestDate AS date Global Fee AS number Global Index AS number Global LeftDif AS...

Thanks. That worked in one report. I'll have to go through the others and see if I can do the same. I'm afraid that in at least one, it won't be possible because the sub-report is necessary to do some additional calculations so I'm still wondering if this problem goes away in CR 10. Thanks...

Bruce Bussell, You describ the technique I'm using -"setting up a group = ascending (below any other groups) for the field". The problem is that even though I can see the column created in the sub-report on the screen and can print it out, when I export to Excel the column disappears. I believe...

I have several reports where I use a sub-report to generate a column of information. For example, I use a sub-report to print only the most recent entry in a table containing a record for everytime a certain data item (like diagnosis) is changed. I've noticed that when I export the report to...