I want to show the amount field (which can may return more than one entry per record) but only in the group where the maximun has been reached. Any ideas?
For example.
Record 1 can have 5 sub records. I want to show the amounts for Record 1 but only where the 5th subrecord appears. I've tried...
synapsevampire,
As soon as I read your first post here I tried starting w/ a new report. I've used every syntax possible, quotes around the table and field, single quotes, no quotes. Tried w/ ODBC and logging in directly to the oracle server and all I get is the error messages. Checked the...
I'm using Crystal 8.5 and oracle database (8.1.7). I'm logging in directly to the oracle server. I've tried using the OBDC as an alternative but I still continue to get the above errors.
Thanks for everyone's help.
I tried the above and when I go to save in the SQL Expression Editor I get the following messages:
Error in initializing SQL Expression parser.
Error in creating SQL Expression COM parser.
Can anybody help?
Thanks roadkill.
I'm pretty sure my db drivers are up to date.
My problem with linked subreports is that I'm tracking records as they appear on both databases and I find that with sub reports I don't usually get that one-to-one result I need (e.g., doc.#, amount for the one database and doc#...
I am bringing two oracle databases into one crystal (8.5) report. I find that if I bring in many tables from one database I can only bring in one table from the other. These two database DO work together and share a common (key) field which is what I am linking on, but once I bring a second...
Ever had a field in one of your tables that is a long string varchar. Ends up you can't select of create a formula in Crystal Reports on these fields. Anybody have any advice?
Using crystal 7. I have two fields: Ordernum and orderamt
Problem is orderamt only caculates cumulative amounts:
Ex.: Order 1 for $100
Order 1a for $100
Comes out as Ordernum Orderamt
1 100
1a 200
I need a report that...
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.