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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Yustrn

    If Date is before then Null?

    Using Crystal 10 and I need to fiqure out a formula where if the print date of my report is before one of the dates my report is pulling then the field needs to be blank. For example. I have someone who has placed orders into the future. I have orders from them in Dec 5 2006, Dec 5 2007 Dec 5...
  2. Yustrn

    Parameter Field plus 1

    What I need to be able to do is to create a parameter field in which a number get's type in, then on my report it would then add 1 to the subsequent numbers IE: I type in 12345 into the parameter field, then if I have 5 rows of data I need them to be 12346 12347 12348 12349 12350 Ect, is...
  3. Yustrn

    Turn Zero's to Null

    That works great until I export this out of my main software, then the zero's re-appear.
  4. Yustrn

    Turn Zero's to Null

    Basic question, but I can't fiqure it out. Using Crystal 10 I need to turn zeros into blank fields. So if 0 then " ", but I don't know what hte formula would be. This is what I tried. If ({ROTOptionExport.Shares 1}= 0 )then " " else ({ROTOptionExport.Shares 1})
  5. Yustrn

    Problem with Header and Footer

    ...for each line of data, when I just really want it one time for the whole report. Here is an example of what I'm getting, and what I want to get. ***This is what I get*** HDR,10282007,16:45:12, , EXER.TXT|10004|0000001,16:45:12, ,|9|430980.00 HDR,10282007,16:45:12...
  6. Yustrn

    Null = 0.00

    I'm sure this is a stupid question so I aplogize in advance, but I need to know the if than for null I am assuming it's If {whatever.rot} is null then "0.0000" else {whatever.rot} If someone could please help I would highly appreciate it. Thank You This is using crystal 10
  7. Yustrn

    Subtracting time from years?

    I have a report I'm creating in Crystal 10 So what I have is a purchase date and a purchase period Purchase date would be like 8/14/2007 and the purchase period would be like 1 or 2 or 3 or 4. What I need is a formula that would subtract 1 year from the purchase date if the purchase period is...
  8. Yustrn

    Leading Zeros?

    How do I place a formula to enter in leading zeros on a number for instance I need to hold 10 places so 101 should be 0000000101 1001 should be 000000101 10001 should be 0000010001 so no matter what the number is I need 10 fields and the fields should be leading zeros. This is using Crystal 10...
  9. Yustrn

    Help with Subreport

    Hello, Using Crystal 10 and have a subreport to pull data. I have two questions. A. When I run this new report in my software and then export the data out in a character seperated value file the sub report data is not showing. B. The subreport is pulling fields based off of Tax Description...
  10. Yustrn

    Problem with Headers.

    I am using Crystal Version 10.
  11. Yustrn

    Problem with Headers.

    I have a report that I have created that has a ton of columns, this report get's run through my software and then I export to Excel. The data will open up to see the complete text, however the column headers are shrunken and will not enlarge to read all the text that is in the Text Box. Is there...
  12. Yustrn

    Basic New User Question on "if then else"

    ...//totext("00000000") //else if {PS_AWARD_SCHEDULE.VEST_DATE_1} > {@As of Date-1} then //ToText({PS_AWARD_SCHEDULE.VEST_SHARES_1},"00000000") //*********Modified on 04/26/2006 if ({PS_AWARD_SCHEDULE.VEST_DATE_1} < {ROTPersonnelSummary.Option Date} AND...
  13. Yustrn

    How to get a Cover Letter?

    It works good for the first person but on the second person it repeats the entire header information and now shows their name and info twice basically it repeats the Page Header and the Group Header, But one the first person it's perfect.
  14. Yustrn

    How to get a Cover Letter?

    Hello, I have created a individual per person statement for my employees in Crystal 8.5, I'm going to mail these out to my employees and thought it would be easier to create a cover sheet with name and address that would print out at the same time of their statement, so Mr. Amor would have a...
  15. Yustrn

    Purchase Date Forumla

    Hello, I'm using Crystal 8.5 and I'm having troubles with the following formula. Here is what I'm looking for. I have a bunch of items purchase throughout the year but only want the items for two specific dates and a separate column on my report for each one. Something like Customer A...
  16. Yustrn

    If it's over a year ago?

    Looks good, but I'd like to find a way to where I didn't have to come back in and update the current date information...it will always be standard at 1 year.
  17. Yustrn

    If it's over a year ago?

    Using Crystal 8.5 Here is the scenario. Someone buys items from us once a quarter, but I need it broken out by if they bought the items over a year ago, or under a year ago So something like Items bought less than 1 year ago 423 Items bought more than a year ago 223 I have the dates they...
  18. Yustrn

    Exporting To Text??

    Sorry, I'm using 7.0, don't know how to check what service pack I'm on, and the link you gave me has a bunch of different ones so not sure what to download.
  19. Yustrn

    Exporting To Text??

    Is there a way when Exporting my Crystal Report out to straight TEXT format for it to keep all of my page breaks and column headers??? If I take it out to .RTF it's find, but if I take it out to TEXT it looses all of it's formating, is there anyway to get around this??? Any help is appreciated...
  20. Yustrn

    ID number from 123-45-1234 to XXX-XX-1234

    I'm using Crystal 7 and on one of my reports it list the employee's ID or SSN, would like it to "X" out the first 5 numbers, and just leave the last 4, anyone know how to do this, or maybe just show the last 4 numbers only?

Part and Inventory Search

Back
Top