Search results for query: *

Using Windows XP; IE 7 Crystal Server XI connected to Oracle db Run into a rather unique problem. On some PC's, users cannot copy/paste parameter prompts when running a report in XI however, they do not have the same issue when connecting to another server running CE 9. Both are set to use...

You're missing a ( between truncate and RND. Should be: WhilePrintingRecords; Numbervar Array array1; Redim array1 [100]; Local NumberVar i; For i := 1 to 100 Step 1 Do(array1 [i] := 1+Truncate(RND()*Count({Claims_View.Form_Number})))

Are you conditionally suppressing or adding that into your selection criteria? If in your selection criteria, change the <> to = and it should work just fine. I was adding into suppression criteria so it behaved just the same and only showed the 15's.

Try conditionally suppressing using the following: minute({TABLE.TIME}) <> [00,15,30,45]

I've done this with Crystal 9, XI and 2008 without any issues but can get tedious depending on what needs to be barcoded. What we did was create a formula to add to the report so that your info was enclosed in start/end characters the barcode recognizes such as: "*"+{TABLE.FIELD_NAME}+"*"...

While still not perfect, I did figure out a way to do this without having to have multiple "replace" statements later on for the different variations by replacing the leading "{" character in the string by combining with another leading character not being used anywhere else then removing it...

Hi lbass! Thanks for your quick reply. Original data is very variable. I'm using the "Display String" custom formula formatting in the Format Field trying to do this. Examples of original data would be: Case 1. {this.2004042214.1.HEIGHT}*15.5/{this.1918.3.LENGTH} Case 2...

Using Crystal XI and Oracle DB. I have a database field containing a set of values contained within {} which I've already been able to remove in most instances using a formula I found on Tek-Tips (Thanks lbass!!) for the display output. The formula which I modified slightly was: stringvar...

Aaarggghh!! Inserted disk for CS XI and it went straight into update mode instead of letting me do a new install. Now for the Tomcat installation it's asking for me to enter the existing CMS name. Is that the name of the cluster or...?? I'm confused.

Thanks. That's about what I was afraid of. Do you know if it would be possible to go ahead and do a side-by-side install of Crystal Server XI at this point; create new servers then import from my "broken" CE9 installation? My problem is that I just don't want to have to create all of the...

Using CE9 (currently) on Windows 2000 server. Recently, our IT group decided to upgrade our server and changed server names before talking to me because I wanted to upgrade to Crystal Server XI and import our data. Been through this hassle once before when they renamed servers and now CE9...

Group your data by CustName then insert a summary performing a count of Item. Conditionally suppress the data where the count of group items is > 1 such as: Count ({dbtable.ITEM}, {dbtable.CustName})>1

I've had a similar problem using a label printer where the server default printer settings had to be set-up identical to the printer settings used developing the report. Try changing the default printer settings on the server to 11 x 17 landscape. Even though I've been told it doesn't make a...

Sorry about that LB. That was my bad and I hit submit before thinking and shouldn't have recommended taking outside of this forum. I've got a report linked to the exact same database LIMS2 is using which is why it's kinda frustrating trying to explain w/o screen shots. Sorry. I'll let LIMS2...

Understood. I think I know where we're going with this.

WinLIMS it is. It appears as if you're creating summary fields instead of using Running total. You'll have to use running total to accomplish this. In the "Field Explorer" options, there is an option for creating a running total. This will open a pop-up box (they get named automatically by...

Sorry I didn't catch you were on v.10. I'm running v. 9 and it may be slightly different. There are three steps in a running total. First is selecting the field to summarize and the type of summary to conduct. Second part is the evaluation criteria. One choice for evaluation criteria is to...

Hmmm...those LIMS fields look rather familiar. First of all, if I'm not mistaken the SRESULT field indicates string type so you'll have to verify that (look to see if you have an NRESULT field which would be the numeric equivalent). This will require multiple running totals to accomplish...

It will work as long as you have the records sorted based on work order number first then by date/time.

In the section expert for details, click on the x+2 button beside Suppress and enter a formula based on work order such as: {workorder.field} = previous{workorder.field}