Solved

SQL Reporting Services in Visual Studio 2012

Posted on 2013-06-18
6
1,397 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
  • 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
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 

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 Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

856 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