Using a Database Data Source with the ReportViewer Web Server Control in Local Processing Mode

Rate It (1)

Last post 01-14-2008 2:47 AM by atleten. 4 replies.

Sort Posts:

  • Using a Database Data Source with the ReportViewer Web Server Control in Local Processing Mode

    11-18-2005, 9:36 AM
    • Member
      5 point Member
    • Pabro66
    • Member since 11-18-2005, 2:30 PM
    • Posts 1
    Hi,
    I tried to follow all the steps in the "Walkthrough: Using a Database Data Source with the ReportViewer Web Server Control in Local Processing Mode" (http://msdn2.microsoft.com/en-us/library/ms252123(en-US,VS.80).aspx), but when I end up the step "Define a data connection and DataTable by adding a DataSet" and start the step"Design the report", after I insert the Matrix (step 5.) I always find the "Website Data Sources window" EMPTY . . . please Help :(

    Paolo Brogelli
  • Re: Using a Database Data Source with the ReportViewer Web Server Control in Local Processing Mode

    11-18-2005, 3:44 PM
    • Member
      156 point Member
    • masako
    • Member since 06-11-2002, 12:57 PM
    • Redmond, WA
    • Posts 29
    • AspNetTeam

    Hi,

    I follow the steps in the walkthrough, and see DataSet1 I created in earlier in Website Data Sources window.  Once thing I can think of is, in order to generate dataset, you have to make sure dataset is SAVED after TableAdapter is created.  Please try saving the file after step 12 of "Define a data connection and DataTable by adding a DataSet" and see if you can find DataSet1 in Website Data Sources window.

    Masako 

     

     

    masako

    -------------------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights.
  • Re: Using a Database Data Source with the ReportViewer Web Server Control in Local Processing Mode

    10-15-2006, 11:50 PM
    • Member
      30 point Member
    • gtrfinger
    • Member since 09-14-2005, 9:28 AM
    • Posts 13

    Hi, I am facing the same problem. But I am using Business objects as the data source for a local report. The Website Data Source window suddenly becomes empty without a reason. I have undone everything I did but does not help. Feel so sad that Visual Web Developer has failed to at least indicate what has gone wrong so that we know from where to look for the problem...

    Have you found your solution anyway?

    Jey Leong
  • Re: Using a Database Data Source with the ReportViewer Web Server Control in Local Processing Mode

    10-16-2006, 4:55 AM
    • Member
      30 point Member
    • gtrfinger
    • Member since 09-14-2005, 9:28 AM
    • Posts 13

    I finally found a way to "fix" it, but does not work all the time~~~

    In my asp.net application, in the bin folder, there are a couple of dll components. After I cut all of them and paste to a safe place, the Website Data Source window will be back in functioning, at least showing the "your project has no data source" information. Then I restore the dll files one by one. After restoring each dll file, I will refresh the Website Data Source window to see if it is still working, until the time it doesn't, then the dll file is the suspect that "spoiled" the Website Data Source window.

    Then I will have to scan through all the codes in that component by commenting/uncommneting the codes, and refreshing the Website Data Source window, to catch the codes that "spoiled" the window.

    Finally, try to change the suspect codes to work in a different way until the Website Data Source window works, say, changing the return value type of a Function from a custom business object type, to a general Object type.

    I was very happy that I solved this problem, until the same problem happened again...

    A different suspect dll file was caught. And I have to repeat everything... It's ok still quite ok for me to do this since the codes are still little, but I can't imagine that I still need to do all these when I completed the whole project.

    This problem is just so random...

    Is this a bug or something in Visual Web Developer add-in report control? Anyone any idea?

    Jey Leong
  • Re: Using a Database Data Source with the ReportViewer Web Server Control in Local Processing Mode

    01-14-2008, 2:47 AM
    • Member
      8 point Member
    • atleten
    • Member since 01-08-2007, 9:55 AM
    • Posts 8
    Hi. Workaround that worked for me. 1)Add ekstra aspx page 2)Add ReportViewer 3) go to design mode--> klick > in upper right corner and choose Design new report(and after it opens, do not choose datasource , just close the window). (if you get out of range error or something like that, go back to your rdlc and delete all items without a datasource from the report, build and repeat steps) After this the Website data soruce window is back. Using visualt studio 2008 , workes every time for me and 3 other i work with.
    Atleten
Page 1 of 1 (5 items)