Telerik Forums
Reporting Forum
2 answers
483 views
Hi

I have to bind an Object Data Source dynamically to a tablechart control dynamically i.e. not during the design time. Please let me know whether it is supported in telerik reporing. If so, pls let me know how will it be done.

Thanks in advance
Ravindra
Muhammad
Top achievements
Rank 1
 answered on 09 Nov 2017
2 answers
228 views

Hi,

Is it possible to load data from a text file to the telerik report?

Currently we have an external source of data coming from a text file. it is already formatted the way client wants to display on their end.

What we want to do is, we load the entire data to the telerik report without doing much data formatting and layout adjustment.

Is this possible on telerik reporting by setting the datasource to the textfile?

Thanks,

Dondon
Top achievements
Rank 1
 answered on 09 Nov 2017
1 answer
397 views

I'm trying to replicate an Invoice using Telerik Reporting. The detail section contains a table that lists each order's item. It holds around 15 items per page but I need it to hold 30.

Basically I want to turn this:

------------------------------------------------------------------------
 # | Description                        | Qty |  Unit Price  | Price
------------------------------------------------------------------------
 1 | XXXXXXXXXXXXX                      | 001 |       15.00  | 15.00
 2 | YYYYYYYYYYY                        | 005 |        2.50  | 12.50

 

Into this:

------------------------------------------------------------------------
 # | Desc. | Qty | U. Price | Price | # | Desc. | Qty | U. Price | Price
------------------------------------------------------------------------
 1 | XXXXX | 001 |   15.00  | 15.00 | 3 | ZZZZZ | 002 |   15.00  | 30.00
 2 | YYYY  | 005 |    2.50  | 12.50 |

 

I think it can be done using a crosstab by I tried and couldn't do it. Any help is appreciated.

Luiz
Top achievements
Rank 1
 answered on 08 Nov 2017
1 answer
124 views

Hello!

I have a Silverlight application that uses Telerik reporting. Also this application uses Microsoft Prims.
After upgrading from current version of Telerik (6.0.12.215, Q1 2012 Visual Studio 2011 Refresh) to newer (11.1.17.614, R2 2017) issues occurred.
After minor changes in source code (correcting to use right namespaces) solution builds fine, even runs fine, but reports shows nothing useful (no values in parameter-binding fields). So, parameters now do not passes to reports.

This is some source code.

protected void NavigateToPermissionReport()
{
   string navigationSource = AppPages.PermissionReportView + "?" +
   string.Join("&", this.Parameters.Select(parameter => string.Format("{0}={1}", parameter.Key, parameter.Value)));
   this.EventAggregator.GetEvent<NavigateToPageEvent>().Publish(true);
   this.RegionManager.RequestNavigate(AppRegions.NavigationRegion, navigationSource);
}

 

After this piece of code “black magic” happen and execution comes directly to report’s code:

private void OnPermissionItemDataBinding(object sender, EventArgs e)
{   
    this.ItemDataBinding -= this.OnPermissionItemDataBinding;   
    this.BeginGetPermission(this.ReportParameters);
}

private void BeginGetPermission(ReportParameterCollection parameters){
    PermissionViewModel viewModel = new PermissionViewModel();
    viewModel.LoadData(parameters);
    this.DataSource = new ObjectDataSource(viewModel, string.Empty);
}

What happens between these parts of the code I can’t figure out.

So, before upgrading, parameters in ReportParameterCollection had the same values as in navigationSource, but after, parameters became null.

Why this can happen?

Thanks.

Андрей
Top achievements
Rank 1
 answered on 08 Nov 2017
0 answers
129 views

Hello, i have a report made with reporting Q3 2013 and VS 2012. When installing it on the client, it gives error 40: a connection with SQL could not be opened. The report in local is ok. that could be happening? other report in the same app are ok, with de same connection.

I'm using SqldAtaSource with connection defined in web.config.

Thank you

Mariajo
Top achievements
Rank 1
 asked on 07 Nov 2017
