Search results for query: *

Sorry, it was my type. That did do the trick. Thanks for all the help.

Nope, I tried that, but I still get the department 95100 showing up.

I've been trying to get this report to work, but can't seem to grasp it. I'm using Crystal 10 and the main point is that I DO NOT want department 91500 to show up, but it keeps on. Here is the code...

Can anyone help me with this?

The information is coming from a SQL Server. The sql code was pulled when I went to Database->Show SQL Code. When I try doing a verify database, I get the same error.

Fisrt off, I was given this report to see why its not working and I can't figure it out. Hopefully you guys can shed a little bit of light on it for me. I am using Crystal 10 and when I try to run this report, I get the following error: Failed to open a rowset. Details: ADO Error Code...

Thank you very much, that solved the problem, putting the reset formula in the group header. Works like a charm, thank you

I'm sorry, I was just giving you a sample size of the entire report. Here are the entire contents of the report. Account 13312 Group Header 1 = Employee Dept 92000 Group Header 2 = Department Benfits Class A Group Header 3 = Benefits Benefits 85.00...

Yes, each account has a separate instance on the subreport. Each account could have the same value, but more than likely not. No, the benefits are being pulled under the detail of the main report. Any additional info is being pulled by subreports. GF3b = Pension (Subreport)sharednumbmer var...

Unfortunately, I'm still getting the blanks. I also tried changing : if isnull({BENEFIT.EMP_PRE_CONT}) or isnull({@Retirement Pension} then 0 else {@Retirement Pension} to: if isnull({BENEFIT.COMP_CONT}) or isnull({@Retirement Pension} then 0 else {@Retirement Pension} Anything else we...

...appears when an account does not have a value for the retirement pension field. Otherwise it populates with the actual amounts. Benefit.Comp_Cont can also be null as well. Employee and Annual Salary can not be null. Annual Salary: {EMPLOYEE.PAY_RATE}*{EMPLOYEE.NBR_FTE}*{EMPLOYEE.ANNUAL_HOURS}

Unfortunately the blank lines are still showing up.. Anything else I can try?

What do you mean by reset formula?

...to the main report is: Value = if isnull({BENEFIT.EMP_PRE_CONT}) then 0 else {@Retirement Pension } Retirement Pension = (({EMPLOYEE.PAY_RATE}*{EMPLOYEE.NBR_FTE}*{EMPLOYEE.ANNUAL_HOURS})*.0575) 403 B SUM CALC: shared numbervar CompPensionTotal:=sum ({@Value}); The information from the...

...Ex. If Account# 33110 has a value of 5.75 in field ({BENEFIT.EMP_PRE_CONT}), then it knows to use the Retirement Pension: (({EMPLOYEE.PAY_RATE}*{EMPLOYEE.NBR_FTE}*{EMPLOYEE.ANNUAL_HOURS})*.0575) But if the value shows as null or 0,the account does not qualify for a retirement pension and I...

No, I would like the zero amounts to be included.

Ok, now I'm getting 0 for the values that don't have any values and if there are values, they are also being shown. But if I want to take it a step further and total everything out, like in the formula: 3. 403b Sum Calculation: whileprintingrecords; shared numbervar CompPensionTotal:=sum...

...formulas: 1. Value Check: if isnull({BENEFIT.EMP_PRE_CONT}) then '0.00' else ({@Retirement Pension}) 2. Retirement Pension: (({EMPLOYEE.PAY_RATE}*{EMPLOYEE.NBR_FTE}*{EMPLOYEE.ANNUAL_HOURS})*.0575) 3. 403b Sum Calculation: whileprintingrecords; shared numbervar CompPensionTotal:=sum...

Thanks, this helped with the last 4 digits and all I needed to do was apply the same to the first three and it worked. Thanks.

I am currently using Crystal 10. I am currently writing a report that currently using 2 fields called dept and item#. Example of these results are: Dept = 369 Dept = 471 Item# = 1 Item# = 10 Item# = 100 Item# = 1000 I want to concatenate these 2 fields so that the intended result will be...