The Report Viewer still Remaining ....(for 11 months) RRS feed

  • Question

  • I'm using VS2005, C#, ASP.NET 2.0. I'm trying to create a report using SQL
    Reporting Services (to be used in local mode so I don't have to deal with
    SQL Server). When I create a new report in my website, nothing shows up in
    the Website Data Sources window. I added a few different strongly-typed
    Datasets to my website, and they don't show up. The only way I could get
    anything to show up was to create a new class that's derived from a
    strongly-typed Dataset I created in a separate assembly. Once I did that,
    this parent Dataset (from the external assembly) was listed as a Website
    Data Source (but not the derived class?). And, all of the sudden all of the
    strongly-typed Datasets I created in my website also showed up. The
    DataTables from the Dataset defined in my external assembly do not seem to
    import into the Website Data Sources properly either. All DataTables are
    listed once, with the exception of the first DataTable, which is listed
    again with the name of the DataSet prepended to the DataTable's name. If I
    delete the class (in my website) that I derived from the Dataset (in the
    external assembly), then all of the strongly-typed Datasets I defined in my
    Website project disappear from the Website Data Sources, as does the dataset
    defined in the external assembly. I must be missing something, or there's a
    bug of some sort.

    Here's what I want to be able to do: Build a report based on a Dataset that
    I've defined in a separate assembly from my website (i.e. my business logic
    layer). I will populate this Dataset manually without using any database.
    I don't think I should have to derive a class in my website (which I'll
    never actually use) from the dataset defined in my separate assembly, just
    to be able to use the Dataset defined in that separate assembly as a report
    data source for my website.


    and also .... Website Data Sources are disapearing. On one machine it works ok (the same machine that created the object data sources), but on other team member machines, the data sources are not to be seen. We get an error message "Unable to load assembly xxx.dll or one of it's dependancies". It may be related to the way the designer enumerates through the dependant assemblies?


    also sp1 did not fixed this error.


    Was this ever resolved, does anyone know? I'm having a lot of problems
    with a website built along the biggest banks in UK. One one
    machine, the website data sources tab only shows classes from the DAL,
    on my home PC, it doesn't show anything. The same thing happens with
    the Insurance firm site.

    Java people are making fun of us, the reporting tools production team should be able to fix this bug

    in visual studio.
    Tuesday, April 10, 2007 7:01 AM

All replies

  • I have the same issue today , also when I go Report/Datasources on an existing report I get a popup about the root element shoul be <schema>....
    Tuesday, June 16, 2009 8:09 PM