Search results for query: *

We are attempting to access a FoxPro database through Oracle heterogeneous generic connectivity for ODBC. The error returned states that the table does not exist. We have researched the appropriate documentation and have completed all the prescribed steps to the best of our knowledge. Our best...

So how long soes Oracle support take to respond to an iTAR? My problem was posted today at severity level 3. Just getting a little antsy.

I have a report with 2 groups: one on a Region code and within that, a grouping on Officer code. I would like a page break before every Region group. I also would like a page break before every Officer Group except for the first Officer group in each Region group. I am able to do this by...

I want to display one line for each record that has a null value in a particular field. I also want to display one "summary" line for all records that have duplicate data in the field. My instinct is to set up a group on the field, but then all the records where the field is null are...

We are working with a system that delivers Crystal Reports via the web using ASP and IIS on an NT server. We have test and production systems set up. We are reporting on Oracle 8 and FoxPro 2 or 3 databases. Recently we have been struggling with reports that query both databases and have...

Can Oracle query data in a Foxpro table? I have heard that MS-SQL Server and Access can do this.

I have a report that is pulling data from two different databases: FoxPro 3 and Oracle 8. The report runs extremely slow, if at all. CR seems to be pulling all the possible rows from Oracle and all possible rows from Foxpro and then selecting records from that pool. The "Show SQL...

I have a container report with a page header and a subreport that does not require a page header. Is there a way to suppress the container report page header whenever the subreport is printed?

I have a report that prints in landscape orientation. Each group will generate a letter using a subreport that must be printed in portrait orientation. Is there a way to specify a subreport page orientation that is different than the container report page orientation? I can see that one...

I have a container report that has 17 fields and corresponding column header text labels. There are six subreports that display at the end of the container report. Each subreport has a report header with column labels that are different from the container report. When a subreport happens to...

How can I create a string of characters longer than 255 characters from within a formula. The String data type seems to limit the capabilities of crystal to 255. Importing longer data types from a database seems to be possible, why can't I create one in a formula? Thanks for your help, Todd...

My query returns many records for each loan loan number. I want to display only one record for each loan number. Each record has a different date. I would like to display the record with the most recent date for each loan number and sort the report in accending order on the date. This forum...

I am reporting on an Oracle 8i DB with Crystal reports 8.5. The report requires a line summarizing each days sales. Some days have no sales in the table. How can I display a line showing the date and and zero sales for the day if there are no records with that particular date included in the...