Search results for query: *

I have Windows XP and Office XP. I have a spreadsheet that we download every month and it will have 22,000 plus rows. I then insert 10 new worksheets and name them for each acct. name such as EFC, OVK, etc. Then I use Data, Filter to pull up the account name and copy these sheets to the...

Our purchasing dept. has a huge spreadsheet. They have a column for budget 2005 and a column for expenditures 2005. They want to sum the expenditures 2005 column where the date range column is >=1/1/2005 and <=1/31/2005. I typed just a small sample to see if I could get the sumif to work for...

I have Windows XP and we use office xp. On my desktop I have a document image writer print driver which is great because I can save pdf, word, etc. documents as mdi and then use insert file to create a multiple page tif file. However, I don't remember how I installed it. I need to install...

I have a fellow employee who has 2 huge spreadsheets. We both use Windows XP and Office XP. She has frozen panes on both spreadsheets so she can see what she is copying. She used window arrange, horizontal, so she could see both ss files. She can't move her cursor around in either file with...

I have CR 9. I am attaching to Visual Fox Pro Database Tables. If I go into the DB program the programmers have typed in set deleted records to off so no deleted records show up in the reports that they have created. I am getting deleted records in my CR. Does CR have something similar to...

I teach Crystal Reports 9. Some of our reports will show a record more than once, so I group them and put my formulas in the group footer. One of my students asked why do you see more than one occurrence of a record in the details section. Is it because the same record pulls from the master...

I use Windows XP, CR 9.0 I have created a report which shows our top 10 agents by submissions. I have the report grouped by Agent Name. In the report footer I have a running total which counted the # of submissions for Bound or reinstated policies. My total is correct and it includes the top...

I am using CR 9 Professional. I am reporting off a Visual Fox Pro database using an ODBC connection. I have my report sorted by state, then lastname, then firstname then ssn. My report contains 8,000 records. I want to only see records where a client has 2 or more DIFFERENT SOCIAL SECURITY...

I am using Windows XP, CR 8.5 Professional, and Excel XP. I am not using CE. My CR has 22,008 records. I need to export this to Excel, so I click on file, print, export. then I receive &quot;Error in MS Excel Export Format dll&quot;. I spent all of yesterday reading all the stuff at...

I have a crystal report where I am pulling contacts for our sales agents in the field. We then export that data to Word and e-mail it to them. We need to be able to track how many leads we send them each quarter and make sure we don't send them duplicate leads. I put the record number field...

I am working on a spreadsheet which has units to be installed. When we install a cold unit such as an ilc or a rlc the price stays the same, but if we install a hot unit such as an ilh or a rlh then we need to up the price by certain % which can change from job to job. I have unit names in...

I have several reports which I created using ODBC to my Visual Fox Pro data. We are have moved 3 of our very large tables into sql. Over the next year we plan on moving some more tables. I will need my reports to pull some data from Visual Fox Pro and some from SQL. Our database...

I need help, please. I have seventeen summary fields in the report footer of a Main Report. I have seventeen summary fields in the report footer of the subreport. From the main report I need to enter 17 formulas which grab a summary field from the subreport and subtract a summary field from...

There is a woman at work who is using excel 97. When she opens Excel a F9 window pops up. She has a large excel spreadsheet which she is linking to Freedom accounting software spreadsheet. We changed the tools, options, calculation to manual calculation and re-saved the spreadsheet. However...

In column A I have entered all 52 states with one state in each cell such as ID, WA, MT, LA, OR, CA, etc. I need a formula which I will enter in the B column which states if the cell to my left is one of 8 states put a 1 if the cell to my left is one of 2 states put a 1.3, if it is...

I need a report which will have several summaries for 2001 hospital payments, physician payments, rehab payments, etc. This is my code from the select expert. {payments.ccomptype} in [&quot;05&quot;, &quot;44&quot;] and {claimheader.cclmtype} = &quot;WC&quot; and {claimstubwc.ccltype} in...