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?

yes, it is...Here 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...

We're a Loan Brokerage Firm...In the main report is listed in Alpha Order By Employee. It contains dates of closed loans, branch office, and several calculations that give each employee percentages of Loan Types(1st Purchase&1st Refinance=1, 2nd Purchase & Second Refinance=.5), Revenues, and...

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