Issues Setting RDLC Datasource to Object

问题:

Background:

I've been tasked with converting an Access database application to ASP.Net C# MVC. This is my first MVC application.

There are 10 reports that need converting. We're using RDLC files and reportviewer. I'm using Visual Studio 2010 with all the most recent patches. We're hooking up to a SQL Server database that's been populated by the existing Access database, so the table structure is pretty much set in stone, or else we'll have to try to convert 10 years of data.

I've completed all but two of the reports. The final reports require more processing, and don't just display data from the database. The easiest way to do this would be to create a C# object and do all the processing server-side, then use RDLC to display the results.

Issue

The problem I'm having is that Visual Studio won't recognize the objects I've created as potential datasources. Every time I try to "add dataset" it brings up the "datasource configuration wizard" and only offers the SQL Server database as the possible data connection. I know there's a screen that exists that allows you to select an object as your dataset, but I never see that screen.

Here are the objects (processing functions removed for clarity):

public class TurnAroundVal
{
    // Registration Package information
    public string dataType { get; set; }

    // Calculated totals; values only set through constructor or calculation function
    public int packageCount { get; private set; }
    public int dayCount { get; set; }
    public double avgTurnAround { get; private set; }
    public int upperRange { get; private set; }
    public int lowerRange { get; private set; }
}

public class TurnAroundVals
{
    // Public Variables
    public IEnumerable<TurnAroundVal> TurnArounds { get; private set; }
    public DatePass dates { get; set; }
    public int pkgTotal { get; private set; }
    public double dayTotal { get; private set; }
    public double avgAllTurnArounds { get; private set; }
}

I also would be willing to use the IEnumerable of "TurnAroundVal" as a datasource, and just pass the dates, int, and doubles in as parameters. Either would work.

Question

Is there a setting in Visual Studio 2010 that I'm missing to allow the RDLC Designer to see the objects I created? Am I wrong in even thinking this will work with the classes I defined?

Answer

All of the suggestions given were helpful, but ultimately what got it to work for me was to create a temporary non-web project in the same solution and create the RDLC there. When I went to add a dataset, it shows "Objects" as an option. You have to add a reference to your web project so that your objects are visible, but then you can pick the one you want and use that in the RDLC. After that, you can just drag-drop the RDLC file into your web project, delete the temp project, and you're good to go. Just remember that you have to add the datasources manually in code, and they have to be named the same as you specified in the RDLC.

回答1:

1. Make sure the classes are in the same namespace as the application.
2. Try building the application before you create the report
3. Start the report wizard. Under DataSouce select the name of your web application.
4. Under Available Datasets you should see what Visual Studio interprets to be your "Select Method". If all is well, this should be TurnArounds.

You may need to put the class file in the App_Data or App_Code folder, but I am not certain.

This might also help.

http://msdn.microsoft.com/en-us/library/ms251692%28v=vs.100%29.aspx

回答2:

Set your objects under the same namespace but on a different project which you then reference on your UI project.

Also try implementing INotifyPropertyChanged.

回答3:

Visual Studio does not recognize your class when you use only public members. When you use getter and setter instead, you can see your class when you choose your datasource.

There are some other wizards in Visual Studio that do not work with public members.

Cheers, Markus

回答4:

I've just come across this same issue when trying to create RDLC reports in an ASP.NET MVC project in Visual Studio 2017, so I'm adding this as a separate answer to make it clear this is still an issue at January 2018.

My solution consisted of a C# library project and an MVC client project.

Adding reports (by choosing at add a new item, then choosing a Report Wizard item) in the C# library project brings up the Report Wizard with the Data Source Configuration Wizard (where I can choose whether to use a Database, Service or an Object as the datasource) modally on top of it:

Whereas, choosing to add a new report wizard item in the MVC project just brought up the Report Wizard without the Data Source Configuration Wizard:

I tried adding business object classes into my MVC project, recompiling it and then adding a Report to the MVC Project again, but I still got the second screenshot, so it seems like you just don't get the Data Source Configuration Wizard when adding to MVC projects for some reason.