Search results for query: *

Thanks for the tip. The DBA looked at it and altered the table and added a format statement on the column in the table. CHG_BCK_AMT DECIMAL(7,2) FORMAT 'ZZZZ9V99' NOT NULL

I have an input file that was created in a COBOL program that extracted the data from DB2. The file layout is as follows: 01 DCLGFTRSTY. 10 GFTRSTY-RGS-ID PIC S9(9) USAGE COMP. 10 GFTRSTY-LOC-NBR PIC S9(9) USAGE COMP...

I have a file that I'm trying to load into Teradata. The field is defined as a char(7) in the .layout and I need to load it into a decimal(7,2) field in Teradata. I thought a definition of (7,2) means 5 digits before and two digits after the decimal. My data isn't appearing correctly in the...

Thanks for the formulas and I am in the process of writing these formulas for all of the card types that are in the field in the Teradata database. I have one question, once I write the formulas for Visa, Amex, Mastercard, etc. How do I get the appropriate function to appear next to the...

I apologize for not following the forum posting rules. This is my first time working in Crystal and posting onto a forum. The requirements are to create a report that calculates the total orders and total dollar amounts of fraud charge backs by credit tender type and product group. The first...

Thanks for the responses. I've tried the Evaluate after and whileprinting record options and those didn't work. I've also tried to create the summaries which works for the first few columns that I have on my report but some of the columns have conditions in them and I'm unable to satisfy the...

I'm running version 10 and my report needs to calculate a percentage using a grand total that is created with a running total. It looks like the totals and percentages are being calculated during the same pass. I need the grand total for the # ordered to calculate first so that I can use that...

Thanks for the help. I apologize for not stating the version. I am running version 10. I tried creating the running total you mentioned above , but the evaluate doesn't give me the option to insert another running total inside of a running total. The answer to my question doesn't have to be...

I am a fairly new user to Crystal and I'm creating a summary report that keeps track of the number of orders received for a particular credit card. I created the first couple of columns using running totals and I inserted summaries to display the percentage of usage by credit card. That part...