Hi All, <br>
<br>
I have a report with 3 subreports. The main report and each subreports get their data from stored procedures to Oracle 8(different stored proc. for each reports). <br>
<br>
Each stored procedures gets parameters (dates...) and run a query against a view. Each stored procedures...
Please disregard the last sentence (I would use Stored Procs.) in my previous message . <br>
<br>
Forgot to clean-up ;-). (Although I wish I could use stored proc). <br>
Hello All,<br>
<br>
I am using Crystal Reports 7 to build reports for Oracle 8.<br>
<br>
Usually, my reports call views from Oracle. But for some reports, I need to calculate data as the data is gathered. <br>
<br>
So my question is the following:<br>
<br>
Is there a way to return multirows...
I found what the problem...<br>
<br>
When using subqueries, alias for tables should all be different otherwise the driver ODBC seems to misread/mix them.<br>
<br>
I fixed that and now it works.<br>
<br>
Weird... :)<br>
Carp,<br>
<br>
That's what I believed but not so.<br>
<br>
I found what the problem was though...<br>
<br>
When using subqueries, alias for tables should all be different otherwise the driver ODBC seems to misread/mix them.<br>
<br>
I fixed that and now it works.<br>
<br>
Weird... :)<br>
<br>...
Hi All,<br>
<br>
I'm building reports that gets its data from Oracle 8.3 through Intersolv ODBC driver. <br>
<br>
I've created a view (fairly complex one) where subqueries and union are involved. When i run the view in Oracle ( select * from view) all is OK. The data appears.<br>
<br>
My problem...
Hi All,<br>
<br>
I'm building reports using Crystal Reports that gets its data from Oracle 8.3 through Intersolv ODBC driver. <br>
<br>
I've created a view (fairly complex one) where subqueries and union are involved. When i run the view in Oracle ( select * from view) all is OK. The data...
Hi Spook001,<br>
<br>
If you are looking for help and advice on VFP, you should visit Universal Thread web site. It is THE web site on VFP<br>
(http://www.universalthread.com/).<br>
<br>
As a member (free of charge) you can ask questions to the VFP community (the top guys in VFP are...
There is a bunch of us, here in Montreal (Canada).<br>
<br>
We thought that PROGRESS was big in the US, according to the peg (peg.com) site.<br>
<br>
Anyways, there is some work around here in PROGRESS but the community ( developpers and companies requiring PROGRESS) is small.<br>
<br>
If you...
databarn,<br>
<br>
Thanks for the reply.<br>
<br>
I know I can do this if i was launching report from VB or VFP (or any other language). But can I do this within Crystal Report?
I do not know if that will apply...<br>
<br>
I did some work with PROGRESS 4GL and we had the same kind of problem, except it was with the report writer included with PROGRESS.<br>
<br>
Anyway, we found out that we had to be real careful with the font that we were using, especially if it was...
Hi, <br>
<br>
I am using CR7 with ORACLE 8. <br>
<br>
I<m designing reports that will be launched through Lotus Notes. I will produce a exe file for each report. Some of the reports have parameters, some other dont. <br>
<br>
My problem is that every time i launch a report, the report needs...
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.