Questions on Reporting Forum

0 answers

81 views

Why i am getting Telerik

Hi
I am use Windows 8,Telerik Reporting installed in my machine is 8.1.14.804.

General Discussions

asked on 04 Oct 2014

1 answer

82 views

Conditional Formatting on Sub Report

I use sub report in the footer of parent report.
There is a field of Document Type.
i want that Sub Report Visibility is false when Document Type = "DELIVERY ORDER".
I give the condition

Expression Operator Value
=Field.DocumentType = ="DELIVERY ORDER"

But this is not working it is show that report.
Help me.

General Discussions

answered on 03 Oct 2014

1 answer

182 views

Conditional Formatting on Sub Report

I use sub report in the footer of parent report.
There is a field of Document Type.
i want that Sub Report Visibility is false when Document Type = "DELIVERY ORDER".
I give the condition

Expression Operator Value
=Field.DocumentType = ="DELIVERY ORDER"

But this is not working it is show that report.
Help me.

Report Designer (standalone)

answered on 03 Oct 2014

2 answers

849 views

HTML5 Report Viewer - Export options are missing

The Export options are missing from the Report Viewer - I'm using the HTML5 Report Viewer. The icon is visible but clicking it does nothing.

I can successfully call api/reports/formats and see the available formats in the returned json
I have references to DocumentFormat.OpenXML and Telerik.Reporting.OpenXmlRendering

According to the docs this is enabled by default, so what am I missing?

General Discussions

answered on 03 Oct 2014

1 answer

93 views

Reporting & Openaccess & Cache error

Hello telerik,

we have problem with telerik reporting cache configuration. We have web application with that one configuration
Cache configuration for Telerik Reporting - Documentation

But we have limit for web request execution timeout <httpRuntime maxRequestLength="10240" executionTimeout="120" /> in web.config.

If user print more than ten reports sometimes error occured.
In IIS we found that error:
Event code: 3001
Event message: The request has been aborted.
Event time: 1. 10. 2014 8:28:28
Event time (UTC): 1. 10. 2014 8:28:28
Event ID: fac8e9f29da44308a956b8a40a77f776
Event sequence: 468895
Event occurrence: 4
Event detail code: 0
......
Request information:
Request URL: ...../Telerik.ReportViewer.axd?instanceID=e2e347934c98455992ff6c852ad9b479&optype=Report&PageIndex=0&RenderID=1cf163f3e6dc4c469f1ee686e29ee837&RenderingFormat=HTML5
Request path: /Telerik.ReportViewer.axd
....(sensitive data)
Is authenticated: True
Authentication Type: Forms
Thread account name: NT AUTHORITY\NETWORK SERVICE

In Application stack trace error:
Delete failed: System.InvalidOperationException: ExecuteReader needed open Connection. Current state is closed.
v Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeUpdate()
v OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeUpdate()
v OpenAccessRuntime.Relational.RelationalStorageManager.deleteRow(PreparedStatement ps, RelationalOID oid, String sql)
Row: GenericOID@6e636f66 SessionState resource_id=05ceed656ae242a3a0b5c2f083098bf2/session_id=6fc22894b45a47878fa2e191f9fdcd1a
DELETE FROM [session_state] WHERE [resource_id] = ? AND [session_id] = ?
(set event logging to all to see parameter values) System.InvalidOperationException: ExecuteReader vyžaduje otevřené a dostupný element Connection. Aktuální stav připojení je Zavřeno.
v Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeUpdate()
v OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeUpdate()
v OpenAccessRuntime.Relational.RelationalStorageManager.deleteRow(PreparedStatement ps, RelationalOID oid, String sql)

How can solve that problem?

Best regards
Vladimir

General Discussions

answered on 03 Oct 2014

1 answer

584 views

Telerik Reporting Table rows are not rendering

Hello,

I am trying to create Telerik reporting table programmatically , facing an issue with Telerik.reporting.table where my datatable rows are not getting rendered. Report is showing up only columns not rows. For more info, please find attached images for datatable and Telerik.reporting.table.

Here is code snippet my using

public Table DataGrid()

