Recent content by jschodde

Is the 11.5 runtime compatible with reports I create using the 2008 version of Crystal?

tsuji, Thanks for the code! I'll try what you've created. Please ignore the last part because those functions are application-specific: var negdatestamp = new XMLDate("P"+days+"DT"+hours+"H"+minutes+"M" +seconds+"S"); return negdatestamp.getDatum(); Jeff

I have the following javascript function which I need written in vbscript. Would any of you fine people out there care to help a poor fellow out? I only need to return a date/time value. Basically I need a "negative date" for sorting purposes. The table that stores this value actually has a...

Good idea! I'll try that. Thanks, Jeff

I have a database with a phone number field that can have any combination of digits and characters in it. Some people have even type in names, notes, and other junk. I don't care what they wrote, I just need to remove all the characters EXCEPT digits '0123456789'. Can anyone help me on this...

The "key" field in that case would not be unique (my mistake). What would determine the "key" field value?: If I were to write some kind of stored procedure, I envision looping through each row of the text field and inserting rows into a cursor or some other table. I'm not sure a simple...

I have a table that contains a unique key and a text field. The text fields contains part numbers of different lengths like: key part_numbers ----- ------------ 1 99 999 9999 2 99999 99 9999 Over time, the length of each part number could get longer...

I have a report which requires multiple reports in one. I know I need subreports but I'm having trouble getting the data to print in the right place. In the main report I have a summary table with ticket numbers - nothing fancy. In the subreport I need to show each ticket number with...

I'm not only having that problem, but I'm also getting extra characters added to words. Like "the" would be "thee". If I turn off the HTML formatting, I don't get that problem. -Jeff

synapsevampire, Thanks for the reply. I tired running the report using the application which utilizes the 9 runtime and it was showing the HTML tags. I've since downgraded that application to an earlier version which comes with the 8.x runtime and it works fine now. I'll have to figure this...

I have Crystal Reports 8.5 installed on my machine. I also have an application that uses the 9.x run time engine (i.e. files under C:\Program Files\Common Files\Crystal Decisions\2.0\bin) I have an 8.5 report with a memo field with Text Enterpretation set as HTML. The data only has simple tags...

Very cool idea...thanks Lisa.

Good points...thanks! -Jeff

If you would like to have alternating white/silver band colors on your group sections, here's what you do: 1. Right-click on the group footer and select "Format Section..." 2. In the section expert dialog box, click on the "Color" tab and check the "Background...

Thanks...I was afraid it wasn't going to be that simple. -Jeff