3
Vote

The custom report item type RGraphicsDevice is not installed

description

Hello!

I have tried installing this on 3 different versions of Visual Studio (SSDT), i.e. 2010, 2012 and 2013.

SSDT VS2010 allows me to add R Graphics Device on the Toolbox. However, when I drag the component to the report canvas, it gives me an error "The custom report item type RGraphicsDevice is not installed".

SSDT VS2012 doesn't allow me to add R Graphics Device at all and gives me "There are no components in 'C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies\SSRS.CustomReportItems.Designer.dll' that can be placed on the toolbox."

SSDT VS2013 doesn't allow me to add R Graphics Device at all and gives me "There are no components in 'C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies\SSRS.CustomReportItems.Designer.dll' that can be placed on the toolbox."

In SSDT VS2013, if I add the assembly belonging to the VS2012 version, 'C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies\SSRS.CustomReportItems.Designer.dll', it seems to add the Report Item component. However, it still gives the same result as VS2010, i.e. "The custom report item type RGraphicsDevice is not installed".

Anyone experienced this? Does anyone have a solution to this?

Thank you!

Julie

file attachments

comments

JenUnderwood wrote Dec 29, 2014 at 8:17 PM

Thanks for sharing your errors. Most likely we need to improve the installation instructions. A few people have been able to install and get running. However, the process is not straight forward and actually a bit complex. I'll check with the developer after the holidays to see if we can get better step-by-step install instructions created. It looks like you have a partial install and one of the recompiled dlls did not get copied into the correct folder location(s).

crsundstrom wrote Dec 30, 2014 at 7:55 PM

Hi Julie,
I ran into the same issues as you but was able to get past the RGraphicsDevice is not installed error by first copying the SSRS.CustomReportItems.Designer.dll and the SSRS.CustomReportItems.dll to the C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies directory.

Next I modified the RSReportDesigner.config file and added the following elements just below the </Designer> ending tag and just above the </Extensions> ending tag:
</Designer>
<ReportItems>
<ReportItem Name="RGraphicsDevice" Type="SSRS.CustomReportItems.RGraphicsDeviceReportItem, SSRS.CustomReportItems"/>
</ReportItems>
<ReportItemDesigner>
<ReportItem Name="RGraphicsDevice" Type="SSRS.CustomReportItems.Designer.RGraphicsDeviceDesigner, SSRS.CustomReportItems.Designer"/>
</ReportItemDesigner>   
</Extensions>

Next I added the RGraphicsDevice component to the Toolbox by browsing to the SSRS.CustomReportItems.Designer.dll in the C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies directory. BTW, I'm using VS2010 (couldn't get it to work in any other version).

I am now able to add the RGraphicsDevice component to the report design surface and in the top left corner of the component is has the name "RGraphicsDevice1". Also, the Code and DPI properties are available in the Properties window.

However, I'm now getting the following warning "[rsCRIControlFailedToLoad] The ‘RGraphicsDevice’ extension failed to load the extension assembly. The custom reportitem ‘RGraphicsDevice1’ will render the AltReportItem or preserve the white space if no AltReportItem is explicitly defined.".

So, there must be an issue with the SSRS.CustomReportItems.dll. I noticed when I recompiled that project that the Assembly name property is set to Microsoft.Consulting.Ssrs.CustomReportItems. I'm not sure why it wasn't set to Ssrs.CustomReportItems. I'm still trying to get this working.

I hope this helps move your project a little further along.

Chris.

crsundstrom wrote Jan 5, 2015 at 5:28 PM

I deleted the SSRS.CustomReportItems.dll from the PrivateAssemblies directory and then copied the Microsoft.Consulting.Ssrs.CustomReportItems.dll into that directory. That eliminated the rsCRIControlFailedToLoad warning in VS.

Next I wanted to create a visualization using the RGraphicsDevice control. Normally in Reporting Services I create a Data Source and then use that data source to create a Dataset. I can insert a chart, table, or matrix control and then drag and drop fields from the dataset to the control to provide data to the control. There is a DataSetName property that gets assigned the name of the dataset providing the data.

