Nevermind. I figured out my problem. I was in SQL Expressions, rather than Formulas. Formulas gave me what I needed.
Picture does work in the Formulas.
Thanks, though.
Devin
The Picture formula threw errors. We're on Crystal 8.5, if that makes a difference.
This version handles Left and Right just fine, but doesn't recognize Mid.
Devin
I've got an ODBC connection to an SQL database. What I'm trying to do is use an SQL Expression to make a field that pulls as 12345678901 show 12345-6789-01 in the report. I'm not very familiar with the string functions within Crystal. Any help is appreciated.
I am experiencing the exact same issue. The error box that pops up says:
A Runtime Error has occurred.
Do you wish to Debug?
Line: 2
Error: Syntax Error
The only variable has been the line number. Occassionally I'll see something more specific to a website page name when I visit certain sites...
We have the 64-bit SQL Server 2005 install CDs. A new application we purchased asks that we install the Client Connectivity Components on our Citrix servers and fat installs, which are 32-bit. We can't get past even the first splash screen of the CD. It brings up a scripting error. Something...
Yes, there are many wireless PDAs out there, but all of them take the 16 bit 802.11b wireless card ONLY (Intel refuses to make a different card). We have the 802.11a wireless network. B cannot talk on A. 802.11a wireless cards are 32 bit so they don't fit the PDA card slot, hence our plight...
We currently have 802.11a wireless technology (we are a six story facility). Our goal is to implement a computer system that will allow PDA devices to talk to our wireless network. I understand that the 802.11b wireless card is the only thing manufactured for the PDA.
We probably won't have...
This is exactly what happened on my father in law's PC. After I started in safe mode, ran scaneg /fix, and let it reboot everything was fine.
Does anyone know what caused this? The only thing he had done to his PC is install a Windows ME compatible printer. The printer and everything worked...
We do all our publishing work on a Mac. Unfortunately the company that we upload to is switching to all IBMs and has told us that we must switch as well or they won't be able to read what we send them.
What we're doing now is uploading PDFs. The images will upload to IMB okay, but the fonts...
We've been working with this batch file for several weeks now.
The goal: to copy a file to another server daily and delete the file instance on the first server; to rename the file with the current date on the new server; to check against the last formatted date before copy and delete (the file...
All the testing I've done has been on the server. I've tried opening and running the report from it's file location as well as from Info Report Designer. Both are successful. It just doesn't make sense why it would run from Info Report Designer and not from a scheduled job.
Seagate Info 7.0
Database: Access 97
Server: Windows NT
We have been trying to figure out this problem for weeks. It may not even be a Crystal issue, but I thought I would start here.
Above is the error we receive (in properties) after we try to schedule a report in Seagate Info. The report...
Actually, our UNIX guy realized what I wanted to do shortly after I posted this message. He was able to do what I needed, so we are in good shape. Thanks for replying, though.
Is there a UNIX command that would allow me to pull a file off the UNIX box and send it straight to a network printer?
Please let me know ASAP. This may make the difference of whether I'm going to have to take out a work order or not.
The AfterUpdate Event may work for us, but I have an additional question. At what point would the user see that decimal point appear? Would it just feed into the system when the record is saved? Or would it appear when the user moves to another field?
We wouldn't know when a value reaches...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.