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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.