Telerik Forums
Reporting Forum
0 answers
66 views
Hi
   I am use Windows 8,Telerik Reporting installed in my machine is 8.1.14.804.

Aravind
Top achievements
Rank 2
Iron
Iron
Iron
 asked on 04 Oct 2014
1 answer
74 views
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.
Stef
Telerik team
 answered on 03 Oct 2014
1 answer
150 views
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.
Stef
Telerik team
 answered on 03 Oct 2014
2 answers
792 views
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? 

Mark
Top achievements
Rank 1
 answered on 03 Oct 2014
1 answer
58 views
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












Hinata
Top achievements
Rank 1
 answered on 03 Oct 2014
1 answer
521 views
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? 
Nasko
Telerik team
 answered on 03 Oct 2014
6 answers
1.1K+ views
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?


Stef
Telerik team
 answered on 03 Oct 2014
1 answer
121 views
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?
Hinata
Top achievements
Rank 1
 answered on 03 Oct 2014
1 answer
1.4K+ views
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?
Mark
Top achievements
Rank 1
 answered on 03 Oct 2014
1 answer
234 views
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
Nasko
Telerik team
 answered on 03 Oct 2014
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?