I was creating RDL report in Visual studio.
In my report, I required the using of System.Net.WebClient and System.Web.Script.Serialization.JavaScriptSerializer references in the custom code so that i can deserialize JSON.
However I was getting the following error when previewing:
Any clues as of what happens?
*This post is locked for comments
Also, just FYI, here is what you can/can't do in CRM online when writing code for SSRS:
Hi try the following:
Create and an entity and create records in that entity using webservice and then generate report using Report Wizard of CRM on newly created entity
Mark answer as verified, if it works for you
Is there a workaround? As I want to access information from the webservice & populate in the report. Thanks.
This is a code-access security issue. If you have CRM OnPremise, you may be able to configure ReportingServices to allow it to use the System.Net.WebClient and System.Web.Script.Serialization.JavaScriptSerializer assemblies, but if you're using CRM Online, then you won't be able to use these assemblies in a report
This is my custom code:
Public Class GetMemberDetails
Public Block As String
End Class
Public Class MemberDetails
Public getResult As GetMemberDetails
End Class
Function GetMemberDetailsFromWebService(ByVal nricField As String) As String
Dim returnJson As String
Dim jsonUrl = String.Format("http://URLxxxxxxxxxx?",nricField )
Using webClient
Dim json = webClient.DownloadString(jsonUrl)
Dim result = javaScriptSerializer.Deserialize(Of MemberDetails)(json)
Dim resultAddress = String.Format("Block No.: {0}", result.getResult.Block)
If json = "" Then
returnJson = ""
Else
returnJson = resultAddress
End If
End Using
End Function
---
Where javaScriptSerializer & webClient are the Instance Name that I had set up in the "References"
Class Name: System.Net.WebClient Instance Name: webClient
Class Name: System.Web.Script.Serialization.JavaScriptSerializer Instance Name: javaScriptSerializer
The VB function was utilised in the expression in the Table cell:
=Code.GetMemberDetailsFromWebService(Fields!governmentid.Value)
And I got the error as shown in th screenshot.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (