Recent content by tpeters1

Thanks for responding. It seems that there there is consensus in the industry for creating new schemas according to logical, fuctional divisions. I have not heard the full force of the DBAs arguments at this point. But from his prior comments in passing, he seems to think that the...

I am a developer. When I create new applications I like to place all the tables for the application in one schema in order to organize the database and make it easier to understand. Our DBA is contantly pushing us to not create new schemas. Is our DBA full of "you know what"? Is one giant...

The fact that the formula dependencies have the command "whileprintingrecords;" may preclude the grouping of the data on that forumula. "whileprintingrecords;" forces the program to evaluate the formula while it is printing database record data. I would assume that whatever grouping has been...

This formula is dependent upon two other formulas {@monthlychro%} {@monthlytrc%} Please post the code for those as well.

I just created a formula and grouped on it. Works for me. What is the code for your formula? Are all the inputs for the formula available within the current row?

How about this? ((isnull({bookings.Location})) or ({bookings.Location} in ["Admirals Mews", "Admiral's Mews", "Celtic Haven", "Saundersfoot", "Waterwynch"]))

Dat don work eeder.

The datatype matches. Connnecting to the source table of the view works fine. The data comes through loud and clear. Of course view still does not work. Accessing the data has never been a problem. The problem is my seeming inability to utilize the advantages of database views. BTW -...

Here's hoping.... Verify Database returns "Database is up to date". Browse Data displays the column data type but no data rows.

I just set up a table of strings in an Oracle database and inserted your numbers. when I sorted in a CRXI report, they sorted in this order. -.34 -.22 -.21 0 1.2 So you have a formula that creates a string field that may or may not contain numeric data. Is that correct?

Yup. I just reconfirmed. SqlPlus returns rows. Crystal does not. No group or record selection criteria are implemented in the the report. *sigh*

I have created a CR XI Report using an Oracle 10g View as the data source and it does not return any data. The same query using the same user and other tools like TOAD or SQL*Plus return many rows. What is going on?!? Here is the Crystal Reports Show SQL Query: SELECT...

How can I mark this thread to show that it has been resolved?

I opened an installation incident with Business Objects and they provided a do it yourself solution that involved manually uninstalling the previous version of Crystal Reports: http://support.businessobjects.com/library/kbase/articles/c2017464.asp The procedure had me rip all the Crystal XI...

Isn't Crystal trying to use it's own version of the JVM? Witness the path cited above: "c:\Program Files\Business Objects\j2sdk1.4.2_08\bin\java.exe