Questions on Reporting Forum

1 answer

394 views

Missing Icons

I upgraded to reporting version 6.1.12.611 from 5.3.11.1124, everything works well in development... when deployed to WIN 7 & IIS7 PC
report look like (see attached)...it did work ok on previous version.... All dll's in bin file are correct and web config has been updated with new version.
Web itself seems to work ok.......... version is 2012.2.607.40...

More info... I get a ToolBarImageButton is undefined
Any ideas on this... thanks

General Discussions

answered on 12 Jul 2012

1 answer

91 views

Change y-axis point labels format

Hi,

I am working on Telerik Reporting, i have created the report using CrossTab control. I am showing the report in report viewer. I am using Reporting Q2 2011 version is 5.1.11.928. I have created the report using crosstab wizard and need chart for that report so i have used rad chart for that report. In report i am displaying the values in current format like that i need to display the point labels in currency format. Please refer the attachment. Please help me and let me know any other solution to achieve this problem.

Thanks,
Nisha

General Discussions

answered on 12 Jul 2012

2 answers

90 views

Telerik Charts

Hi,

I am working on Telerik Reporting, i have created the report using CrossTab control. I am showing the report in report viewer. I am using Reporting Q2 2011 version is 5.1.11.928. I have created the report using crosstab wizard and need chart for that report so i have used rad chart for that report. While using the stacked bar chart type the point labels not displaying properly. I need to display the point labels inside the column not outside of stacked columns. Please refer the attachment. Please help me and let me know any other solution to achieve this problem.

Thanks,
Nisha

General Discussions

answered on 12 Jul 2012

1 answer

174 views

FilterOperator.TopN problem

Hi

I want to use FilterOperator.TopN.
Datas come from a dataSet. The filtered column type is Int32
I have this error: "value of top/bootom filter should evaluate to Integer"

Filter filter1 = new Filter();

filter1.Expression = "=Fields.DAYNUMBER";

filter1.Operator = FilterOperator.TopN;

filter1.Value = "1";

this.table2.RowGroups[0].ChildGroups[1].Filters.Add(filter1);

General Discussions

answered on 12 Jul 2012

0 answers

466 views

Changing Datasource for Report at Runtime

I could not find an answer to this so opened a ticket and got a quick response, which I though I would post here for others...perhaps I am kind of dense, but the breaking changes in the new release confused the heck out of me...

Hi - I just updated to 6.1.12.611 reports release and all my reports broke. I cannot figure out how to change the following code in my report viewer in my web application to work with new release. There are no VB examples that I can find.
I want to simply change the datasource property of the report at runtime. I have a custom class in my web application that provides a datatable just by passing the sql. I could then set the newly created table as the datasource at runtime.
This used to work:
Dim report1 As New myReports.ProjectList
Dim tbl As DataTable = db.ExecuteDataTable("SELECT * FROM mydata WHERE ProgramID = " & nProgramID)
report1.DataSource = tbl
ReportViewer1.Report = report1

I am lost --
I got this far but cannot find a datasource property to set anywhere....:
Dim report1 As New Telerik.Reporting.InstanceReportSource
report1.ReportDocument = New myReports.ProjectList
ReportViewer1.ReportSource = report1

Please help.
Thanks
Ford

----------------------------------- Answer -----
Hello Ford,

The Report Sources are not report documents, they are the connection between multiple report documents or report documents and viewers, so I guess naming your InstanceReportSource with report1 is where the confusion comes from.

Copy code

Dim report1 As New myReports.ProjectList

Dim tbl As DataTable = db.ExecuteDataTable("SELECT * FROM mydata WHERE ProgramID = " & nProgramID)

report1.DataSource = tbl

ReportViewer1.Report = report1

should be:

Copy code

Dim report1 As New myReports.ProjectList

Dim tbl As DataTable = db.ExecuteDataTable("SELECT * FROM mydata WHERE ProgramID = " & nProgramID)

report1.DataSource = tbl

Dim instanceReportSource As New Telerik.Reporting.InstanceReportSource()

instanceReportSource.ReportDocument = report1

ReportViewer1.ReportSource = instanceReportSource

Kind regards,
Steve
the Telerik team

