Search results for query: *

I know that in Word you set different pages to print in different page orientations for the same document. Is that cabpable in Excel? I have a spreadsheet that has a page of data and the second page terms and conditions. The data needs to be printed in Landscape format and the terms in...

I am trying to create a formula for a Word document that shows only the new start dates for our services. The table will have rows of types of services. Each time a service changes we print a letter of all of the services. All of the services in our system have start dates but we want the...

We are grabing data from one system and loading it into a new CRM system. The data are the notes on accounts. The new system has a 4,000 character limit to their notes fields (The old system had a 8,000 character limit). I need to pull only the notes that are greater than 4,000 characters...

I have a simple math question. I am trying to find out what the base price is of the total that includes a fee. Example: I have a total of $200.00 which includes a 6% fee. I need to break this down in my report to show the base of <$$$> and the fee of <$$$> to equal $200.00. I know this is a...

I am currently using CR XI and I am creating a report that is excluding past pricing. We have a start and stop date per item per client. I surpressed the past data with not (isnull ({AUTO.STOPDATE})) or {AUTO.STOPDATE} >= currentdate and {AUTO.PRORATE}<> "Y" This surpressing the old pricing...

I am trying to count how many days it takes to close a note from our users. I did the simple {@CHARACTER TO CLOSE DATE}-{@CHARACTER TO ENTRY DATE} formula. It shows a note that was created and closed the same day as "0" days. For our averages I need to have it show "1" if it is opened and...

I am trying to take an In Process date and count how many Years, Months, and Days it has been In Process from CurrentDate. Awhile ago someone gave me the formula below but it didn't work. It returns "0 Yrs 0 Mos 17 Days". What am I missing? //The following assumes you have inserted a group on...

I have a report that counts the days the account is in process. Some accounts have been in process for a few years. I would like my formula to break it down by years, then months, then days. How can I go about doing that? Thanks, WPCMS Program:Crystal Reports IX Level:Beginner

I use CR IX and I am a new user. I have a simple formula (at least I think it is) to add to my report. //crystal syntax WhilePrintingRecords; If {Asgnmnt.CSHold} = "True" then "HOLD" Else "" When I view the report it is "" all the way. {Asgnmnt.CSHold} is a check box, so I am assuming...

I am trying to figure out how to take a date field and count how many days to current date. Ex: {DateReceived} to currentdate returns 7 // {07/10/7} to 07/17/07 //returns 7 Thanks, WPCMS

I am a brand new user of Crystal Reports 9 and am still trying to figure out SQL writing. I am trying to figure out two formulas for my report. The first one is to take the mailed date and count the days to the current date (@days). Then I have a formula below (written crudly I am sure) to...