Questions on Reporting Forum

1 answer

98 views

Binding to XML at Design-Time using an XMLDataSource

Hi all!

I have installed Reporting Trial version and I want to create a report using XML Datasource.

Reading online documentation, i found this article :

"Binding to XML at Design-Time using an XMLDataSource"

link: http://www.telerik.com/help/reporting/buildingdatabindxmldesigntime.html .

but in my software i not found "Chart Smart Tag " and when i want to select a Data Source i have only these option ( DataSourceWizard1.png) .

any suggestions???

Thanks,

Elena

General Discussions

answered on 20 Apr 2015

1 answer

775 views

Convert Crystal Report to Telerik Report with Standalone Designer

Hi,

I have Crystal rpt files and I need convert to trdx file with Telerik Report with Standalone Designer.

Actualy I using Crystal Reports version 14.1.4.1327 and my machine support 64 bit but I see this eror message.

"Could not load file or assembly 'CrystalDesicions.CrystalReports.Engine,version=10.2.3600.0 , culture=Neutral'. PublicKeyToken=''692bea5521e1304' or one of its dependencies.The system cannot file the file specified."

General Discussions

answered on 20 Apr 2015

1 answer

84 views

Add DataSource to subreport after deserialization

Hi.

My report class looks like this:

public partial class SystemReport<THeader, TBody> : Report

where THeader : Report, new()

where TBody : Report, new()

{

public THeader ReportHeader { get; private set; }

public TBody ReportBody { get; private set; }

public SystemReport()

{

InitializeComponent();

InitializeSubReportHeader();

InitializeSubReportBody();

}

private void InitializeSubReportHeader()

{

ReportHeader = new THeader();

headerReportSource = new InstanceReportSource { ReportDocument = ReportHeader };

InitSubReport(ReportHeader, subReportHeader, headerReportSource);

}

private void InitializeSubReportBody()

{

ReportBody = new TBody();

bodyReportSource = new InstanceReportSource { ReportDocument = ReportBody };

InitSubReport(ReportBody, subReportBody, bodyReportSource);

}

private void InitSubReport(Report report, SubReport subReport, ReportSource reportSource)

{

((ISupportInitialize)(report)).BeginInit();

subReport.ReportSource = reportSource;

}

The way I create the report where OperationHeader and OperationBody are seperate subReports:

var report = new SystemReport<OperationHeader, OperationBody> {DataSource = model};

report.ReportBody.DataSource = model;

report.ReportHeader.DataSource = model;

After assigning above created report to reportViewer.ReportSource everything is displayed correctly.

Now I want to serialize this report. It seems to be possible using ReportXmlSerializer class. The think is that when the report is deserialized, type of report is no longer SystemReport but Report base type.

As I understood it correctly when report is deserialized I have to assign once again data sources. I'm doing it in this way:

foreach (var item in systemReport.Items.OfType<Telerik.Reporting.DetailSection>())

{

var subReport = item.Items.OfType<Telerik.Reporting.SubReport>().Single();

subReport.Report.DataSource = model;

}

foreach (var item in systemReport.Items.OfType<Telerik.Reporting.ReportHeaderSection>())

{

var subReport = item.Items.OfType<Telerik.Reporting.SubReport>().Single();

subReport.Report.DataSource = model;

}

systemReport.DataSource = model;

But actually after assigning report to reportViewer.ReportSource, subReports are not rendered at all.

Do you have any idea what I'm doing wrong? Or is there any other way to solve this?

General Discussions

answered on 17 Apr 2015

1 answer

323 views

Single Series Graph, and filtering

I am a long time Telerik Reporting user, but this is my first attempt at graphs. Any assistance is appreciated.

I have 2 datatables being passed to my report via a dataset. table(0) populates the main purpose of the existing report, and is grouped with approx 200 pages of data. I now need to add a graph to the GroupHeaderSection of the report, which I have done via the Graph Wizard. table(1) contains the graph datasource and a sample is posted below.

Dim mytable As New DataTable

mytable.Columns.Add("jobcode", String.Empty.GetType())

mytable.Columns.Add("labels", String.Empty.GetType())

mytable.Columns.Add("Count", GetType(Integer))

mytable.Rows.Add(New Object() {"Job 93001", "20-30", 4})

mytable.Rows.Add(New Object() {"Job 93001", "30-40", 3})

mytable.Rows.Add(New Object() {"Job 93001", "40-50", 27})

mytable.Rows.Add(New Object() {"Job 93001", "50-60", 2})

mytable.Rows.Add(New Object() {"Job 93001", "60-70", 1})

mytable.Rows.Add(New Object() {"Job 93002", "20-30", 3})

mytable.Rows.Add(New Object() {"Job 93002", "30-40", 6})

mytable.Rows.Add(New Object() {"Job 93002", "40-50", 7})

mytable.Rows.Add(New Object() {"Job 93002", "50-60", 8})

mytable.Rows.Add(New Object() {"Job 93002", "60-70", 2})

1. The graph is treating each row in the datatable as a series. How do I force this to a single series for color and alignment purposes?

2. How do I filter between the 2 datasets. In the main report, Fields.jc is the group control. I need to filter the graph to only show the appropriate jobcode based off of the groupheadersection.

Thank you.

General Discussions

answered on 17 Apr 2015

3 answers

1.1K+ views

How to create a report with stored procedures and dynamic SQL queries

Hi,

I need to create a report in my MVC application that using SQL stored procedure with dynamic SQL query string and EXEC command.

How can I do it and is there any example of that?

Best Regards

General Discussions

answered on 17 Apr 2015

2 answers

257 views

Inherit Series Color from DataSource

I am making chart that will read from a data source holding the name, count, and color for a certain score (ex: series1, 2, #00ff00; series2, 4, #ffff00; series3, 5, #ff0000).

I am creating a 100% stacked bar chart in which I want the counts of each color as the values and the colors as series.

My issue come with my color palette. I want each series to show up as the color value which is held in the dataset. I can't create a custom palette because the colors will not always be the same. I will have a hex color in the dataset which needs to be the color of each corresponding segment of the 100% stacked bar graph.

Has anyone ever done this?

General Discussions

answered on 16 Apr 2015

1 answer

174 views

Table Output pushed to page 2

I have a report that uses an Object Data Source. On the report, I have a two Tables that are on a List. When all the table records don't fit on page 1, the output is pushed to page 2. This leaves too much white space on page 1. Other forum threads indicate that Telerik ignores the 'Keep Together' property on page 1 and to format the report a different way.

Is there a Telerik version that doesn't ignore the Keep Together' property on page 1? Also, do you have a suggestion of how to do the report a different way?

Thanks for your assistance.

Report Designer (standalone)

answered on 16 Apr 2015

11 answers

1.6K+ views

Sum function round to zero decimal places

Hi,
i have a problem with sum function on a textbox, this function round the values to zero decimal places.
i use the Q2 2010 version.
please see this exemple on images.

best reguards,
Francisco

General Discussions

answered on 16 Apr 2015

1 answer

64 views

Reporting 2015 Q1 SP1 Two or more sub report datasource error

Reporting 2015 Q1 SP1 Two or more sub report datasource error.

All sub report is loaded first sub report datasource.

Please reply as soon as possible, thank you.

General Discussions

answered on 15 Apr 2015

1 answer

129 views

Reporting from C++

Is there any update on support for reporting from C++? Any plans for that?

Has anyone used the COM interop approach to create a typelib for the managed dll of the reporting engine or alternatively used CLI to call it from C++?

General Discussions

answered on 15 Apr 2015