Results 1 to 3 of 3

Thread: variables not in table, to reflect in DataReport.. how?

  1. #1

    Thread Starter
    Addicted Member jeanette_db's Avatar
    Join Date
    Oct 2005
    Location
    DC, Phil
    Posts
    215

    Unhappy variables not in table, to reflect in DataReport.. how?

    i'm using data report...
    i wanna create a report without using the dataenvironment...
    and want "variables" in the program to reflect in the
    report without creating or storing it in a table ...

    example:
    i want the total amount purchased
    by a customer to reflect in the receipt.

    anybody help me with this.

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: variables not in table, to reflect in DataReport.. how?

    I like using temp report tables and binding a crystal report to them.

    I will create a table with the necessary fields for the report. Then, run an SQL query which will return a recordset. After I have the recordset, I delete all existing records in my report table, and populate the table with the data I just got from my newly created recordset and then run my report based on that.

  3. #3

    Thread Starter
    Addicted Member jeanette_db's Avatar
    Join Date
    Oct 2005
    Location
    DC, Phil
    Posts
    215

    Unhappy Re: variables not in table, to reflect in DataReport.. how?

    Quote Originally Posted by Hack
    I like using temp report tables and binding a crystal report to them.

    I will create a table with the necessary fields for the report. Then, run an SQL query which will return a recordset. After I have the recordset, I delete all existing records in my report table, and populate the table with the data I just got from my newly created recordset and then run my report based on that.
    does it mean, there's no way you can place a variable in the DataReport?
    so, i have to create a temp table where the variables be stored temporarily, in order for it to be reflected in the report?

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