?
Solved

SQL Reporting Services in Visual Studio 2012

Posted on 2013-06-18
6
Medium Priority
?
1,456 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

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.   …
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 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…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

800 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