1 answer

92 views

Hi all

I want to know is how to Xaml send data from the Report.

I wish I was hoping you could help us thank you.

^^;

..

Test.Xaml

args.ParameterValues.Add("Test", "2012010001");

Report.CS

string St_Query_Parameter_Data = this.ReportParameters["Test"].Value.ToString();

Mssql Query : Select * from Test_Data Where NO_CODE = St_Query_Parameter_Data !! Error
St_Query_Parameter_Data <== Null Data

General Discussions

answered on 12 Jun 2012

1 answer

69 views

Telerik Reporting use in silverlight client

Telerik Reporting use in silverlight client...

Telerik Reporting use in silverlight???

Data set in Silverlight client , how to use "Telerik Reporting" showing the report data ?

Data in a database has been sent to the silverlight client.

Official website there is no such Demo??? I can't find it...

General Discussions

answered on 12 Jun 2012

1 answer

60 views

Group Footer Section does not work group wise

Hi,
I am working telerik reporting showing class detail. I have grouped it by ClassID. It has the "Time" field which I have to sum in the "GroupFooterSection", for this purpose I have sum the time in Fill() method of report and assigned the value to the textbox in GroupFooterScetion. But it is showing the same value for each group, and also it is giving me the sum of all classes instead of showing group wise result.

Regards,
Sonia Shahid

General Discussions

answered on 12 Jun 2012

1 answer

109 views

Empty Subreport

