Solved

SQL Reporting Services in Visual Studio 2012

Posted on 2013-06-18
6
1,378 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

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…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
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…

895 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now