Thanks! I had not used "Add Command" before but it sure sounds like what I need. However, I'm having some trouble getting it to like the table name I give it. It is giving me "Query Engine Error: 'ORA-00933: SQL command not properly ended '". Per other threads here I've tried variations on...
CR 9 to an Oracle db (the database belongs to an outside group so I have no ability to make changes/views at the db level).
Each of 6 agencies has a parallel set of tables differing only by the first 2 characters of the table name (i.e. all the same field names, only the table names change)...
I'll look into the export to ODBC option as it sounds like it can cut Excel out of this process. However, I'll still be exporting out of Crystal to a table and then back into a new report unless a way can be found around my regrouping problem. I would much rather not leave Crystal at all but...
I'd much rather keep it all in crystal and not have to port out of one report and into another via a table in order to re-group. However since I can only hope to read the real database I have to make do with what I have available that I can write to (access). After I do my considerable...
After viewing a previous thread I had the idea that groups for formula purposes could somehow be suppressed so as not to affect the final report. Since that apparently isn't the case I went ahead with the very inelegant solution of exporting the refined data that was created with the original...
I'm using Crystal Reports 9.2.0.448
Hoping this is a very basic question but I don't know enough about the program and terminology to look in the right area to find the answer.
I've written a report that has three hierarchical layers of groups and in the footer for the innermost grouping I've...
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.