Unbound Data Report Recordset


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Unbound Data Report Recordset

Hybrid View

  1. #1
    Dale Guest

    Unbound Data Report Recordset


    First off, I'd prefer to be using Crystal Reports but we currently have $0
    for software/development tools, so I'm condemned to use the Data Report.

    Now here's my problem. Due to the structure of our 3rd party Oracle database,
    I can't pull all the data I need with a single SQL into a data environment
    connection. So instead I'm pulling my data into a adodc recordset, then adding
    additional fields by performing functions based on the original recordset
    and other data from the Oracle tables. All of this is added to an unbound
    adodc recordset that becomes the data source of my data report.

    That works great, except that I am unable to add any sections to the data
    report (no group headers or footers). The only thing I can find on msdn says
    that sections must be sync'd with the elements of the GROUP BY statement
    of the data environment command.

    Does anyone have any idea how to work around this?

    Thanks,
    Dale Gravatt
    Software Engineer
    ATN: Advanced Toxicology Network

  2. #2
    Chris Guest

    Re: Unbound Data Report Recordset


    Dale,

    The only way I've been able to bind a disconnected recordset to a Data Report,
    and have grouping within the report, is to use the Datashape provider for
    ADO, and utilize a Shaping query statement. I realize your tight on cash,
    but the reporting tool from DataDynamics, ActiveReport, is an inexpensive
    reporting tool that works great. It's $250 on ComponentSource, and it provides
    a lot of functionality.




    "Dale" <dalegravatt@yahoo.com> wrote:
    >
    >First off, I'd prefer to be using Crystal Reports but we currently have

    $0
    >for software/development tools, so I'm condemned to use the Data Report.
    >
    >Now here's my problem. Due to the structure of our 3rd party Oracle database,
    >I can't pull all the data I need with a single SQL into a data environment
    >connection. So instead I'm pulling my data into a adodc recordset, then

    adding
    >additional fields by performing functions based on the original recordset
    >and other data from the Oracle tables. All of this is added to an unbound
    >adodc recordset that becomes the data source of my data report.
    >
    >That works great, except that I am unable to add any sections to the data
    >report (no group headers or footers). The only thing I can find on msdn

    says
    >that sections must be sync'd with the elements of the GROUP BY statement
    >of the data environment command.
    >
    >Does anyone have any idea how to work around this?
    >
    >Thanks,
    >Dale Gravatt
    >Software Engineer
    >ATN: Advanced Toxicology Network



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center