Search results for query: *

Has anyone ever seen this error in CR 9 when either opening or refreshing a report? If so, do you know what causes it? Many thanks.

you're right, I have no WHERE clause in my command object. The Select statement in from the Crystal Select Records formula. So how can you put those parameters in the SQL command object using a WHERE clause?

I am using CR 9, connecting to DB using ODBC data source. I am using an SQL command as my datasource. The problem is the length of time it is taking to run the report. I guess the SQL statement or something is not done very efficiently. The information returned is correct, but it takes a...

I changed the order of the tables used in the table. Putting the table with the most keys as table A and then linking them back one at a time, choosing a few records from each table I added to see if I was getting duplicate records. I never got duplicate records after that. The other thing I...

Yes the fields were exact duplicates, but I have spent "significant" :) time playing with the links (there were other tables involved) and I have finally achieved success! No more duplicates, Thanks though!

I am using CR 9.0. I have two tables linked using ODBC. Table one is called POCPODF and has following fields: PO_NUMB PO_LINE_NUMB ITEM ITEM_DESC etc. Table two is called A1PODTL and has following fields: PO_NUMB PO_LINE_NUMB PO_PRINT_CHAR Tables are linked on PO_NUMB and PO_LINE_NUMB. If...

I am using CR 9.0 after an upgrade from CR 8.5 with an ODBC connection to a Thoroughbred database with a Thoroughbred ODBC driver. I realize this is not a supported database...but I have been using CR against this database since CR version 5.0 with no problems. I have reports that were...

I just did an income statement doing the same thing you are doing. You need two groups - The first group would be the criteria for revenue and expense groups. The second group would be the criteria for your groupings within revenue and expense. If your Chart of Accts is well organized, you...

Perfect - worked like a charm! I really appreciate it. [2thumbsup]

I have created a parameter field that prompts for a range value. I need to get the beginning and ending range values in a title. I have no problem getting a discrete parameter value in a title, but can't figure out how to do the range values in a title. My parameter is {?item}. So I want my...

Is there anyway to not have the Field Explorer tree re-collapse each time you finish editing a formula from it. For example, I expand running total formulas, select and right click on formula to edit. Finish editing formula, save formula, Field explorer is collapsed again. If I want to edit...

I have three groups in my report which are currently using a unique specific order sort for each of the groups. I have a need for the second group to sort differently based on the first group. So for example, if the first group is equal to X, the second group would sort a certain way, but if...

I upgraded my Redhat 6.2 server to Redhat 7.3. I set up a couple of file systems for export in /etc/exports. Everything exported OK and I could mount the file systems on two other unix systems (AIX and SCO). However, when I'm on the AIX or SCO box and I try to change to a directory within the...

Is there any way to handle report revision or change control in Crystal Reports v.9? I want to see the changes from one version of the report to the next. Thanks.

Thanks for the help. It got me pointed back in the right directions.

If someone could help me with this formula I would really appreciate it. I need to define a variable Y that sums the values from general ledger periods only for a certain group of GL accounts. The value of Y changes depending on the GL period. So what I want is: if {?Period} = 12 then Y:=...

I am trying to create a line chart in Crystal using the following data: I have 4 colums that are represented by unique titles coming from the data source. My rows represent total quantity moved by an operator for that time period. So it looks something like this: Jan 1 Jan 2 Jan...

I need to round some financial numbers to thousands. If the number is $3,998,876.00 i need it to display as $3,998.8 - any suggestions would be appreciated.

basil3legs - the array formula did not behave as i expected it to. yes you're right i had the gl nos wrong, i was trying to shorten the acct nos and that's why the mistype. anyway, here's the formula i used based on what you sent: IF {GLCGLMS.GL_ACCT} in...

There is no selection criteria. It is a formula in a single cell in an income statement. Here is what I was playing around with: if {GLCGLMS.GL_ACCT} = "4000" then numbervar a := {GLCGLMS.GL_ACCT_CRY_VAL_5}; if {GLCGLMS.GL_ACCT} = "4100" then numbervar b :=...