2 answers
383 views

Hello,

We are trying to generate the report viewer report in javascript but are having a difficult time trying to figure out what the javascript logic should be.

When we set the report source on the control tag it works flawlessly. 

For example 

<telerik:ReportViewer ID="ReportViewer" runat="server" Width="1240" Height="700" ParameterEditors-SingleSelectEditor="createSingleSelectEditor" >
        <ReportSource Identifier="Reports.Organization_Summary, Reports" IdentifierType="TypeReportSource">
            <Parameters>
                <telerik:Parameter Name="userName" Value="matt" />
            </Parameters>           
        </ReportSource>       
    </telerik:ReportViewer>

 

When we try to set the report source in javascript nothing happens.

Example

<telerik:ReportViewer ID="ReportViewer" runat="server" Width="1240" Height="700" ParameterEditors-SingleSelectEditor="createSingleSelectEditor" />

 

function displayReport()
        {
            var reportViewer = $("ReportViewer").data("telerik_ReportViewer");
            reportViewer.reportSource({
                report: "Reports.Organization_Summary, Reports",
                parameters: { "userName": "matt" },
            });
            reportViewer.refreshReport();
        }

What are we missing for the report to run when the report source is set on the client?

Matt
Top achievements
Rank 1
 answered on 07 Nov 2017
3 answers
985 views

I have an expression like reportProcessor.RenderReport("XLS", ...) which always throws an exception with message "XLS rendering format is not available" when running in Edge.js via an Electron app, but never throws when running "normally" via a WinForms app. Same assembly, same code, but different behavior.

Stack trace for the exception:

   at Telerik.Reporting.Processing.ReportProcessor.GetExtensionInfo(String format)
   at Telerik.Reporting.Processing.ReportProcessor.ProcessAndRender(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at Telerik.Reporting.Processing.ReportProcessor.ProcessAndRenderStateless(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, ReportSource reportSource, Hashtable deviceInfo)
   at [my code]

Other details about the environment:

Telerik.Reporting.dll, version 9.2.15.930

Windows 10

Excel 2016

 

What kind of conditions would cause XLS rendering to be unavailable?

It's probably important to note that this same body of code has an expression like reportProcessor.RenderReport("PDF", ...) which works totally correctly with both the Edge.js-based Electron app and the WinForms app. This expression executes a few statements before the one for XLS that fails.

I checked that the app domains of both apps are running with full trust because I suspected there might be a lack of unmanaged code permissions, but that's apparently not the problem. Both domains have full trust.

Katia
Telerik team
 answered on 06 Nov 2017
8 answers
535 views

I have failed to setup a project as instructed here:

https://docs.telerik.com/reporting/html5-report-viewer-asp-net-core-2

I have been over the instructions 10 times, the error message I receive is.

Error registering the viewer with the service.

An error has occurred.
The type initializer for 'Lock' threw an exception.

Project found here:

https://www.dropbox.com/s/8rl4hhanj5gbfc9/WebApplication2.zip?dl=0

Reafidy
Top achievements
Rank 2
Iron
 answered on 06 Nov 2017
0 answers
70 views

Hi,

 

I'm using telerik report viewer in my web application with angular2.I'm able to get the report fine in developing mode but when i try to compile angular2 code using AOT compilation i'm getting following error as attached in screen shot.can any one help me to resolve the issue

 

Thanks&Rds,

Raghu S

victor
Top achievements
Rank 1
 asked on 06 Nov 2017
3 answers
152 views
Hello.  Under IE 11 everything works great.  But on EDGE when I use dropdown list for filter it's difficult to see the list (see attachment).  Any idea?
Louis
Top achievements
Rank 1
Iron
Iron
Iron
 answered on 05 Nov 2017
Top users last month
Ambisoft
Top achievements
Rank 2
Iron
Pascal
Top achievements
Rank 2
Iron
Matthew
Top achievements
Rank 1
Sergii
Top achievements
Rank 1
Iron
Iron
Andrey
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?