Search results for query: *

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

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

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

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.

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

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

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.

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

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

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! :)

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.

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

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.

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.

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

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.

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.

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!

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

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.