Questions on Reporting Forum

1 answer

704 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

67 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

290 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.0K+ 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

216 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

144 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.5K+ 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

54 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

114 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

1 answer

128 views

Out of process session state errors

We're using the ReportViewer control with the Standalone report designer in a VB.net website.

The designer's .trdx files are uploaded to the server, which are then serialised to XML and stored for later use. When the reports are run, we convert the report to a Telerik.Reporting.InstanceReportSource
like this (just the relevant code here, the objects also load parameters into the report object but the issues occur even when there are no parameters present in the report):

Private _ReportObject As Telerik.Reporting.Report

Private _oInstanceReportSource As Telerik.Reporting.InstanceReportSource

ReportObject = DirectCast(New Telerik.Reporting.XmlSerialization.ReportXmlSerializer().Deserialize(New System.IO.StringReader(_ReportXML)), Telerik.Reporting.Report)

_oInstanceReportSource.ReportDocument = ReportObject

We change the connection string to point to the local database and run the reports from there using code from the forum here, and bind the report to the control using the instanceReportSource

rptView.ReportSource = _oInstanceReportSource

rptView.DataBind()

We've made sure to only use the reporting engine data sources (sqldatasource) and we're able to change all the connection strings from whatever they were set up with in the report using code we pulled from the forums here.

So far, so good.

We have intermittent errors:

Unable to serialize the session state. In 'StateServer' and 'SQLServer' mode, ASP.NET will serialize the session state objects, and as a result non-serializable objects or MarshalByRef objects are not permitted. The same restriction applies if similar serialization is done by the custom session state store in 'Custom' mode

However, it's not consistent. Refreshing the page a few times (sometimes once, sometimes 12 or so refreshes) will eventually lead to the report working correctly.

It's a big production environment where we're using StateServer mode and using inProc session state isn't possible. It happens on our dev machines when we're using local IIS as well as our test server.

General Discussions

answered on 15 Apr 2015