Recent content by bld21

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

Thanks Brian!

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

Thanks, I was able to figure out the Mid function.

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

Yes, that was it, I missed that too. Thanks to everyone, this is a great resource!!!

Mike, I tried that but now I get an error that the remaining text does not appear to be part of the formula and the second line and the rest of the code is highlighted. I copied what is hightlighted below: Shared Stringvar shr_addr_2 Shared Stringvar shr_addr_3 Shared Stringvar shr_city...

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

You are the man, Brian. I can't believe I missed that. Thanks!