Local Reports in Asp.net Object Data Source
I've had a paid support incident in with MS for a week with no response. Case ID 111111679296066 Is it possible to use an Object Datasource with VS 2010 sp1 and the report designer. When you use the report wizard you don't get the option for using anything other than a db connection. This is for asp.net and MVC3 apps. With WPF apps you get all the choices. The walkthrough doesn't work with asp.net http://msdn.microsoft.com/en-us/library/ms251692%28VS.100%29.aspx In VS 2008 from the Data menu you could, select Show Data Sources. In 2010 asp.net this doesn't show up. In vs2010 the walkthrough says launch the Report Wizard. In the Dataset Properties page, in the Data source box, select global. Unfortunately their is no global to select.
November 22nd, 2011 3:39pm

Hi Chunk02323, Thanks for your post. According to your description, you would like to configure a Object Data Source for Local reports in VS2010. If so, please refer to the steps below: I assume you had created the local Report successfully. 1. Right-click your ASP.net project, select rebuild to build the business object (local report and data components) 2.Drag a ReportViewer control to the asp.net page. 3. Select the ReportViewer control, click the > icon of it in the right side. 4. Choose the local report in the Choose Report drop down list. 5. Click the Choose Data Sources link to open the Choose Data Sources window. 6. In the Data Source Instance column, click the relevant drop down list, select New Data Source to start the Data Source Configuration Wizard. 7. Select Object Data type, and rename the data source ID to the name you want, and then click ok to open the Configure Data Source wizard. 8. Choose the relevant business object from the drop down list according to the dataset you specified in your local report, then click Next. 9. Choose the relevant method you need, and then click Finish. Thanks, Bill LuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2011 11:46pm

I can't create the report successfully. I can create an emptyp report but I cannot choose a datasource. The DataSources pullout says their are no data sources to show for the selected project. The Data tab on the menu bar does not contain the Show Data Sources item.
November 28th, 2011 9:13am

I just had a similar thing (even though I had another project where it was working). Once I made sure my model had a constructor with no parameters and re-built, it started working (adding a datasource didn't automatically bring up the 'Connect to Sql' wizard)-Joseph
Free Windows Admin Tool Kit Click here and download it now
November 28th, 2011 5:25pm

I wanted to use the Entity Framework for a model, but I guess that is not possible. So I switched to the LinqToSql model which I had used in WPF projects sucessfully. When I look at the autogenerated LinqToSql code, I see: public ErDataContext() : base(global::System.Configuration.ConfigurationManager.ConnectionStrings["WITSConnectionString"].ConnectionString, mappingSource) { OnCreated(); } I wonder if that counts as a "constructor with no parameters"?
November 28th, 2011 6:04pm

Does your DataContext class have any methods that return your data? If you take a look at the zip file I've put in https://skydrive.live.com/redir.aspx?cid=ea13ec60838366e5&resid=EA13EC60838366E5!2439 that should give you an idea of what I saw (change the constructor to take a parameter and try generating a report) It's a little hackish, but I was actually working on a couple other report bugs I've seen and needed to get a quick set of test code out today so I threw it together in a rush and ran into the exact same thing until I made a more simple data model. -Joseph
Free Windows Admin Tool Kit Click here and download it now
November 28th, 2011 6:17pm

chunk02323, Thanks for your feedback, let’s move back to your second reply, the Datasource view would not be available in the local report design UI, but actually there is a way to see the datasource you created and create a new datasource. When you create a blank local report, you need to Add Dataset to your report, you can click the New icon in the Report Data panel, and select Dataset, the Dataset Properties window opens, you can either click the Data source drop down list to select a data source you have already created, or just click the New button next to the Data source drop down list to create new a SQL Server Data source. As for how to associate the Object data source to the relevant data source in your report throught ReportViewer control, you can refer to my previous post. Thanks, Bill LuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
November 29th, 2011 5:23am

Can't click the New icon in the Report Data panel it's grayed out. Are you familiar with a defect regarding the asp.net template (internal defect #20075071)
Free Windows Admin Tool Kit Click here and download it now
November 29th, 2011 5:46pm

Hi chuck02323, For this issue, I would suggest opening a case with Microsoft Customer Support Services (CSS) (http://support.microsoft.com), so that a dedicated Support Professional can assist you in a more efficient manner. Thanks, Bill Lu Bill Lu TechNet Community Support
December 6th, 2011 12:08pm

Thanks, I did( Case ID 111111679296066). I just didn't get a response after a week with the paid support, so I thought I try managed newsgroups.
Free Windows Admin Tool Kit Click here and download it now
December 6th, 2011 1:21pm

Hello Chuck02323, Did you try the workaround - "To get the Object datasource to work you have to add an ObjectDataSource to the Form before you try to link it to the report"? Regards, Swetha Microsoft Online Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
December 12th, 2011 3:34pm

Can't even get that far. Can't create the report, because you can't select an object datasource to use.
Free Windows Admin Tool Kit Click here and download it now
December 12th, 2011 4:27pm

Hi, Any breakthrough regarding this dropdown??? And my requirement is fetching mt HTML string on report. Any hint will be very much helpful. Thanks in advance. Regards, Pavan NRegards, Pavan N Kumar
April 5th, 2012 8:49am

Hi, Any breakthrough regarding this dropdown??? And my requirement is fetching mt HTML string on report. Any hint will be very much helpful. Thanks in advance. Regards, Pavan NRegards, Pavan N Kumar
Free Windows Admin Tool Kit Click here and download it now
April 5th, 2012 8:49am

MS paid support kind of gave up or at least stopped looking at it. The Visual Studio people and Sql Server people are on different teams and don't play nicely together. If you want to use local SQL reports in an MVC project with EF: Install Microsoft Report Viewer 2010 SP1 Redistributable Package Put all the reports in a separate project/dll Put all the datasources you are going to access in a different project. Use an aspx page for the reports This isn't for some foo foo convention reason. You need to have the datasources compiled for the reports to see them. You need the reports in a separate project so you can design them (can't in MVC). Sql reports are as buggy as ever and integration into VS is worse then ever.
April 5th, 2012 9:38am

MS paid support kind of gave up or at least stopped looking at it. The Visual Studio people and Sql Server people are on different teams and don't play nicely together. If you want to use local SQL reports in an MVC project with EF: Install Microsoft Report Viewer 2010 SP1 Redistributable Package Put all the reports in a separate project/dll Put all the datasources you are going to access in a different project. Use an aspx page for the reports This isn't for some foo foo convention reason. You need to have the datasources compiled for the reports to see them. You need the reports in a separate project so you can design them (can't in MVC). Sql reports are as buggy as ever and integration into VS is worse then ever.
Free Windows Admin Tool Kit Click here and download it now
April 5th, 2012 9:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics