Search results for query: *

Hello! I'm newly back to writing SQL code, and I don't have a lot of experience writing queries using explicit join syntax. Here's my code: SELECT ( select sum(y.ded_cur) from ps_pay_check x INNER JOIN ps_pay_deduction y ON (x.company = y.company AND x.paygroup = y.paygroup AND...

I'm having ongoing issues with using SQL Expressions, and I'm hoping that there's some help to be had here. I'm using Crystal v11.5.10.1263, which is SP4 (I know, I know, I'm working with my vendor to get it updated.), against an Oracle 9.2.0.6 DB. The problem is that I keep getting this...

I'm very experienced with Crystal (10+ years), but I've never made use of SQL Expressions before, and I'm running into issues. I'm using Crystal XI (11.5.10.1263) with an Oracle database. The strange part is that some work and some do not, and I'm unable to figure out any rhyme or reason as to...

I have a client who's still using Crystal v10. I've installed the software, but I can't find anywhere to download the last SP that was issued for it. Does any of you know of any site where there are archives of the old Crystal SPs, or have a copy that you could link me to in Google Drive or...

I'm using Crystal v10 SP6, and I'm exporting a report to .pdf format. I'm running into several issues: 1) Fixed position currency symbols are showing up as floating. 2) Double borders on the bottom of number fields are showing up as single bold lines. 3) Various alignment issues with text...

I'm creating a very basic chart in Crystal v10. It's based on a spreadsheet, and contains percent change values for three different financial indicies (columns) for each of four different time frames (rows). The chart itself is working fine - I selected the time frame in the top dropdown, and...

Very odd problem. I'm running Crystal v10, and, when I try to open the Formula window it doesn't show up. The same thing happens no matter the circumstances - if I'm trying to edit a formula, create a new formula, or edit the selection formula. Crystal thinks it's open somewhere, because the...

Is there any way, in Crystal v10, to set the formatting of a text string in a formula? For example, I have a formula that outputs a string. I need the value of that string to be in bold italics in my report. The problem is that I'm not putting that formula directly into the report...it's used...

I'm building a report in Crystal v10 that uses both a Progress database and an Excel spreadsheet as data sources. There's a column in the spreadsheet where all cells are formatted as text. I'm trying to link the fields in that column to a text field of the same length in the database, and I'm...

I'm building a spreadsheet in Excel 07 that will be used as a datasource for a Crystal report. There's a column where every cell must be a six-character string. Where the actual data is not six characters long, the data will be preceded by leading spaces to pad the field to six characters. As...

I'm using Outlook 2007 on Windows XP. Is there a way to set up Outlook sigs as remote files? I can’t find a way to do it – when I create a file on the server, then select it as a sig on someone’s machine, Outlook makes a copy of the file to the local machine. I’d like to be able to maintain...

I'm running XP Pro, SP2. When I initially configured my machine, I just accepted the default machine name. Today, I changed the name of the machine and connected it to my company's domain using that name. Now, I can log into the domain properly, but I can't log into my local machine as an...

I'm running Excel 2003 with all of the latest updates on a machine running XP SP2. Whenever I open Excel using any method (clicking on the shortcut or clicking on a .xls file) I get the error message below four times, each time with a different <filename>. "'<filename>' could not be found...

I'm running Crystal v10, and I'm trying to conditionally enable the display of a currency symbol on a numeric field. I guessed that this would work just as a suppression formula, and just entered a simple boolean statement. When I tried to save, I got the error "result of formula must be a...

I'm having the same problem that was mentioned in thread766-1131562, but that post was never resolved. I'm using Crystal v8.5 and Excel 2003. I've created an ODBC data source in Windows, but when I try to add the data source to a report, I get the message "No Items Found" when I expand on the...

I have what I think is a fairly simple question, but I can't figure a way to do it. I'm using Crystal v10 SP4 on a Progress database. What I need is to show only the most recent five records, by date. The significant fields in the table are <CntctDate>, <CntctText>, and <CntctNum> (a unique...

I'm using Crystal v10. My customer wants negative fields to show up in red on her report. I know that I can go into each of the many fields and conditionally format the field based on the value of that particular field - very time consuming with many fields in many reports. What I'm wondering...

I'm using CR v10, SP 3. Is there a way to extract the individual values from a multiple value parameter? For instance, I have a string parameter that allows the user to enter either multiple discreet values or range values. Is there a way in which I can check how many characters are in the...

I was working on a report two days ago in Crystal 8.5. I saved the report successfully when I left for the day. Now, when I try to load the report, Crystal simply crashes to the standard Microsoft Notification screen, followed by the error messsage 'The instruction at "0x73dd1351" referenced...

I'm using Crystal v10 on a Progress database. Has anyone ever experienced a situation where including either side of an OR statement in a set of selection criteria returns the expected results but, when both sides are included, some records are excluded, seemingly at random? Thanks, -David