Results 1 to 5 of 5

Thread: vb datareport

  1. Oct 21st, 2007, 11:01 PM #1
    waran
    waran is offline

    Thread Starter
    Member
    Join Date
    Jan 2007
    Posts
    34

    vb datareport

    Hi,

    I have created a DataReport that is bound to a DataEnvironment for it's recordsource and I have a problem with the report not refreshing until I close out of the application and get back in.

    For example, before I first run the report, I can enter some data and then run the report and it's fine. Then, if I close the report (not the application), change or add data, then run the report again, it still only shows the previous data, without the latest updates. It only shows once I close out of the application completely and then get back in and run the report.

    Any ideas?

    RptAgent.Refresh
    RptAgent.Show
    Last edited by waran; Oct 21st, 2007 at 11:50 PM.
    Reply With Quote Reply With Quote
  2. Oct 21st, 2007, 11:02 PM #2
    rianne809
    rianne809 is offline
    Member
    Join Date
    Sep 2007
    Location
    Lictin
    Posts
    36

    Re: vb datareport

    can i see your code?
    Reply With Quote Reply With Quote
  3. Oct 21st, 2007, 11:21 PM #3
    leinad31
    leinad31 is offline
    PowerPoster
    Join Date
    Nov 2002
    Location
    Manila
    Posts
    7,629

    Re: vb datareport

    Consider binding an ADODB recordset to the data report directly at run time and drop usage of data environment.

    http://www.vbforums.com/showthread.p...ataenvironment
    Roman Numerals, Number In Words,Indian Currency Format, Modified Insertion Sort, Fibonacci
    Reply With Quote Reply With Quote
  4. Oct 22nd, 2007, 05:27 AM #4
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: vb datareport

    Moved to reporting
    Reply With Quote Reply With Quote
  6. Oct 23rd, 2007, 01:27 PM #5
    wes4dbt
    wes4dbt is offline
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,515

    Re: vb datareport

    Try thes

    Code:
    If Datarenvironment1.rslots.State = adStateOpen Then
        Dataenvironment1.rslots.Close
End If

Report1.Show


    You'll find alot of information already posted on this problem by searhing this
    forum.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width