Results 1 to 4 of 4

Thread: Refresh and datareport

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Mar 2002
    Location
    The Netherlands
    Posts
    64

    Refresh and datareport

    I have a dataenvironment with a couple of command objects in it. These command object are sql queries to get the data from a database between two dates.

    In my program you can change the dates and then you press show and a datareport comes in the screen and shows yoy the data from the database between the two dates you gave. In the code i write the new query into the commandtext object and open and close the object and requery to make sure the data is refreshed.

    The problem is that when you change the dates often you have to press show 2 times before the right data is on the report.
    How do i make the refresh so that the data is always wright the first time you press the show button.

    thanx in advance

    PS: And how do you remobe the 2 buttons in the upperleft of a datareport when you use the .show method??

  2. #2
    Lively Member
    Join Date
    Apr 2002
    Location
    India
    Posts
    105
    yes this is common problem with datareport.
    goto data environment > goto properties of command and change its CacheSize property from 100 to 1.
    check the reports.
    if it doesnt work, then only thing u can do is unload the report and show it again.
    Shahab Ahmed

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Mar 2002
    Location
    The Netherlands
    Posts
    64
    anyone else?

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Mar 2002
    Location
    The Netherlands
    Posts
    64
    there must be a solution don't you people think to remove those buttons?

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