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

    Supress Using Next(), Last Row Missing

    No problemo. Just as long as the user's not confused... V45, are you still there? Don't be confused! Our aim is just to help, not to "one-up" each other. :)
  2. stevefah

    Find addresses with upper case

    This will depend on your database. If it's case-sensitive, go to Options (or Report Options for one report) and UNcheck "Database Server Is Case-Insensitive" (I think it's usually checked by default)and use a record selection formula like the following: {Customer.Customer Name} startswith...
  3. stevefah

    Supress Using Next(), Last Row Missing

    Thanks, lbass, for providing that cut'n'paste, but still, if you call in for support we will tell you nonetheless that we don't recommend using both. I'll definitely pass that around, though... :)
  4. stevefah

    PrintTime Evaluation - Format Changes when Printing?

    Unfortunately, PrintTime refers to when the page is printed to the screen rather than to the printer. I can't offhand think of anything formulaic that would apply to printing to a printer.
  5. stevefah

    Help with Looping

    I suggest you do some conditional suppression if you only want to display one record per customer. You can put this in the Details conditional suppression formula: not onfirstrecord and {Customer.Customer Name}= previous({Customer.Customer Name}) //substitute your field (If they're returning...
  6. stevefah

    Supress Using Next(), Last Row Missing

    This is not the "official" position of Crystal Technical Support personnel. We do not endorse the idea that "the formula overrides the checkbox when executing" because this is NOT tested behaviour. Although it appears to make sense, we haven't tested it so you do it at your own risk. Our...
  7. stevefah

    Subreport print page set up

    Hi, Marcus-- You can have only one page setup in any given report. There's not even a way you can dynamically choose whether to print landscape or portrait. You could do it through code if you were calling the report from ASP or something, I guess, but not in CR itself. Sorry.
  8. stevefah

    Converting Milliseconds to Date in Crystal 7

    Using your sample millisecond data of 107883720000: numbervar newdate:=1078837200000; //substitute your field numbervar tosecs:= newdate *(.001); //gets seconds dateadd("s",tosecs, #Jan. 1, 1970#) //returns actual date
  9. stevefah

    Hours to Days conversion

    stringvar a:="41:07"; //replace the "41:07" with your field numbervar days; numbervar hrs; stringvar mins; days:= int((tonumber(left(a,instr(a,":")-1)))/24); hrs:=(tonumber(left(a,instr(a,":")-1))-(days*24)); mins:=right(a,2); totext(days,0,"") + ":" + totext(hrs,0,"")+":" + mins; //this will...
  10. stevefah

    Supress Using Next(), Last Row Missing

    The checkbox is for unconditional suppression. The X+1 formula box is for conditional suppression. If you use both you're gonna confuse the poor little Report Designer. Pick one and stick to it! :)
  11. stevefah

    cannot export to excel after applying service pack 2

    You need to download the Monthly Hot Fixes (MHFs) for CR9 from our website. http://support.businessobjects.com go to files and updates on the left-hand side.
  12. stevefah

    Unicode Characters Don't Display in CR10

    Hi, Tama-- CR10 is fully Unicode compatible. I can create a report in CR10 using Arial Unicode MS font and display Kanji, Hangul and every other character in the font set. Are you formatting your fields to use the font after placing them on the report? There has to be some other reason they're...
  13. stevefah

    Crystal 2 page report printing on 11x17 paper

    That's right; you can use FinePrint or any other utility that creates PDFs as if it were a printer. That way CR doesn't reformat your font and pages.
  14. stevefah

    Crystal 2 page report printing on 11x17 paper

    When exporting to PDF, Crystal Reports shrinks everything by a small margin; the fonts go down about a quarter point, and everything else is reduced in about the same proportion. In CR 10 there's a reg key to allow it not to shrink, but that doesn't work in 8.5.
  15. stevefah

    exporting to a pdf format from CR 8.5

    Hi, Jim- CR 8.5 shouldn't even see the crtslv.dll and the exportmodeller.dll in C:\program files\common files...\bin, but unless you're using CR 9 or 10 you don't even need those files or paths. So unless you are running CE or CR 9 or 10, delete the whole path. Also, check your dll file...
  16. stevefah

    Crystal next page/last page buttons

    You don't say whether you're using any kind of conditional suppression, but I'll assume you are. Conditional suppression, especially when using page N of M, can cause this kind of behavior. I'd check your suppression formulas, and possibly use a counter instead of N of M. Hope this helps.
  17. stevefah

    Convert a Text YYYYMMDD (20041228) to a Date

    That's a User Function Library (UFL), which uses ufltdate.dll. You can download it from our website at http://support.businessobjects.com/search by searching for the above EXE file. If you don't have the UFL installed, it won't work.
  18. stevefah

    Using character map symbols

    You don't say what version CR you have. You don't say what kind of field it is, nor how your paragraph is formatted (text interpretation). The symbols being interpreted can also depend on your printer driver. More information, please!
  19. stevefah

    Blurry/Unclear logo - Extreme size issue

    Crystal Reports has very primitive image handling capabilities. If you resize in CR and you don't get the resize exactly right your picture will be blurry. For that reason, you should always resize outside CR. That being said, the previous writer is correct. Your image will come into CR the...
  20. stevefah

    Sum of Distinct Count

    Create a Manual Running Total which sums the counts for each segment. Go to http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr_running_total.zip for the Crystal Decisions document on running totals.

Part and Inventory Search

Back
Top