Solved

SQL Reporting Services in Visual Studio 2012

Posted on 2013-06-18
6
1,367 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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
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…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

743 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

13 Experts available now in Live!

Get 1:1 Help Now