Search results for query: *

I know I know, not practical but I am trying to appease a user. Just checking to see if it could be done. They want to print to PDF in the same document at the same time. She didn't want to save both sheets as separate PDFs then merge together.

Pages. We are trying to have the user click print and two pages come out from sheet one. One is the data page on landscape and the next one is the terms page on portrait.

Just to let you know I am using Excel XP.

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 not sure what you mean about bookmarked. I ended up with IF <<Start_date>> > <<TODAY>> "<<Start_Date>>" "" But this does not work. Can you tell me what I need to do with this formula to make it work? Thanks

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...

Yeah, that is what I thought as well BUT! I need the original base price 6%. Not 6% of the total. Our vendor costs are the base price plus 6% of the base price. If you have $100.00 which includes 6% of fees your base price is NOT $94.00 because $94.00 plus 6% (%5.64) equals $99.64 and not the...

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'll try the running total first then the selection criteria.

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...

Simple enough! Thank you, WPCMS

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...

The last {CallLog.InProcessDate} says a number is required here.

Our system has our dates set up as 2008-01-23. //A date field can sometimes be a character field. This formula changes to a date if {CallLog.InProcessDate} startswith "2" then (numbervar yr := tonumber ({CallLog.InProcessDate}[1 to 4]); numbervar mo := tonumber...

...in process date}); numbervar yrs := datediff("yyyy",min,max); numbervar mos; if month(max) >= month(min) then mos := datediff("m",min,max)-(yrs*12) else if month(max) < month(min) then ( yrs := yrs-1; mos := datediff("m",min,max)-(yrs*12) ); numbervar days := if day(max)>= day(min) then days...

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

None of the above worked so I fiddled with it and researched and it worked with this formula. If {Asgnmnt.CSHold}="" then "" else if {Asgnmnt.CSHold} = "T" then "HOLD" else "" WPCMS

Browsing the data it says T,F or blank. I entered the formula exactly If isnull({Asgnmnt.CSHold}) then "HOLD" else if {Asgnmnt.CSHold} then "HOLD" else "" and I get a formula error saying "HOLD" a statment is expected here.When I switch it to Crystal Syntax it says {Asgnmnt.CSHOLD}...

It still didn't work. :(