I created in my master-report this eventheandler, but error tell me (Processing.SubReport subReport = (Processing.SubReport)"sender;) dont' cast Processing.SubReport with Processing.Report.

I want view textbox13 when subreport = 0

public masterReport(string x)

{

InitializeComponent();

try

{

sqlDataSource1.SelectCommand =

".......";

this.sys2.ItemDataBound += new EventHandler(sys2_ItemDataBound);

}

catch (Exception)

{

throw;

}

void sys2_ItemDataBound(object sender, EventArgs e)

{

Telerik.Reporting.Processing.

SubReport subReport = (Telerik.Reporting.Processing.SubReport)sender;

Telerik.Reporting.Processing.

Report report = (Telerik.Reporting.Processing.Report)subReport.InnerReport;

if (report.ChildElements.Find("trasmissione", true).Length > 0)

{

subReport.Visible =

true;

}

else

{

textBox13.Visible =

true;

}

}

Please, help me. Thank you

General Discussions

answered on 12 Jun 2012

3 answers

300 views

Manipulate ReportParameters after Report Construction

We are building dynamic reports with various parameters. There is one parameter (X) where each value basically defines what type of parameter should be used next. I figured that the most obvious moment to add or modify parameters is on the NeedDataSource since there aren't that many other hooks. I tried to trick this by writing a class which is called by an ObjectDataSource and only modifies the Report by calling a function that add parameters. This ObjectDataSource is bound to a hidden ReporParameter and has a DataSourceParameter that uses the selection from the first parameter. So once I select a value the method is called that manipulates the ReportParameters (adding, removing, hiding). Unfortunately, any parameter I manipulate or add once the Report is constructed isn't displayed.

The Refresh button on the WebForms ReportViewer however makes later added parameters visible. Is there any way I can trigger the same functionality of the Refresh button programatically?

Right now I have to resort to moving parameters in a custom section on the webpage to get this done. Which I rather not do because it simply looks more inconsistent.

General Discussions

answered on 11 Jun 2012

1 answer

153 views

Issue with https and charts

Hello,

I am currently working on a Silverlight Business Application working entirely over Https. The project is hosted on Azure. I am using Q1 2011 tools and Siverlight 5.

I followed carefully the documentation and copy/pasted the web.config part as in : http://www.telerik.com/help/reporting/silverlight-enable-ssl-for-telerik-reporting-wcf-service.html
I also enabled the Session caching for Azure and it is working fine. Now the problem is that as soon as i put a chart on my report, i am getting an error code 500. The detail is as follow :

Server Error in '/' Application.

Unable to cast object of type 'System.Text.CodePageEncoding' to type 'System.Text.Encoding'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidCastException: Unable to cast object of type 'System.Text.CodePageEncoding' to type 'System.Text.Encoding'.

Source Error:

An unhandled exception was generated during the execution of the
            current web request. Information regarding the origin and location of the
            exception can be identified using the exception stack trace below.

Stack Trace:


            [InvalidCastException: Unable to cast object of type 'System.Text.CodePageEncoding' to type 'System.Text.Encoding'.]
   ReadInternalEncoderBestFitFallbackFromXml(XmlReaderDelegator , XmlObjectSerializerReadContext , XmlDictionaryString[] , XmlDictionaryString[] ) +648
   System.Runtime.Serialization.ClassDataContract.ReadXmlValue(XmlReaderDelegator xmlReader, XmlObjectSerializerReadContext context) +106
   System.Runtime.Serialization.XmlObjectSerializerReadContextComplex.InternalDeserializeInSharedTypeMode(XmlReaderDelegator xmlReader, Int32 declaredTypeID, Type declaredType, String name, String ns) +558
   System.Runtime.Serialization.XmlObjectSerializerReadContextComplex.InternalDeserialize(XmlReaderDelegator xmlReader, Type declaredType, String name, String ns) +109
   System.Runtime.Serialization.XmlObjectSerializerReadContext.ReadSerializationInfo(XmlReaderDelegator xmlReader, Type type) +357
   ReadCodePageEncodingFromXml(XmlReaderDelegator , XmlObjectSerializerReadContext , XmlDictionaryString[] , XmlDictionaryString[] ) +144
   System.Runtime.Serialization.ClassDataContract.ReadXmlValue(XmlReaderDelegator xmlReader, XmlObjectSerializerReadContext context) +106
   System.Runtime.Serialization.XmlObjectSerializerReadContextComplex.InternalDeserializeInSharedTypeMode(XmlReaderDelegator xmlReader, Int32 declaredTypeID, Type declaredType, String name, String ns) +558
   ReadRenderingStreamFromXml(XmlReaderDelegator , XmlObjectSerializerReadContext , XmlDictionaryString[] , XmlDictionaryString[] ) +1631
   System.Runtime.Serialization.ClassDataContract.ReadXmlValue(XmlReaderDelegator xmlReader, XmlObjectSerializerReadContext context) +106
   System.Runtime.Serialization.XmlObjectSerializerReadContextComplex.InternalDeserializeInSharedTypeMode(XmlReaderDelegator xmlReader, Int32 declaredTypeID, Type declaredType, String name, String ns) +558
   ReadArrayOfRenderingStreamFromXml(XmlReaderDelegator , XmlObjectSerializerReadContext , XmlDictionaryString , XmlDictionaryString , CollectionDataContract ) +623
   System.Runtime.Serialization.CollectionDataContract.ReadXmlValue(XmlReaderDelegator xmlReader, XmlObjectSerializerReadContext context) +161
   System.Runtime.Serialization.XmlObjectSerializerReadContextComplex.InternalDeserializeInSharedTypeMode(XmlReaderDelegator xmlReader, Int32 declaredTypeID, Type declaredType, String name, String ns) +558
   ReadArrayOfRenderingStreamFromXml(XmlReaderDelegator , XmlObjectSerializerReadContext , XmlDictionaryString[] , XmlDictionaryString[] ) +358
   System.Runtime.Serialization.ClassDataContract.ReadXmlValue(XmlReaderDelegator xmlReader, XmlObjectSerializerReadContext context) +106
   System.Runtime.Serialization.XmlObjectSerializerReadContextComplex.InternalDeserializeInSharedTypeMode(XmlReaderDelegator xmlReader, Int32 declaredTypeID, Type declaredType, String name, String ns) +558
   ReadReportServiceHistoryFromXml(XmlReaderDelegator , XmlObjectSerializerReadContext , XmlDictionaryString[] , XmlDictionaryString[] ) +820
   System.Runtime.Serialization.ClassDataContract.ReadXmlValue(XmlReaderDelegator xmlReader, XmlObjectSerializerReadContext context) +106
   System.Runtime.Serialization.XmlObjectSerializerReadContextComplex.InternalDeserializeInSharedTypeMode(XmlReaderDelegator xmlReader, Int32 declaredTypeID, Type declaredType, String name, String ns) +558
   ReadArrayOfanyTypeFromXml(XmlReaderDelegator , XmlObjectSerializerReadContext , XmlDictionaryString , XmlDictionaryString , CollectionDataContract ) +575
   System.Runtime.Serialization.CollectionDataContract.ReadXmlValue(XmlReaderDelegator xmlReader, XmlObjectSerializerReadContext context) +161
   System.Runtime.Serialization.XmlObjectSerializerReadContextComplex.InternalDeserializeInSharedTypeMode(XmlReaderDelegator xmlReader, Int32 declaredTypeID, Type declaredType, String name, String ns) +558
   ReadSerializableSessionStateStoreDataFromXml(XmlReaderDelegator , XmlObjectSerializerReadContext , XmlDictionaryString[] , XmlDictionaryString[] ) +764
   System.Runtime.Serialization.ClassDataContract.ReadXmlValue(XmlReaderDelegator xmlReader, XmlObjectSerializerReadContext context) +106
   System.Runtime.Serialization.XmlObjectSerializerReadContextComplex.InternalDeserializeInSharedTypeMode(XmlReaderDelegator xmlReader, Int32 declaredTypeID, Type declaredType, String name, String ns) +558
   System.Runtime.Serialization.XmlObjectSerializerReadContextComplex.InternalDeserialize(XmlReaderDelegator xmlReader, Type declaredType, String name, String ns) +109
   System.Runtime.Serialization.NetDataContractSerializer.InternalReadObject(XmlReaderDelegator xmlReader, Boolean verifyObjectName) +170
   System.Runtime.Serialization.XmlObjectSerializer.ReadObjectHandleExceptions(XmlReaderDelegator reader, Boolean verifyObjectName, DataContractResolver dataContractResolver) +647
   System.Runtime.Serialization.XmlObjectSerializer.ReadObject(XmlDictionaryReader reader) +128
   Microsoft.ApplicationServer.Caching.Utility.Deserialize(Byte[][] buffers, Boolean checkTypeToLoad, Object context, IEnumerable`1 knownTypes) +684
   Microsoft.ApplicationServer.Caching.SimpleSendReceiveModule.SendMsgAndWait(EndpointID endpt, RequestBody reqMsg, TimeSpan requestTimeout, IRequestTracker& tracker) +1615
   Microsoft.ApplicationServer.Caching.HybridClient.SendMsgAndWait(RequestBody reqMsg, IRequestTracker& tracker) +188
   Microsoft.ApplicationServer.Caching.DataCache.SendReceive(RequestBody reqMsg, IMonitoringListener listener) +254
   Microsoft.ApplicationServer.Caching.DataCache.ExecuteAPI(RequestBody reqMsg, IMonitoringListener listener) +10
   Microsoft.ApplicationServer.Caching.DataCache.InternalGetAndLock(String key, TimeSpan timeout, DataCacheLockHandle& lockHandle, String region, Boolean lockKey, IMonitoringListener listener) +227
   Microsoft.ApplicationServer.Caching.<>c__DisplayClass78.<GetAndLock>b__77() +103
   Microsoft.ApplicationServer.Caching.DataCache.GetAndLock(String key, TimeSpan timeout, DataCacheLockHandle& lockHandle) +258
   Microsoft.Web.DistributedCache.<>c__DisplayClass31`1.<PerformCacheOperation>b__30() +19
   Microsoft.Web.DistributedCache.DataCacheRetryWrapper.PerformCacheOperation(Action action) +66
   Microsoft.Web.DistributedCache.DataCacheForwarderBase.GetAndLock(String key, TimeSpan timeout, DataCacheLockHandle& lockHandle) +190
   Microsoft.Web.DistributedCache.BlobBasedSessionStoreProvider.GetItem(HttpContextBase context, String id, Boolean acquireWriteLock, Boolean& locked, TimeSpan& lockAge, Object& lockId, SessionStateActions& actions) +211
   Microsoft.Web.DistributedCache.DistributedCacheSessionStateStoreProvider.GetItemExclusive(HttpContext context, String id, Boolean& locked, TimeSpan& lockAge, Object& lockId, SessionStateActions& actions) +125
   System.Web.SessionState.SessionStateModule.GetSessionStateItem() +178
   System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData) +1076
   System.Web.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +115
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +375

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

I checked the Output window in visual studio and nothing looked wrong. The report is built but nothing is appearing in the Silverlight page.
I also tried to host the report on an asp.net webpage, and put that webpage in a RadHtmlHolder within my silverlight application. The chart were working fine when i was calling the page over http, but not over https(tables were displayed but chart were not there).

Let me know if I need to give you more information, i am stuck for a week on this problem...

UPDATE : Looks like I cannot answer the thread, I am getting an error.

->
Thank you for your answer Steve,

The Out-proc session was already set up and the reports were appearing fine, it is only when i added a chart that it stopped working.
The endpoints were also present. What i ended up doing is hosting it on a local IIS and add http and https endpoint, i also removed Out-proc session and everything worked perfectly.

Our final solution was to use an Amazon EC2 instance, we moved all our databases and website from Azure to there. Since then the system is 6 times quicker on average and most of the workarounds necessary for Azure are not needed anymore.

Anyway thank you for your support and keep up the good work :)

General Discussions

answered on 11 Jun 2012

2 answers

72 views

Telerik Report Library Shows only 1st report & how to increase the width of report Parameter Drop Down Box.

Hi All,

I am using Telerik Reporting Q1 2012 for Web. I am new to Telerik Reporting.

1) Using this below tutorial:

