Search results for query: *

anyone?

I'm very new to crystal, SQL, VB, and Access. I'm not really sure how to format a formula I have an input from access into my report and i need to create a formula that will say if this field equals a 1 or 3 add 1 but if the field equals 2 or 4 add .5 i know it's simple but any help would be...

Thanks...I never said i was a seasoned crystal developer. i've had it for less that 24 hours.

I have created my report though a wizard and have nearly completed its design and have now realized i need to add another field which i did not import when i went though the wizard. Is there a way to add a field from the same access database you are currently pulling from?

...are all the formulas Loan Amount% [LA%] (Sum ({tblrankingrpt.Loan Amount}, {tblrankingrpt.OfficerName})/Sum ({tblrankingrpt.Loan Amount}))*100 Loan Type [Ltype] IIF({tblrankingrpt.Loan Type}=1,1,IIF({tblrankingrpt.Loan Type}=2,.5,IIF({tblrankingrpt.Loan Type}=3,1,IIF({tblrankingrpt.Loan...

...a weighted % which is what i am trying to rank employees by in the sub report. that is calculated for each employee by (Total Employee Loan Type% *.5)+(Employee Revenue%*.4)+(Employee Loan Amount% *.1). I need the main report to list them in alpha order and the sub report so simply state the...

Ok...so how do i do it that it can be sorted...I do not have a choice but to sort by that number

when i tried to input the formula into the field it said "a 'shared' variable can only be used while printing records

This is the code that calculates the value i want to rank by ((.5)*{@LType%})+((.4)*{@Rev%})+((.1)*{@LA%}) I want the report out similar to this Doe, John Harrisburg 20% Smith, John Allentown 19.7% Doe, Jane New York 19.2% Etc. The % Value is...

I'm very new to crystal and code as well, I understand what you're saying and how it will work but i'm not sure exactly how to go about it. I want to put the sub report in the report footer. any help would be great

What i've done is i've created a report that contains ton of data on my employees for a quarter. I now want to rank them. I've created a sub report and have imported the names and branch offices of my employees from access into that subreport. I now to need too bring a % value that was...

I'm running Crystal Reports XI. My report is essentially a ranking of employees. Currently they are sorted in Alpha order by name of employee. There is a calculation that takes place and gives a weighted average of 3 Percentages. This is part of the Detail area of the report for each employee. I...

I have an employee list and i need to make a query so that if a name in the employee list is not listed in another table then to append it...how do i do this?

I'm fairly new to access and i'm not sure how to do what i want but this is it... I have revenue values that employees are credited with and my company creates a ranking report for them. What i need to do is take a record which is similar to this: Date Employee Office Loan Amt...

but...i need too. i need to search employee records for branch managers of a specific office and pull forward their commission %'s how else would i do this?

I put in Me![BM%] = IIf(Tables![Employee Data]![Office] = Me![Office], IIf(Tables![Employee Data]![Title] = "Branch Manager", Tables![Employee Data]![Commission %], 0), 0) and it gives me a runtime error and says Object Required

VB says the 1's and 2's are invalid characters

right but doesn't the last 0 count as the false for both IIF statements? if not where do i put the other 0

I'm trying to call a value from another table into a field on a form. Below is my code...I'm getting a "Argument not optional" error Me![BM%] = IIf(Table.[Employee Data].[Office] = Me![Office], IIf(Table.[Employee Data].[Title] = "Branch Manager", Table.[Employee Data].[Commission %], 0))

correct