Report only showing static data

Last post 02-22-2007 9:04 AM by wibblet. 3 replies.

Sort Posts:

  • Report only showing static data

    02-10-2007, 9:08 AM
    • Loading...
    • wibblet
    • Joined on 01-20-2007, 11:31 AM
    • London
    • Posts 22

    I am developing an ASP.Net website.  I created a report that uses a dataset I created using the dataset designer, and resides in the App Code folder and is viewed via a report viewer (i.e. not crystal report)

     

    It uses one parameter, passed in a query string on the URL.  I thought it was working just fine until I realised that the data is static.  i.e. The data displayed is static as of the time I originally created the dataset.  I can add new records to my database, but I canot display them in a report.

     

    So how can I fix this?

    My skills just about stretch to creating a dataset on page load.  Can I then bind it to the report I designed?  If so, how?

    Or is there an easier option, i.e. forcing the dataset to refresh each time the report is called?

     

    As always, any suggestions or help gratefully recieved.

  • Re: Report only showing static data

    02-10-2007, 12:08 PM
    • Loading...
    • SGWellens
    • Joined on 01-02-2007, 4:27 PM
    • MN, USA
    • Posts 3,103
    • Moderator
      TrustedFriends-MVPs

    It's sounds like the page is being cached, either on the client, or at the server.

    I had a similar problem and found the browser had been set to "Work Offline".

    Steve Wellens
  • Re: Report only showing static data

    02-10-2007, 12:41 PM
    • Loading...
    • willydavidjr
    • Joined on 01-07-2007, 8:58 AM
    • Developer St., Programmers Homes, IT City
    • Posts 166

    I think I've encountered the same problem before, try to look on controls on your form and change the property to "copy if newer".

    Microsoft Student Partners

    Willy David Jr
    Junior Software Development Engineer
    Gurango Software Corporation

    Programming is a Passion, Software Development is an Adventure - willydavidjr
  • Re: Report only showing static data

    02-22-2007, 9:04 AM
    • Loading...
    • wibblet
    • Joined on 01-20-2007, 11:31 AM
    • London
    • Posts 22

    The application is definitly set to 'Online' so that's not the issue.

     

    Which control do you mean?  I went through just about all the properties, changing them to see if there was any way of getting it to work.  I tried setting the refresh to 2 seconds to see if that would work, but I just got endless copies of the same old data.

     

    I'm beginning to run out of time so sorry if I sound frustrated and on the edge of panic.

Page 1 of 1 (4 items)
Microsoft Communities
Page view counter