Questions on Reporting Forum

1 answer

209 views

How to count the occurrences of a textbox?

Is it possible to place a text box in a group footer and then count the number of times the text box is generated? I am trying to count the number of groups that occur. When I use the Aggregate function Count() on the Field that is grouped I get a count of the individual line items, not the group itself. Any thoughts?

General Discussions

answered on 12 Jul 2012

1 answer

93 views

PDFs on iphone

I have a couple of users that use iphone devices (I just wish they'd use a respectable manufacturer) and on them any reports generated from the system and saved as pdf have their text missing. All other formatting such as header backgrounds etc is present. If I include graphics in them it's all present.

To debug I generated a report from VS designer and saved as PDF, that one works on their phones. So if a report is generated via a reportbook on the website, it fails, from VS all OK.

Looking at the file I can see that in the VS one I have the font embedded as Tahoma, in the file generated via a reportbook there is no embedded font.

I'm guessing that in their usual arrogance apple left off the tahoma font (sorry can't help bashing apple!).

So to fix, is there something that I need to do in the reportbook to force the font embedding?

Regards,

Jon

General Discussions

answered on 12 Jul 2012

1 answer

407 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

94 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

94 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

187 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

470 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

92 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

307 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

157 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;

}