General Discussions

asked on 11 Jul 2012

1 answer

85 views

Adding reports to ReportBook in Code-Behind

Hi,

I have successfully added a class with all my reports to my current project. However I do have a screen where the user can select which reports he/she want to print in a reportbook and save it into a pdf, and mail it to the user.

Currently the routine is as follows:
Select Case ReportSelected
    Case 1
          reportBook.Reports.Add(New Report1())
    Case 2
          reportBook.Reports.Add(New Report2())
    Case ....
End Select

This goes up to 40 at this stage.

What I want to know is if it is possible to this data in a database table and put the system through a loop to retrieve the report name from the database and add it to the reportbook?

Something like this :
While dbReader.Read()
     reportBook.Reports.Add(New dbReader("ReportName"))
End While

General Discussions

answered on 11 Jul 2012

2 answers

296 views

Report Viewer Not Refreshing on Form Load?

Hi

I’m new the Telerik Reporting and I’m having an issue with the report viewer in my windows form project that I’m a bit stumped on.

When I run the form I need to hit the refresh button or the viewer is blank.

I followed this quick start guide…

http://www.telerik.com/help/reporting/quick-start-windows-viewer.html

… and as far as I’m aware I have not missed anything.

To me it seems like the RefreshReport method is not being called but I’m not sure.

I went through the motions for two separate projects and ran into the same problem.

I realize that this is not much to go on but I don’t know what else I can say.

General Discussions

answered on 11 Jul 2012

2 answers

149 views

Silverlight ReportViewer InnerException[self-Host WcfService]

1、Create Self-Host Report WcfService
------------------------------------------------------------------------------------------------
WCFService Library Application：WCF Service Library Project
------------------------------------------------------------------------------------------------
ReportLibrary.ReportService.cs

namespace ReportLibrary

