Search results for query: *

It might not be a printer problem, but rather some type of formatting problem. I've seen this error message at least once in CE9. For a particular instance I remember, the report had several subreports in the report header followed by a blank page header. In certain situations (where the page...

This works for me in 9.0 (inserted using the formula button on the hyperlink information window in the Format Editor). Substitute a valid email address of course. "mailto:" + "name@somewhere.com" + "?Subject=" + ReportTitle Jerry

Yeah, I just tossed out the first thing that came to mind. I like your approach a lot better. Thanks. Jerry

Someone may have a better idea, but this will work if you have a limited number of "non-alpha" characters that you might find in a name (like "'", "-", and " "). Create a formula like this If InStr ({USERS.LAST_NAME}," ") <> 0 Then Join(Split ({USERS.LAST_NAME}," "),"") Else If InStr...

Brian ... that's true, but only if you need to convert times that happen to fall between midnight and 2am on those 2 Sundays when DST begins and DST ends. All other times during the rest of the year are converted correctly. For our applications, we never have date entries that occur then, so...

I had a similar problem, but couldn't find a standard Crystal function. So I created my own custom function, and it works great for me. I'm actually converting from GMT to Central time (as well as accounting for Daylight Savings Time), so you can change the time difference constants according to...

I actually just recently created a custom function in CR9 because I couldn't find a tidy solution to exactly the same problem. Here it is for what it's worth. Function (DateTimeVar gmtDateTime) //This function converts any GMT date-time to a Local date-time after //checking whether the date is...

The work-around suggested by bikejockey is the only solution I've found. See the thread at http://www.tek-tips.com/viewthread.cfm?SQID=827443&SPID=782&newpid=782&page=1 for a more detailed explanation. Jerry

Here's a pretty lengthy thead that discusses this issue in detail. Probably more info than you wanted but should help. http://www.tek-tips.com/viewthread.cfm?SQID=503362&SPID=782&newpid=782&page=1 Jerry

Are the fields that overlap in your CE ActiveX viewer truncated when you view them in CR? If so, this thread will probably answer your question. http://www.tek-tips.com/viewthread.cfm?SQID=827443&SPID=782&newpid=782&page=1 Jerry

Thanks for the reply ... great info. I do have a lot of reports, but not many had string fields that I intentionally wanted to truncate, so I'll probably just do the manual work-around on those. Thanks again. Jerry

Satshergill: Did you ever resolve this? We just went from CE8.5 to CE9 and am seeing the exact same thing ... string fields that used to be truncated in 8.5 now overlap the next field in 9. All my symptoms seem to be the same as yours, except my current CE version is 9. Database is ORACLE. In...

Are you sure the users are actually selecting one of the radio buttons? Are you forcing one of the buttons to be checked by default, using the "checked" attribute? I'm using almost identical code on several forms, and the radio buttons work for me. Good luck Jerry

Check out CR Help for the DateDiff function. You'll find the following example. I've used it successfully in CR8.5. For example, suppose you want to calculate the number of days between the order date and ship date, excluding Saturdays and Sundays: //Crystal syntax Local DateTimeVar d1 :=...

KingfisherINC is correct. I've used that technique many times and it's always worked for me (currently using CR8.5 and CE8.5). I create a formula for the file path (file://<host>/<path>/<file>) and use that for the hyperlink. Good luck. Jerry

I may not understand your question, but if you're trying to display a multiple value parameter on your report, here's a Crystal Decisions Knowledge Base article that explains how. I've used this successfully in several reports...