Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bld21

  1. bld21

    MVP needed for If, Then, Else

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

    Odd/Even

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

    DateTime Var

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

    Shared Variable

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

    Minimum

    Thanks Brian!
  6. bld21

    Minimum

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

    Formatting String Function

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

    String Functions

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

    String Functions

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

    OLE Objects

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

    Variable Types

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

    Variable Types

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

    Variable Types

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

    Date Grouping by Month

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

    Variable Types

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

Part and Inventory Search

Back
Top