Results 1 to 5 of 5

Thread: Crystal Report Help

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jul 2006
    Posts
    27

    Crystal Report Help

    Can anyone tell me how to use crystal reports without a database? I need to create a report based on public variables.

    I appreciate your help.
    Ace

  2. #2
    Lively Member
    Join Date
    Mar 2006
    Posts
    94

    Re: Crystal Report Help

    Quote Originally Posted by AceFlyer
    Can anyone tell me how to use crystal reports without a database? I need to create a report based on public variables.

    I appreciate your help.
    Ace
    Where are the variables coming from? A VB program?
    Energy can be neither created not destroyed. It can only be wasted.

    Red Green

  3. #3

    Thread Starter
    Junior Member
    Join Date
    Jul 2006
    Posts
    27

    Re: Crystal Report Help

    Quote Originally Posted by King_George
    Where are the variables coming from? A VB program?

    Yes, the data is coming from a vb6 program through its public variables.

    Ace

  4. #4
    Lively Member
    Join Date
    Mar 2006
    Posts
    94

    Re: Crystal Report Help

    Quote Originally Posted by AceFlyer
    Yes, the data is coming from a vb6 program through its public variables.

    Ace
    Then in that case the only way I can see it possible is by using parameters on the report. Put the same number of parameters on the report as there are public variables and then assign the values in the VB app before calling the report.

    Of course, this will only work if there is only one variable per parameter and a known number of variables.

    A better way, but more involved is using a ttx file. You simply create an unconnected recordset, fill it with the variables and then send the recordset to the report via ttx. This will work if there are lots of variables because you can add rows onto the recordset as needed.

    HTH
    Energy can be neither created not destroyed. It can only be wasted.

    Red Green

  5. #5
    Junior Member
    Join Date
    Nov 2005
    Location
    Daman, India
    Posts
    19

    Resolved Re: Crystal Report Help

    You can create the blank report. After that you put the
    data_place_holders like say text box. Suppose the name
    of the textbox is crTxtBox1. From your VB program, you can
    set the value of this text box (NameOfCrystalReport.crTxtBox1.settext "Text
    to be set")

    Utpal Mehta

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width