When I try to drag and drop dataset fields to the RGraphicsDevice control my cursor changes to a not allowed symbol. Also there is no DataSetName property. How do I provide data to the RGraphicsDevice control?

Looking at the R code in Jen's screen shot there appears to be a property called data that is assigned a value of mtcars. Is mtcars the name of the dataset? I can't see the Report Data tab in the screen shot so I'm unable to determine if mtcars is a dataset. Or, is mtcars a file located on the server? If so, what is the file format? Where on the server is it located? How did it get there? BTW, I'm new to R and this is the first time I've installed and tried to use this tool.

I appreciate the time and effort expended to create this control and look forward to being able to use it to build advanced data visualizations.

Thanks,

Chris.

bjmac wrote Jan 13, 2015 at 3:09 AM

Hi Chris,

Try placing the following as the value for the Code property:
library(ggplot2);
plot<-qplot(wt, mpg, data=mtcars);
print(plot);
You may receive the following error if you do not have the ggplot2 package installed within R
An error occurred during local repot processing.
An error has occurred during processing of the CustomReportItem 'RGraphicsDeviceI with the 'RGraphicsDevice' extension.
An error has occurred during processing of the CustomReportItem 'RGraphicsDeviceI' with the 'RGraphicsDevice' extension.
RScript.exe returned With an unsuccessful return code. Console Output: Error in library(ggpIot2) : there IS no package called 'ggpIot2'Execution halted
I have been able to successfully preview an R plot within VS but I'm still struggling through configuring the Report Server side of things

crsundstrom wrote Jan 14, 2015 at 3:56 PM

Hi BJ,
I placed the code you supplied above in the Code property and then tried to preview the report but I received the following error:

[rsCRIControlFailedToLoad] The ‘RGraphicsDevice’ extension failed to load the extension assembly.

So, it looks like I still have some issues with the install on my workstation.

Thanks,

Chris.

dshriyan wrote Sep 8, 2015 at 4:28 PM

I am getting similar message as bjmac in his comment above. I am able to preview the report using ggplot2 in my visual studio solution but once I deploy the solution to report server I get the below message. Any ideas?

"An error has occurred during processing of the CustomReportItem 'RGraphicsDevice1' with the 'RGraphicsDevice' extension. (rsCRIProcessingError)
RScript.exe returned with an unsuccessful return code. Console Output: Error in library(ggplot2) : there is no package called 'ggplot2' Execution halted"

JasminSayyad wrote Apr 29, 2016 at 1:58 PM

Hello,

As per some reference available and Solution provided by Chris, I have deleted SSRS.CustomReportItems.dll from the PrivateAssemblies directory and then copied the Microsoft.Consulting.Ssrs.CustomReportItems.dll into that directory, It is not eliminated the rsCRIControlFailedToLoad warning in VS. Is is still showing me same issue.

Finally, I have added both the dll SSRS.CustomReportItems.dll and Microsoft.Consulting.Ssrs.CustomReportItems.dll together but it still now resolved.

Is there any other way to resolve this issue?
Do we need to change .config setting also as per the Microsoft.Consulting.Ssrs.CustomReportItems.dll name change?
Anyone facing this same issue? Does anyone having solution on this?

Thank you Chris for the posted solutions. It helped me a lot to resolved my other configuration issues.

pinedagp wrote May 17, 2016 at 2:33 PM

Got it working with BIDS 2010! It looks really nice.

In the SSRS,CustomReportItems properties Application, I renamed the [Assembly name] to "Ssrs.CustomReportItems" and renamed [Default namespace] to "Ssrs.CustomReportItems".

Now, my problem is with getting it work on SSRS. It appears SSRS does not like the URL value in rssrvpolicy.config. I have to play with this more.

One other question: How do I pass a parameter to the device?

MTSpider wrote Aug 9 at 8:17 AM

Hi,
I am also facing same issue where the control is not getting added to ToolBox. Is there any change required in SSRS.CustomReportItems.Designer.dll or SSRS.CustomReportItems.dll

I followed the above step as well but still same issue. Screenshot attached.

Please help if anyone have fixed it and would appreciate if someone can iterate the steps end to end who you have done.

thanks.