Using Runtime Data Sources with Oracle 
Author Message
 Using Runtime Data Sources with Oracle

Dear Group

I got a problem with runtime data sources in Crystal Reports and I would
be very glad if somebody could give me a hint.

I'm using Oracle Dynasets in a VB6 front end. These OraDynasets are my
(primary) runtime data source for the reports. What I tried so far:

- Using the Crystal Report Control
As documented in the Crystal TechRef you can define a data source
control as data source for the report control. This is very handy but
has a major drawback in my opinion: The report evolving from this method
is very hard to maintain, because the field definition seems
unchangeable to me. This means that if I want to add a new field to my
report I have to design it again from scratch!!! So if anybody came
across this problem and solved it ... would be very interested.

- using a Crystal Data Object and working with Data Definition Files
According the manual you should use Report Designer Component instead of
a Report Control. But this isn't easier either. First I have to do flips
and twists until my data coming from the Oracle Dynaset is in this
CrystalDataObject. Then Data Definition Files don't support strings that
are > 254. You have to use Memo fields instead. And guess what ...
Crystal Data Objects don't support Memo fields! Which means that the
text fields in my report have 254 characters maximum length. This is
unacceptable of course (think of a simple serial letter). So a
suggestion how to bypass the limitations of a Data Definition File would
also very appreciated.

I'm Working with Crystal Reports 8.0.

Of course I tried I every possibility I can think of to make Crystal
work directly with OraDynasets and/or Oracle Data Controls (as ADO or
RDO). But except for the Report Control I had no success.

Thank you for every hint


Sun, 24 Jul 2005 02:11:25 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Visual Basic 4.0a error with ORACLE Data source accessing BLOB data

2. Using ADO Data Control on User Control as Data Source

3. Create User Control as Data Source Using ADO Data Control

4. VB Code Oracle data source connection (Word 2000 / Query 2000)

5. Update Oracle data using Data control and SQL?

6. VB4.0/Oracle/Data source name not found

7. Creating an ODBC Data Source at Runtime

8. changing data source in crystal report @ runtime

9. Crystal/ASP: Passing Data Source at runtime

10. Change ODBC Data Source at runtime

11. changing data source in runtime

12. Set source for grouped data at runtime


Powered by phpBB® Forum Software