Search results for query: *

Thank you, Telemachus. The login request comes as a popup, and there is no "back" button to use. I'll remember your suggestion for future issues with other systems, but with this one, it doesn't seem to do the trick. Mountaine

I am trying to change databases on a report based on a complex Crystal query, and the databases are stored in DB2. Let's say I want to change from database Data1 to Data2. When I copy the query into a new report which is pointed to Data1, it works. When I copy the query into a new report...

In case anyone cares, the problem was solved when I switched from Oracle's driver to the CR driver for Oracle.

If I understand, you're using a "summary" to get the max for each deal type. If that's true, simplest way is to copy the "max" object from the GF2 (grouping by deal type) to the GF1 (grouping by portfolio). If this doesn't make sense, provide more detail on how you're getting the max for each...

This command works fine: SELECT INSTR('2000,2700',SUBSTR(fieldname,1,4)) TESTFIELD FROM tablename but when I create a parameter MyParam within the command and give it a default value of 2000,2700 I get an ORA-24374 with this: SELECT INSTR({?MyParam},SUBSTR(fieldname,1,4)) TESTFIELD FROM...

Thanks k. Since the problem is showing up both in CR9 and CE9, I don't think it's service pack related. I've done further investigation and noted that when the signs are reversed in Crystal, the Excel export shows all the numbers with "custom formats" that start with minus signs. So the...

Use a parameter that asks the user the question "which ending month do you want?" Let's say you call the parameter "LastMonth". Then use the result of that parameter in record selection, where the record selection tests the data to ensure that the month of any record is one of the ones you...

Hello happy Mike. The only way to add up stuff that Crystal doesn't want to add through "summaries" is to use formulas that create variables and then add whatever you need to the variables yourself. If you're an experienced programmer, you can take it from there using the Crystal help system...

There are many possible solutions to your problem. The best is to upgrade to CR9, which allows you to write a SQL command yourself, and you would create a query that is a combination of all the separate queries using UNION. If you know how to do that. I've done this successfully many times...

Using CR9, when I go into the format editor for a numeric field, and check the "reverse sign" option, and then export to excel (yes, even using the MS Excel 97-2000 data only choice, with "export object formatting" checked), the result in Excel is incorrect. Numbers that show on the Crystal...