Search results for query: *

I am using crystal reports 2008. I am looking for a solution or a direction on how to solve this task. I am working on a letter and in the letter there are 2 lines of text below: X Vehicle was sold in state prior to January 1,____to: @titlename, @titleaddress, @titlecity and X Vehicle was...

I am using crystal reports 2008. I have a report that includes a 9 digit account number field. What I would like to do is to create 2 separate groups, one containing the odd numbered accounts and one containing the even numbered accounts. Is there any possible way to do this? Thanks, Bruce D.

I am using crystal reports 2008. I am calcuating the number of business days between two dates using the formula below: WhileReadingRecords; Local DateVar Start:= date({s_srv_req.CREATED}); Local DateVar End:= date({s_srv_req.ACT_CLOSE_DT}); Local Numbervar Days; Local Numbervar Weeks; Local...

I am using crystal reports 2008. In my main report in the report footer I have a grand total formula for: if IsNull (Sum ({@adj_amt})) then Sum ({payment.pmt_amt}) else Sum ({payment.pmt_amt}) + Sum ({@adj_amt}) I have a subreport after that in report footer b that is summing other pmt...

I am using crystal reports 2008. I am using a formula to parse out a date field. right({@usps 3},10) I want to be able to see the oldest dates. I am trying to use "Minimum" to show the earliest date. I can't quite get it to work with the "Right". Any ideas? Thanks!

I am using crystal 2008. I have in a formula the following: right({@usps 3},10) this returns a date of 1/26/2010 4 but because of the field I am referencing if there is no space after the year it picks up that next character. Is there a way to just format this field as...

I am using crystal 2008. I have string field of 150). I setup a formula field for - Leftletter_tracking.usps_data},20) which shows as 32202,918,4/25/2010. Which works exactly how I want it. But I would like to then brake this apart into 3 columns as 32202, then 918, then 4/25/2010. I can...

I am using crystal 2008 and I have a current report which I am trying to insert a 2 page pdf file to. When I do the insert I can only get the first page into crystal. I can not figure how to get the second page in. Any ideas? Thanks! Bruce DiPaola

I am using crystal reports 2008. I am receiving the following error: A variable type (for example, 'numberVar') is missing. I am using the following code for mailing addresses. Shared shr_addr_1 As String Shared shr_addr_2 As String Shared shr_addr_3 As String Shared shr_city As String...

I am using crystal reports 2008. I am trying to group all of my records below by Enter Date for the month/yr. I have the following: acct # desc Enter Dt Post Dt 4001145224 EOT Property Tax 12/8/09 12/8/09 4001145224 Payoff 12/2/09 12/3/09 4001128704 EOT Property...

I am using crystal reports 2008. I am creating a formula of : Shared shr_addr_1 As String shr_addr_1 = {customer_address.addr_1} formula = "" But when I try to save it I get the message " A variable type(for example, 'numbervar' is missing). The shr_addr_1 seems to be the issue. I've used...

I am using crystal reports 2008. I am trying to print an odometer number in a set form field on a page. I am using a formula field with the following syntax. This is working correctly for numbers greater than 9,999. But it does not work for less than 10,000 miles. My if totext() statement seems...

I am using crystal reports 2008. I am trying to prevent duplicate records from appearing on my report. I have 2 fields; account number and stock number. The majority of the time each account number will have a different stock number. But sometimes I have a stock number with multiple account...

I am using crystal reports 2008. I have created a letter with page headers c,d,e. I have 3 detail sections, A for Letter text, B for remittance info, and C for mailing info. I would like to not see the page header information in the second and third page of the letter. Right now it will print...

I am using crystal reports 2008. I have a formula named @DATE with the following : if (isnull({vehicle_lease_end.turn_in_dte}) or {vehicle_lease_end.turn_in_dte} = Date(1900, 01, 01)) then {account_termination.term_dte} else {vehicle_lease_end.turn_in_dte} The problem I have come across is...

I am using crystal reports 2008. I have some letters setup in crystal using the same paragraph language for each letter with just the customer name and address changing for each. But when I preview the file it shows all the letters including the ones with empty name and addresses. What I would...

I am using crystal reports 2008 and I want to pull customer name records only if there is a name in the field. I am trying to write a formula for this to select only records with names and not print the records with no names. example: not (IsNull({first_nme} +' ' + {last_nme} + ' ')) Am...

I am using crystal reports 2008. I have created a letter with a data source for the name and address. Some of our accounts are in Canada. What I would like to know is there a way to print the hash mark above a certain letter. For example: Siege, I would like to place the small character above...

I am using crystal 2008 and I have created a letter and want to use a closing block at the bottom. I need to create 3 separate lines. The name will depend on department number. I am looking for something like this: Yours sincerely, <text object> Name Department Title Thanks, Bruce

I am using crystal 2008 and I have a field called {payment.pmt_eff_date}. The report will show an account with various dates of payments made. I need to only see the date of the last payment made. Is there a formula to select only the date of last payment made? Thanks, Bruce