Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Melzer

    Opening Crystal 9 report in Crystal 8.5

    You can't do it. Any advice?
  2. Melzer

    Using Maximum

    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...
  3. Melzer

    Long string fields

    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...
  4. Melzer

    Long string fields

    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.
  5. Melzer

    Long string fields

    Thanks, but I tried all of that and I still get the error message.
  6. Melzer

    Long string fields

    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?
  7. Melzer

    Two oracle databases in one report

    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#...
  8. Melzer

    Two oracle databases in one report

    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...
  9. Melzer

    Long string fields

    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?
  10. Melzer

    Formula to calculate total

    Orderamt is a database field
  11. Melzer

    Formula to calculate total

    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...

Part and Inventory Search

Back
Top