http://www.telerik.com/help/reporting/designing-reports-reportbook-web-viewer.html

I just created 2 Reports (ClinicMasterIntakes and ClinicMasterReferrals), added them to Report Library in .aspx page but when I view that page in browser, I only see 1st report(ClinicMasterIntakes). What mechanism I need to use to see both report names appear side by side like Radgrid Link Buttons. Please give me (new user) a simple solution.

Below is my code.

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ClinicReports.aspx.cs" Inherits="BHS_WebReports.ClinicReports" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

<%@ Register assembly="Telerik.ReportViewer.WebForms, Version=6.0.12.215, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" namespace="Telerik.ReportViewer.WebForms" tagprefix="telerik" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

<title>BHS Clinical Reports</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">

</telerik:RadScriptManager>

<telerik:ReportViewer ID="ReportViewer1" runat="server" Height="1000px" Width = "900px"

ReportBookID="ReportBookControl1">

</telerik:ReportViewer>

<telerik:ReportBookControl ID="ReportBookControl1" runat="server">

<Reports>

<telerik:ReportInfo Report=

"BHS_Clinic_Activity_Reports.ClinicMasterIntakes, BHS_Clinic_Activity_Reports, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"

/>

<telerik:ReportInfo Report=

"BHS_Clinic_Activity_Reports.ClinicMasterReferrals, BHS_Clinic_Activity_Reports, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"