{

Table table = new Table();

// Get data and bind it to the table

System.Data.DataTable data = ChartsData.chartTable();

// Clear table before binding

table.ColumnGroups.Clear();

table.Body.Columns.Clear();

table.Body.Rows.Clear();

table.DataSource = data;

int colCount = data.Columns.Count;

for (int i = 0; i <= colCount - 1; i++)

{

TableGroup tableGroupColumn = new TableGroup();

table.ColumnGroups.Add(tableGroupColumn);

//table.Body.Columns.Add(new TableBodyColumn(Unit.Inch(0.01)));

HtmlTextBox txtGroup = new HtmlTextBox()

{

Size = new SizeU(Unit.Inch(1.1), Unit.Inch(0.3)),

Value = data.Columns[i].ColumnName,

Style =

{

BorderStyle = { Default = BorderType.Solid },

BorderColor = { Default = System.Drawing.Color.Black },

Font = { Name = "Arial", Size = new Unit(10) },

VerticalAlign = VerticalAlign.Middle

},

};

tableGroupColumn.ReportItem = txtGroup;

HtmlTextBox txtTable = new HtmlTextBox()

{

Size = new SizeU(Unit.Inch(1.1), Unit.Inch(0.3)),

Value = "=Fields." + data.Columns[i].ColumnName,

Style =

{

BorderStyle = { Default = BorderType.Solid },

BorderColor = { Default = System.Drawing.Color.Black },

BorderWidth = { Default = new Unit(0.5, UnitType.Point) }

}

};

table.Body.SetCellContent(0, i,txtTable);

table.Items.AddRange(new ReportItemBase[] { txtTable, txtGroup });

}

return table;

}

Please advise how to resolve this issue?

General Discussions

answered on 03 Oct 2014

6 answers

1.3K+ views

ReportViewer (html) Parameters are not refreshing in the report.

The report I'm building is using a CustomReportResolver and has System, ReportName and Footer parameters that I am adding to the report at runtime. Whenever the user selects new criteria for the report (handled separately) and then refreshes the ReportViewer in the MVC page (razor), I then rebuild the report from scratch - re-adding the parameters with respective values, along side my custom data object source. The problem is with displaying the footer text parameter that contains a big long string describing the criteria that the user has selected. However, even though I can see, using breakpoints, that the report being built contains the updated footer text, when the report refreshes (html5 / web/api) the footer parameter still contains the text from the first time it was built. Why are the parameters being cached even though its a brand new Telerik.Report object? and how can I stop this so it will show the latest text that I've added?

General Discussions

answered on 03 Oct 2014

1 answer

175 views

Pth Percentile Calculation

Here's my current scenario. I have 100+ records, grouped by one of their column values. Each detail record has a "Days Elapsed" integer value. I am trying to determine the value of Days Elapsed at the 90th percentile for each group. I can find what record I need, ie a group has 77 records, the record at the 90th percentile is the 69th. So what I want is to display the Days Elapsed value for the 69th record within that group.

Is there any way to do this?

General Discussions

answered on 03 Oct 2014

1 answer

1.5K+ views

Format of the initialization string does not conform to specification starting at index 0

I am using a trial version of Telerik Reporting and I can't get past a connection string issue. I'm using the HTML5 Report Viewer and running it locally.

I have created a simple report in VS2012 with a SqlDataSource that uses the default connectionstring:

Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString

In my app.config I have the connection defined:

<br><connectionStrings><br> <add name="Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString"

<br>            connectionString="Data Source=(local)\SQLEXPRESS;Initial Catalog=myDB;User Id=xxxx;Password=xxxx"<

br> providerName="System.Data.SqlClient" /><br></connectionStrings>

I can preview the report in Visual Studio, but when I view it through the report viewer I get the error:

Format of the initialization string does not conform to specification starting at index 0

Telerik Reporting is very new to me and I seem to be going round in
circles trying to find the solution. Can anyone shed any light on this?

General Discussions

answered on 03 Oct 2014

1 answer

262 views

Trendline with Scatter Chart?

Hi all,

Is there an easy way to add a trendline (trend line) to a Telerik Scatter Chart? This is something management is doing in Excel, and they want to see it on the Telerik reports too. See attached.

Right now I'm going down the path of calculating my own line from the data to add to the chart. Is this the easiest way?

Thank you

General Discussions

answered on 03 Oct 2014