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...

Yes, the blank line only 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...

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

What do you mean by reset formula?

Everything that I have been explaining has been in the subreport for the retirement pension. I also have 2 other subreports in this report as well. The subreport lies in Group Footer 3b: Benefit.Employee. In the subreport, the formula that passes the information back to the main report is...

This is a subreport that I'm using to populate a value back into the main report. 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...

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...

I have been trying to debug this code and have finally give up. Please see if you can point me in the right direction. I'm using Crystal 10. I have a field in my report called emp_pre_cont and this field usually has a number most of the time, but there are occasions when there are no values...

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...