Search results for query: *

Not bad...They called within a half hour.

...Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SQL> select count(*) from loan@smart; select count(*) from loan@smart * ERROR at line 1: ORA-00942: table or view does not exist [Generic...

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

Doesn't appear to be a unique identifying column for each record. My best idea so far is to create a global counter variable: global numbervar aNum := 0; Then create formula called groupingFormula: global numberVar aNum; if isnull(myTable.myField) then ( aNum := aNum + 1...

Each null record should be diplayed as one line, or in a group of one record depending on how we solve the problem.

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

right on! you da man. little did I know that I should be searching on the word like heterogenous...:)

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

How do you create stand alone SQL and bind it to crystal? Do you use the Crystal SQL Designer? I tried to run my report with the Foxpro side in a subrport that is displayed on each Oracle detail line. I poweered down my pc and left for home after one and a quarter hours.

yes

There is no one to many relationship between the tables. The Oracle side has the more specific where clause criteria. User-entered parameters are used to narrow the selected set to about 900 records. On the Foxpro side the where clause criteria narrow the selected set to about 10,000...

From Oracle: 8 fields from one table From Foxpro: 4 fields from two tables Nothing fancy, just alot of rows. 10000+ on the Foxpro side. I tried putting the queries in subreports. Once with Oracle and once with Foxpro. Neither report ran much faster. Thanks for your help.

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

We have had similar problems here. I tried adjusting the position of the fields that are elevated down a bit but have since given up because it depends on the version of the viewer and seemingly the printer one is using. we have just come to the conclusion that one of the drwbacks to CR is...

u da man!

mmaz, I tried your solution and it did not seem to work. As a test, I displayed the shared variable that stores the number of records for the subreport in the container report page header and it is always zero.

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?

Right on. Thanks.