Calculations in the Data Tab of Report Designer

rbuser

Using ADO Session and an Oracle db, in the Data Tab of Report Designer I
am able to successfully create dataviews. However, when I try to create
a calculated field in one of the dataviews, more often than not I get the
Oracle error, 'Not a Group By Expression". But if I cut the sql and run
the sql in Oracle Worksheet it runs successfully. I have been able once
or twice to create a calculated field, but not always able to recreate it
with any consistency. Do you have a clue what I might be doing wrong?
Thanks.



--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi,

This is not a known issue however we do not recommend using DADE with Oracle
and ADO. This combination has caused problems in the past due to some
limitations of each product. For an Oracle connection, we recommend using
Direct Oracle Access (DOA). This has been extensively tested and used by us
and many of our customers successfully.

http://www.allroundautomations.nl/

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Nico,

I?ve been told that on several occasions and I guess it is time to make
the investment, but before I do that I downloaded their trail version.

After dropping a TOracleSession on my dmform I expected when I opened my
report and looked at the DataBaseSetting/Connections that I would have an
option to select the DOA connection (TOracleSession). I didn?t. I still
have only the ADOSession, BDESession, DBExpressSession, and IBXSession.
What object do I need on my form in order to be able to see my tables and
fields from the Data tab in my reports.

Thanks for the help.

Ron

Oracle
using
by us
I
create
the
run
once
it



--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Ron,

You will need to register the DOA Dade plugin with the Delphi IDE in order
to enable the DOASession at designtime. The package is located in the
\RBuilder\Demos\4. EndUser Databases\Oracle\3. DOA\... directory. There is
a ReadeMe file also located in this folder that walks you through the
compilation and installation of the package.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Nico,

Ok, we are getting closer, but not finished yet. Following RB readme
file and thinking I need to recompile the package since I am not able to
locate the rbDOAxx.bpl file anywhere. Still following the instruction in
the readme file to re-compile and I get the compile error "Required
package 'doa34D10' not found". I have also looked everywhere for that
file and haven't found it. Any suggestion?
Thanks again,

Ron

order
is
my
an
still
and

nicocizik

Hi Ron,

Sorry about that, I forgot to mention that the rbDOAxx.dpk file is written
for a certain version of DOA. If you open the package and right click over
the package window in Delphi you can view the source. Inside the requires
clause you will see the doa34D10 package listed. You will need to change
this to the version package you downloaded. You should be able to find this
.dcp file located in the DOA install directory (check your Delphi library
path for this). Currently on my machine, the file should read doa40D10.
Change this entry and recompile/reinstall the package.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com