{

[System.Runtime.Serialization.KnownType(typeof(object[]))]

public class ReportService : Telerik.Reporting.Service.ReportServiceBase

{

private static readonly Uri baseUri = new Uri("http://localhost:9009/Telerik/ReportService/");

protected override Uri BaseAddress

{

get { return baseUri; }

}

app.config

<service name="ReportLibrary.ReportService" behaviorConfiguration="serviceBehavior">

<host>

<baseAddresses>

<add baseAddress="http://localhost:9002/Telerik/ReportService/"/>

</baseAddresses>

</host>

<endpoint address=""

binding="customBinding" bindingConfiguration="WcfServiceCustomBinding0"

contract="Telerik.Reporting.Service.IReportService">

<identity>

<dns value="localhost" />

</identity>

</endpoint>

<endpoint address="ResourceService"

binding="webHttpBinding"

behaviorConfiguration="WebBehavior"

contract="Telerik.Reporting.Service.IResourceService"/>

<endpoint address="ClientAccessPolicy"

binding="webHttpBinding" behaviorConfiguration="WebBehavior"

contract="Telerik.Reporting.Service.IClientAccessPolicy"/>

<endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange" />

</service>

Build Success And Output：
ReportLibrary\bin\Debug\ReportLibrary.dll
ReportLibrary\bin\Debug\Telerik.Reporting.Service.dll

------------------------------------------------------------------------------------------
WcfHost Console Application：WCF Self-Host Console Project
------------------------------------------------------------------------------------------
WcfHost.Program.cs

namespace WcfHost

{

public class Program

{

public static void Main(string[] args)

{

ServiceHost hostA = null;

ServiceHost hostDomain = null;

try

{

hostA = new ServiceHost(typeof(ReportLibrary.ReportService));

hostDomain = new ServiceHost(typeof(DomainService));

hostA.Open();hostDomain.Open();

Console.WriteLine("Report Services is starting...");

Console.WriteLine("CrossDomain Service is starting...");

Console.WriteLine();

Console.WriteLine("Press <ENTER> to terminate host");

Console.ReadLine();

hostA.Close();

hostDomain.Close();

}

catch (Exception ex)

{

Console.WriteLine(ex.Message);

Console.ReadLine();

}

finally

{

hostA.Close();

}

app.config

<service behaviorConfiguration="serviceBehavior" name="ReportLibrary.ReportService">

<host>

<baseAddresses>

<add baseAddress="http://localhost:9002/Telerik/ReportService/" />

</baseAddresses>

</host>

<endpoint address="" binding="customBinding" bindingConfiguration="WcfServiceCustomBinding0"

contract="Telerik.Reporting.Service.IReportService">

<identity>

<dns value="localhost" />

</identity>

</endpoint>

<endpoint address="ResourceService"

binding="webHttpBinding"

behaviorConfiguration="WebBehavior"

contract="Telerik.Reporting.Service.IResourceService"/>

<endpoint address="ClientAccessPolicy"

binding="webHttpBinding" behaviorConfiguration="WebBehavior"

contract="Telerik.Reporting.Service.IClientAccessPolicy"/>

<endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange" />

</service>

Build Success And Output：
WcfHost\bin\Debug\ReportLibrary.dll
WcfHost\bin\Debug\Telerik.Reporting.Service.dll
WcfHost\bin\Debug\WcfHost.exe

Run WcfHost.exe Carrying ReportLibrary.ReportService Wcf Service；
service endpoint Address = "http://localhost:9002/Telerik/ReportService/"; by normal browser access wcf service

2、Create Wcf Client

------------------------------------------------------------------------------------------------------
ReportSLApp Silverlight Application：Wcf Silverlight Client Project

Add Reference：Reporting Q1 2011\bin\Telerik.ReportViewer.Silverlight.dll；
------------------------------------------------------------------------------------------------------
ServiceReferences.ClientConfig

<endpoint address="http://localhost:9002/Telerik/ReportService/"

binding="customBinding" bindingConfiguration="CustomBinding_IReportService"

contract="ReportServiceRef1.IReportService" name="CustomBinding_IReportService" />

ReportSLApp.MainPage.xaml.cs

private void UserControl_Loaded(object sender, RoutedEventArgs e)

{

ServiceClient = new ReportServiceRef1.ReportServiceClient("CustomBinding_IReportService");

ServiceClient.ListAvailableReportsCompleted += new

EventHandler<ReportServiceRef1.ListAvailableReportsCompletedEventArgs>(ServiceClient_ListAvailableReportsCompleted);

ServiceClient.ListAvailableReportsAsync();

this.rptViewer1.ReportServiceUri = ServiceClient.Endpoint.Address.Uri;

}

private void ServiceClient_ListAvailableReportsCompleted(object

sender,

ReportServiceRef1.ListAvailableReportsCompletedEventArgs e)

{

if (e.Error == null)

{

MyReports = e.Result;

this.rptViewer1.Report = MyReports[0].FullName;

}

Build Success And Browse Silverlight HostPage：

ReportSLAppTestPage.aspx error occurred operating results; Silverlight ReportViewer InnerException

I urgently need help, wait ...

General Discussions

answered on 11 Jul 2012

2 answers

112 views

Loading Page... never completes

I am a new user of the Telerik Reporting components, so please bear with me. I have successfully created a self hosted WCF reporting service (derived from ReportServiceBase), created a report and added the ReportViewer to a Silverlight 4 application. The calls from the client to the server have been successful as well. The problem is when the ReportViewer goes to display the first page, the status message "Loading Page..." never goes away! I used Fiddler to determine that the GetPage call is returning with data, but the viewer never displays the result.

What am I doing wrong?

Mike Underhill

General Discussions

answered on 11 Jul 2012

1 answer

95 views

Filter entities when using OpenAccessDataSource

I have read through the doco on using OpenAccessDataSource with reporting. My preview of my report is working fine, so its getting data from the model OK. Though the doco is very short on how to initialise the report with the ORM objects/apply filtering.

To me the examples in the help seem very contrived as they show the OADS controls as being external to the report, when in fact they are a member inside the report, meaning the cannot be initalised externaly as shown in the examples.

In my case, I have two OADS objects in my report, one for the order, one for the orderItems.

How should I set parameters so that the OADS control gets the correct data for the report.
In my case, I just want to set massOrderId externally.

Hopefully I'm missing something very basic.

Thanks,

Pat.

General Discussions

answered on 11 Jul 2012