Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Crystal Reports and Subreports
eric,
I had a similar problem but without the subreports. I had several tables that were linked via a number of variables and everytime i tried to run the report it only came back three records. Come to find out that the person who setup the tables in Oracle used the same variable name in a numbr of tables even though the information was different? therefpore it was only reporting back to me the records that met both criteria. Once I broke that link it worked perfectly! Don't know if this helps or not.
BTW, I just started using CR on an oracle database and it really helps developing the reports. Don't give up.
eric farquhar wrote:
> Hi,
>
> Does anyone out there have a good knowledge of using Crystal Reports with an
> Oracle Database. I have created a simple report which lists corporate
> clients from one table. I now want to add a subreport listing corporate
> share schemes that relate to these clients. To do this I have to join 5
> tables and link via the client id. However when I do this in crystal it
> brings back no records, but if I run the query in SQL*plus it brings back
> all the correct results. When I look at the visual linking expert everything
> is fine but when I show the sql it is not fine. It won't let me change the
> sql either. I am guessing that subreports can only be written between two
> tables as I have managed to get that to work. In fact has anyone ever
> managed to successfully write the report they wanted using Crystal? It is
> driving me nuts.
>
> Any ideas?
>
> Eric F
Received on Mon Oct 18 1999 - 08:50:21 CDT