I am trying to run an ad-hoc report by entering an SQL statement at
run-time and posting it to the Oracle data control's "Recordsource"
property. I have a Crystal Report control pointing to the Oracle data
control.
I know the sql statement is correct because I also have a Dbgrid linked
to the same data control and it updates no problem.
When I use "me.crystalreport1t.action=1" all that is printed are the
field names, and only those field names that will fit on the first page.
I have done the same thing using a standard data control and assessing
an Access database without any problems.
Is this a problem with Crystal Reports <-> Oracle or am I doing
something wrong? Does anybody have any ideas? I am using VB5 Enterprise
Ed and Oracle 8.
Is it easier to use the Standard data control or Remote data control
instead of the Oracle one?
Thanks,
John