>

</telerik:ReportInfo>

</Reports>

</telerik:ReportBookControl>

</div>

</form>

</body>

</html>

2) How do I increase the width of Drop down list in report viewer? Please refer to below screen shot. In the subcategory dropdown list,

Blue circled is actual width. How do I increase the width to Red Circled?

Thanks for your help.

gc_0620

General Discussions

answered on 11 Jun 2012

1 answer

61 views

Upgrading Telerik reports Q3 2009 to the latest version

I have a lot of reports developed using Q3 2009 version of telerik reporting. Before developing new reports, we want to ensure that the existing reports work as they used to after upgrading to latest version of telerik reporting. But all the reports which use subreport fail compilation with the error: 'DataItem' is not a member of 'Telerik.Reporting.Processing.SubReport'.

All the reports use objectdatasource.

Private Sub SubReport1_NeedDataSource(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SubReport1.NeedDataSource

Dim subReport As Telerik.Reporting.Processing.SubReport = DirectCast(sender, Telerik.Reporting.Processing.SubReport)

subReport.InnerReport.DataSource =

DirectCast(subReport.DataItem, System.Data.DataRowView)("subreportList")

End Sub

Please suggest what needs to be done here so that I can quickly fix these existing reports and then move to development of new reports

Thanks in advance

General Discussions

answered on 11 Jun 2012

2 answers

95 views

OpenAccessDataSource

Hi,
Any chance you could provide a VS example (WPF) of a Chart using OpenAccessDataSource?

My solution contains two separate projects (Model for OpenAccess, and Reports which includes a Model reference). I have created a Report and successfully used a SqlDataSource, however, changing it to OpenAccessDataSource I get an empty series in the Chart. I have just used the configure wizard so that the Object Context is selected from {}Model and the Object Context Member selected is the IQueryable View. The SQL View I created and added to Model contains the same SQL statement used in the SqlDataSource connection.

Thanks. Al.

General Discussions

answered on 08 Jun 2012

1 answer

77 views

Silverlight report blank until refresh

I have a report viewer in a silverlight control, and when it loads it comes up blank until I hit refresh on the viewer, and then the report is finally loaded. What could be happening? Here's the code I'm using:

public ReportWrapper()

{

InitializeComponent();

this.rptViewer.RenderBegin += new Telerik.ReportViewer.Silverlight.RenderBeginEventHandler(rptViewer_RenderBegin);

this.Loaded += ReportWrapper_Loaded;

this.rptViewer.ReportServiceUri = new Uri("http://webserver/reportserver/reportservice.svc");

this.rptViewer.Report = "ReportLib.TestReport";

}

void rptViewer_RenderBegin(object sender, Telerik.ReportViewer.Silverlight.RenderBeginEventArgs args)

{

args.ParameterValues["ID"] = ID;

}