Search results for query: *

The standard Map that you get out of the box with Crystal Reports (any version up through XIr2) is pretty sad IMHO. I had one today where the only entry for the group was in ALabama, the map showed it was in ALbania - and that was with US as the map selected [thumbsdown]. Does anyone have any...

I've got a String Parameter that has an Edit Mask of "AAA-AAA-AAA". In CR10 and CE10 it correctly shows " - - ". When the user types the 4th character, Crystal correctly "jumps over the dash" and puts the character in the 4th "masked" position. in CRXI and BOEXIr2, The same Parameter...

CR10 CE10 Oracle 9 Let me start off by saying that I'm an experienced Crystal Report writer writing my first series of reports against an Oracle 9 "FileNet" database. The quotes are there because, to me, they are just words that our Systems Oracle DBAs are telling me - they have little/no...

CR10 CE10 I've done a ton of Crystal Reports against DB2 and MS SQL databases but now I'm going to do my 1st report against Oracle (version 9.2.0.6 says the DBA) In setting up the ODBC Connection, it looks like the possible options are: CR Oracle7 CR Oracle8 CR Oracle8 v3.6 Microsoft ODBC for...

CR 10 CE 10 I seem to remember that in CR Rev 7 (or early 8.5?) that when you exported to Word, it really did it without Text Boxes. It was EASY to cut and paste with this setup. Now it's next to impossible. Does anyone else remember this? Is there a way around this (what I consider)...

CR V10 I have a subreport where I calculate the sum of miles driven last month for company vehicles. I use a shared variable to bring the mileage forward to the main report. It displays great in the Vehicle ID Group. Why can't I use that shared numbervar (formula) in a CrossTab? DataDog...

CR10 CE10 SQL Database A Join Command works great on a string. We've got a Parameter that is a number that we allow multiple values (thus an array with an 'unknown' # of elements). In a Formula, When we try to do a Join on the Parameter ( join(totext({?Join test})) ), we get the error "This...

In CR8.5, when you hit the lightning bolt to reenter parameters, the system didn't 'remember' your previous parameters. In CE8.5 the system DID remember your previous parameters. Now in CR10 it does remember the parameters but CE10 does not. Is there any setting in Enterprise 10 to get back...

CR 8.5 CE 8.5 SQL Server Data While I've written a few hundred Crystal Reports, This one has me stumped. I need to write a summary report for our High Speed Imaging application. There are 4 jobs that people do: 1. Document Preperation, 2. Document Labeling, 3. Scanning, 4 Indexing. In each...

In this post, thread782-504638, a Crystal User indicated that once you go to CR9, you can't save the report to back to CR8.5 format. (CR8.5 is backward compatible to CR 7.0). Could some of you CR Ninjas verify that please? Also, is CR9 compatible with Crystal Enterprise 8.5? DataDog 'Failure...

Our Server folks have CE 8.5 set up on a processor (nothing else on the box) running all processes (Job Server, Page Server, APS, etc). Currently our Job Server is set up to the default of Max 5 Jobs. We have an "Unlimited User" site license of CE. It seems to me that the Max Jobs...

CR 8.5 CE 8.5 MS SQL DB As I understand it, SQL Server doesn't have a "Date" field, only a "DateTime" field. (at any rate, the field in question is a "DateTime")Therfore, I set up a formula to extract the Date portion. //@DateFormula Date(IndexDateTime) Add 2...

I design a CR8.5 report with Alerts,publish in Crystal Enterprise 8.5, run it - NO Alerts Show up. What's up? (Tried Active-x and DHTML viewers). Hopefully the answer is not Rev 9. Any Ideas?

In previous Tek-Tips posts, users have explained very nicely, how to display multiple parameters in a report with: Method 1 numbervar counter; numbervar final; stringvar holder; counter := count({?Multi}); while counter > 0 do (holder := holder + {?Multi}[counter] + ','; counter := counter -...

I'm trying to set up a quarterly CE8.5 recurring report. That's the easy part. The problem is in CR8.5 in that there is no Period "LastFullQuarter" in the Select Expert. Is there an easier way than setting up formulas that say "If today is 1/1/2003 then TransactionMonth =...

If written about 100 complex reports with a vast amount of formulas,running totals, shared variables, parameters, etc. Now thery are saying we need to write Stored Procedures to drag down the data (for speed). Do I have to, in effect, start over on the reports with the SP instead of the...