DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Crystal report from dao recordset, need to make new page in report for each new record in set

  1. #1
    michelle URGENT!! Guest

    Crystal report from dao recordset, need to make new page in report for each new record in set


    I have a Crystal Report that I want to pull info from my VB program,
    specifically from a recordset, data control or list box - not
    directly from a database table. The data returned to the recordset,
    datcontrol or list box is based on an sql query dependent on
    variables user inputs. I never know how many variables (records)
    might be returned, it could be 5 or it could be 20. The Crystal
    Report can access the first record but does not create new pages for
    subsequent records. I also want to stay away from creating a temp
    database table. I am using Crystal Reports version 5. Thx!


  2. #2
    Arthur Wood Guest

    Re: Crystal report from dao recordset, need to make new page in report for each new record in set


    Michelle,
    Can you place an instance of the Crystal Reports Report Viewer in you
    application, pass the report the selection parameters and use the RecordSelectionFormula
    property of the report to generate the same query to retrieve the data for
    the report.

    You might want to look at the Sample VB Apps which Seagate provides with
    Crystal Reports (if you have access to the samples). I have CR on my machine,
    nad they have a sample Hotel applicatin which generates a "Customer Bill"
    as a CR Report, with the query based on Customer and Date-drange, which are
    user selecteable.

    Arthur Wood



    "michelle URGENT!!" <mwhalen@hotmail.com> wrote:
    >
    >I have a Crystal Report that I want to pull info from my VB program,
    >specifically from a recordset, data control or list box - not
    >directly from a database table. The data returned to the recordset,
    >datcontrol or list box is based on an sql query dependent on
    >variables user inputs. I never know how many variables (records)
    >might be returned, it could be 5 or it could be 20. The Crystal
    >Report can access the first record but does not create new pages for
    >subsequent records. I also want to stay away from creating a temp
    >database table. I am using Crystal Reports version 5. Thx!
    >



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