Advanced reporting
and data visualization components for .NET
LIVE CHAT Welcome, guest

 





Has anyone really ever gotten this to work with SSRS 2005?
Display Posts for:
Invert
Susan Swanger 06/23/2010 13:19
Has anyone really ever gotten this to work with SSRS 2005?

I always get a Server error. I want to have Silverlight App on one web server and access SSRS reports on another server. Not sure if that is the issue. IIS App pool network service account user has right to SSRS so that should not be the issue. Also in documentation for trail it says to tell web service to use specific port local host 5555 ... the service is not going to be found there. I was told to put this line in the application to dynamically create the url for where the web service is located.
<param name="initParams" value='<%= string.Format("http://{0}{1}", Request.Url.Authority, ResolveUrl("~/ReportService.svc")) %>' />

Then set the Service URL of the viewer to initParms like this ReportViewer1.ServiceUrl = System.Windows.Browser.HtmlPage.Plugin.GetProperty("initParams").ToString();



But none of that worked and there is nothing in the logs to tell me the error. I find tech support slow to respond to questions and this whole application seems very frustrating.
Vitaliy Korney 07/06/2010 23:17
Has anyone really ever gotten this to work with SSRS 2005?

Hello,

In the Web.Config file you should configure settings Reporting Services connection,
smth. like this:
<PerpetuumSoftServices>
<Service Type="SampleApplication.Server.ReportService, SampleApplication.Server">
<MsReportingServer Url="http://<host.domain>/<reportserver>/ReportExecution2005.asmx">
<Credentials Domain="domain" UserName="login" Password="password"/>
</MsReportingServer>
</Service>
</PerpetuumSoftServices>

In the Silverlight application you should get parameters specified on the aspx-page:
public partial class MainPage : UserControl
{
public MainPage()
{
InitializeComponent();
Loaded += new RoutedEventHandler(Page_Loaded);
}

void Page_Loaded(object sender, RoutedEventArgs e)
{
reportViewer.ServiceUrl = HtmlPage.Plugin.GetProperty("initParams").ToString();
reportViewer.ApplyTemplate();
reportViewer.RenderDocument();
}
}

In the aspx-page write smth. like this:

<object data="data:application/x-silverlight-2," type="application/x-silverlight-2" width="100%" height="100%">
<param name="source" value="ClientBin/SampleApplication.xap"/>
<param name="onError" value="onSilverlightError" />
<param name="background" value="white" />
<param name="minRuntimeVersion" value="3.0.40624.0" />
<param name="autoUpgrade" value="true" />
<param name="initParams" value='<%= String.Format("http://{0}{1}", Request.Url.Authority, ResolveUrl("~/ReportService.svc")) %>' />
<a href="http://go.microsoft.com/fwlink/?LinkID=149156&v=3.0.40624.0" style="text-decoration:none">
<img src="http://go.microsoft.com/fwlink/?LinkId=108181" alt="Get Microsoft Silverlight" style="border-style:none"/>
</a>
</object>


Best regards,
Vitaly Korney
Perpetuum Software Team
Mahmoud Shaaban 05/02/2011 05:20
Has anyone really ever gotten this to work with SSRS 2005?

I'm facing the same issue.

A server error message appears.

I've tried your steps but it still not working.

Appreciate your kind help and support.
Sergey Kraynov 05/02/2011 22:52
Has anyone really ever gotten this to work with SSRS 2005?

Hello,

Please, have a look at this article: http://helpcenter.perpetuumsoft.com/KB/a357/an-error-occurred-on-the-server-what-should-i-do.aspx

Best regards,
Perpetuum Software Support Team