Search results for query: *

I have a column based on a group in sharepoint that has 5 users in it. It previously had 10. The dropdown is showing all 10 users even though they are no longer part of Sharepoint site anymore. How can i sync these up? I am new to this so any advice you can help me with woud be greatly...

I dont know why im having such a problem with this: Using CRv10 Im trying to pull back if any of these three fields (dates): EscrowReconLoanBillingTask.OpenDate, EscrowReconLoanBillingTask.ClosedDate, EscrowReconLoanDisbursementTask.OpenDate are in my Parameter date range. Does this need...

I have three fields fico1, fico2, fico3 I want the median value of these three fields. If fico1 =600 fico2=700 and fico3=675 i would want to return 675 in a formula. I am using cr10, and for the life of me cannot figure this out, im sure it is super simple. I found where this can be done in...

Hi, Im new to VBA and im trying to compare by columns in excel and shade those that are different. I have column B and C that are supposed to be the same but if they are different i want to highlight them. The same goes for D and E, F and G etc.. This goes on for 200 columns so you can see...

Hi Everyone! Im new to Access and VBA and am trying to create an IF statement in a module to call in a query and IM getting a "Compile Error: External Name not defined" error. Im using Access 2003 and following is my module entry that im attempting to call: Public Function status() As String...

I have used Access 2000 to screen scrape data to and from an Attachmate client. However, the company no longer uses Attachmate and instead uses Rumba as their mainframe emulator. The methods that I used for Attachmate will not work to communicate with Rumba. I tried to search for online...

I am trying to capture this data in a crosstab report. Im not sure if you can do this or not, but I not only want the count of each column but also the percentage of the grand total that column represents. I can do this in Crystal and Excel, but I am having a hard time figuring this out in...

I have a report that is grouped by branch. We have 116 branches, and at anytime data can be populated for 1 or all of the branches. Each branch needs their own report. I have a macro that runs all of my daily reports and outputs them to a snapshot and I really dont want to have to add all 116...

I have a report that i create in access and export to pdf that is grouped by branches. Once i get it to pdf i want to extract each branch as its own separate file. Is there any way to do this. I dont know anything about acrobat. I really would appreciate any assistance you can give me...

I was hoping someone could help me with this. Im using Access 2000 and I am new to Access. Im doing an iif statement within a query. Expr6: IIf([expr5]=1,'Registered',IIf([expr5]=3,'Submitted'),iif([expr5] = 6,'LOI Executed') of course this is coming back an error. it wasnt coming back an...

Hello all: Im new to Access and was hoping someone could help me with this. I need to do a % of column (as in an excel pivot table) in an Access Cross tab. Can this be done? Thanks, KIM

I am trying to convert a report from Crystal to SQL and the Show SQL statement is not converting all of the criteria over and I was hoping someone could help: IN my criteria box: (not isnull({LOAN_USER.SECURITY_REC_SENT_TO_INV})or not isnull({LOAN_USER.FINAL_TITLE_SENT_TO_INV})) and...

I need to display a report based on product codes, whether there is a listing in the database for this code or not. If the code isnt in the database, i would like for the code to display and a zero be next to it. I have tried everything and cant figure out how to do this in Crystal. Please...

I am trying to sort a report but I have a problem, I was hoping someone could help me with. My report is grouped by loan number and under each loan number there are multiple status dates with users attached to them. So it is set up like this: GH - loan id 12345 D - status date...

Can someone help me figure out how to do a date range from 01-01-2005 to the end of the last month. So If i were pulling the report today, I would want to see 01-01-2005 to 02-28-2005. Any help would be appreciated. Thanks, KIM

Hello everyone. Is there anyway i can set up my crystal report to do a page break after each group that will carry over to excel? I want to be able to print each group on its own page in excel. Thanks!

Hello all! Im not sure if this can be done or not, but I have a field that has two possible values in it. "TXCO" or "NO TXCO" I have the report grouped on loan number with a "insert section below" on the group put on top of the group with this field in it. The way that I determine whether...

Im hoping someone could help me with this. I currently have people send me lists of loan numbers in which they want certain data out the database for these loan numbers. Currently, I take the list of loan numbers concatenate quotes and commas and pull the data out 1000 at a time (crystal wont...

Im hoping someone can help me with this. Im using v 8.5. Im trying to link zip code in two tables. In one table it is string 15 and in the other it is string 5. I want to look at the first five digits in the string 15 so that I can equal join it up to the 5 digits. Is this possible in Crystal?

I was told there is a way to sort a table alphabetically in Crystal. Does anyone know how to do this? Thanks, KIM