Recent content by eileenr27

I tested to see if I could access the table I added by creating a new report and it displayed the data just fine. Not sure what your trying to tell me with the second suggestion though. Please draw me a picture.

I'm using Crystal Reports 7.0 I'm getting the following ODBC error after making a couple of changes to a report that was working before I made the changes. CHANGES: a have four groups. I changed the first group to a different field. Then, I added a database to the report so I could add a...

Yes. I unselected those records and was finally able to run the report without errors. Thanks to one and all who replied to this thread. You're all wonderful! :)

OK, as you suggested, I did a query to look at the data. What I think is causing the problem is because the database contains an end balance for each individual ledger. When it says "end balance" in the description field there is nothing displayed for the month or day.

I agree with you. I think the field may be null, but your formula also gives me the error, about "a month must be between 1 and 12" because in those instances where the condition is present we are making it 0. Is there any way around this? Another method?

THIS WHY I AM SUBTRACTING THE MONTH FIELD FROM 99: The database I'm working with contains dates stored as separate fields. Further, a code is used to represent the day, month or year. After the calculations are done I create a "real date" from them. MONTH: A month is normally stored as...

OK. I got past the number required here error with this formula: ============================================= If NumericText({OLGL.TRANS_MONTH}) then 99 - ToNumber({OLGL.TRANS_MONTH}) else 0 ============================================ In my report, I use 3 formulas like the one above to...

WHEN I TRIED THE FIRST SUGGESTION, IT GAVE ME AN ERROR WHEN I RAN THE REPORT WHICH SAID "STRING IS NON-NUMERIC". WHEN I TRIED THE SECOND SUGGESTION, IT GAVE ME AN ERROR WHEN I TRIED TO SAVE THE FORMULA. "A NUMBER, CURRENCY, AMOUNT, BOOLEAN OR STRING IS EXPECTED HERE." ANY OTHER IDEAS? THANKS.

I created a formula in Crystal Reports 7.0 to subtract a field in our data base which is a string, from the number 99. Right now I have: 99 - tonumber{OLGL.TRANS_MONTH} When I run the report it gives me the error: "A Number is Required here". The data in the field is always numeric, but...