Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL Reporting Services in Visual Studio 2012

Posted on 2013-06-18
6
Medium Priority
?
1,495 Views
Last Modified: 2013-06-25
Hi,
I have been using the Business Intelligence templates in VS2012 to create a report project, based on SQL Server 2008R2.  This was working fine, but now will not allow the project to build at all (it has been checked into TFS for some time, as has not changed at all since the last time it worked).  The error is "Error: Value cannot be null".  Which is obviously spectacularly unhelpful.  I tried removing the reports one by one, but it still happened when all had gone.  I then created a new report project, created a new report, with a textbox (no data sources or datasets set up).  Same error.  It is obviously not related to the project itsefl therefore.

The only thing I can think of that's changed is I recently installed Xamarin Indie edition, which has a lot of integration with VS2012.  I tried removing all but one of the extensions relating to this (I can't tell which the final one is in the add/remove programs, and I don't want to break the Xamarin product itself).

Could this install have broken VS2012?  Or has there been a Microsoft update that might have done it?  If anyone has any ideas, or has seen something similar, all suggestions are welcome!

Full output of build (new project, with no actual content at all):

------ Build started: Project: TestReporting, Configuration: Debug ------
Error: Value cannot be null.
========== Build: 0 succeeded or up-to-date, 1 failed, 0 skipped ==========

Thanks
0
Comment
Question by:itfocus
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39258461
So the error occurs when you build the project, all other functionality is working as expected?  Just wondering, why would you Build a Reporting Services project? (there's no code that needs to get turned into a binary)
0
 

Author Comment

by:itfocus
ID: 39262497
It happens when you build prior to a deployment.  There is no getting around the build process - it does it automatically when you choose to deploy.

All other functionality seems to be ok - you can create reports, add datasources and data sets, save them.... just when you come to build/deploy, this error comes up.

Thanks
0
 

Author Comment

by:itfocus
ID: 39262508
Previews actually don't work either; says "The report preview failed because the report could not be built. Read the errors, warnings, and messages in the Error List window for specific build failures".

All the error window says is "Error: Value cannot be null"
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Accepted Solution

by:
itfocus earned 0 total points
ID: 39262628
I have just spent some more time playing with this, and I discovered another Visual Studio add-on I didn't realise was there - an evaluation version of Spices.  I uninstalled this, as I don't need it.  Opened the report project again, and it is now working.

Could be a coincidence (unlikely, but I suppose possible), but thought I'd put it here just in case it ever helps anyone else.
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39265477
"It happens when you build prior to a deployment.  There is no getting around the build process - it does it automatically when you choose to deploy."

Ow right, true enough!

Glad to hear you got it resolved :)
0
 

Author Closing Comment

by:itfocus
ID: 39274156
Resolved issue
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What my article will show is if you ever had to do processing to a listbox without being able to just select all the items in it. My software Visual Studio 2008 crystal report v11 My issue was I wanted to add crystal report to a form and show…
For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question