Telerik Forums
Reporting Forum
2 answers
127 views

Good Morning,

I'm trying to add XLSX format for ours reports, we have Reporting Q2 2014.

I added OpenFormatXML.dll on my project, installed OpenXML SDK 2.0 on my computer and on our server.

Now I'm trying to add Telerik.Reporting.OpenXmlRendering.dll on our project with NuGet Package, all seems to be ok with the package creation.

When I install it on my computer all is working, I can export my reports on XLSX format all is ok. But when I push these modifications on the server and try to install this package on another computer there is a crash :

Severity Code Description Project File Line Suppression State Error Could not install package 'Telerik.Reporting.OpenXmlRendering 8.1.14.804'. You are trying to install this package into a project that targets '.NETFramework,Version=v4.5', but the package does not contain any assembly references or content files that are compatible with that framework. For more information, contact the package author

On my computer the Nuget add this line in our packages.config

<package id="Telerik.Reporting.OpenXmlRendering" version="8.1.14.804" targetFramework="net45" />

So I don't understand what's the problem .... Could you help me please? 

Here my Nuspec file :

The dependencies is a packages which contains : Telerik.Reporting.dll and Telerik.Reporting.Service.dll

<package>
  <metadata>
    <id>Telerik.Reporting.OpenXmlRendering</id>
    <version>8.1.14.804</version>
    <title>Telerik.Reporting.OpenXmlRendering</title>
    <authors>XXXX</authors>
    <owners>XXXX</owners>
    <requireLicenseAcceptance>false</requireLicenseAcceptance>
    <description>Export telerik reporting to XML </description>
    <copyright>Copyright XXXXX</copyright>
    <dependencies>
     <dependency id="Telerik.Reporting.Assembly" version="1.0.0.1" />
    </dependencies>
    <references></references>
    <tags></tags>
  </metadata>
  <files>
    <file src="*.dll" target="lib\net45" />
  </files>
</package>

 

Thanks in advance for your help

Ben

 

 

Benjamin
Top achievements
Rank 1
 answered on 04 Aug 2017
3 answers
336 views

Hi,

We develop a wpf application and now our final users need to create them custom report, starting from an empty page and decide everything about the page layout.

I was wandering if is it possible to integrate telerik report designer (exe) into our application. Is it legally possible?

I was thinking about a button from the application that open your exe.

 

Thank you

Nasko
Telerik team
 answered on 03 Aug 2017
1 answer
492 views
Hi,

I need to pass the culture by parameter to a report (TypeReportSource), in the code behind (server side).
From the report side (server side) I need to get the culture passed by report parameter to the report itself.

I tried to to do this with the following code:
Dim cultureInfo As Globalization.CultureInfo = New Globalization.CultureInfo("pt-PT")
Threading.Thread.CurrentThread.CurrentUICulture = cultureInfo Threading.Thread.CurrentThread.CurrentCulture = cultureInfo
 This works before the 'InitializeComponent()' function as expected, but I have no way of retrieving the report parameters at this stage because they weren't initialized yet.

The main idea is to replace "pt-PT" with the report parameter sent when the report was invoked.

The following code shows how I invoke the report and pass it the required parameters:
Dim clientReportSource As New Telerik.ReportViewer.Html5.WebForms.ReportSource clientReportSource.IdentifierType = Telerik.ReportViewer.Html5.WebForms.IdentifierType.TypeReportSource clientReportSource.Identifier = "SIC.UI." & report & ", SIC.UI, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" clientReportSource.Parameters.Add("P1", p1) clientReportSource.Parameters.Add("P2", "pt-PT") reportViewer1.ReportSource = clientReportSource reportViewer1.Page.Title = report

I'm trying to do exactly what you guys have in this demo, but so far unsuccessfully.
I've been digging through the forums and documentation for a few days now and i just can't get this to work.

Any help would be greatly appreciated.

Thanks in advance,
Nuno.
Katia
Telerik team
 answered on 03 Aug 2017
4 answers
248 views

I have a cross tab where I would like to have a sub report that spans across the row groups on the left and across all column groups on the right.  This is tough because I don't know how many columns will end up because it depends on my data.

Is there anyway to make a sub report span row and column groups that it is flush with the left and right borders regardless of the number of columns?

Phil
Top achievements
Rank 1
 answered on 02 Aug 2017
3 answers
166 views

Hello,

  I try to update my Telerik Reports from Q2 2015 to R2 2017. With my report books I have massive problems to get the data into the report.

My code so far (working perfect in Q2 2015) for ReportBook creation:

ReportBook trbReport = new ReportBook ();
 
// Instances of Telerik Report for Report Book
TPage1Report reportPage1 = new TPage1Report;
TPage2Report reportPage2 = new TPage2Report;
 
// Add Reports to ReportBook
trbReport.Reports.Add (reportPage1);
trbReport.Reports.Add (reportPage2);
 
// Add Datasources to report pages
ReportDatasourceClass1 ds1 = new ReportDatasourceClass1 ();
ReportDatasourceClass2 ds2 = new ReportDatasourceClass2 ();
 
trbReport.Reports[0].DataSource = ds1;
trbReport.Reports[0].DataSource = ds2;

And in code behind of the Report itself (I have a Table in the Detail Section, which datasource should be a list in the Reports datasource):

private void detail_ItemDataBinding (object sender, EventArgs e)
{
    ReportDatasourceClass1 data = DataSource as ReportDatasourceClass1;
 
    // Set Datasource of Telerik.Reporting.Table in Report to List Property
    //  in Datasource of report  
    tTable.DataSource = data.List1;
}

 

This is not working anymore in R2 2017: The Table in the Report is empty and in the second page I have some graphs, which datasources are also set in DetailItemDataBinding, which are also empty.

 

The Reports Property of ReportBook is marked as obsolete, so I tried ReportSources.

Problem 1: ReportSources has no property "DataSource". My way to set the DataSource of my report pages is impossible.

Problem 2: The Parameters Section of the ReportSources entries are empty (not filled with the parameter lists from the Reports.

So I tried the following to fix that behaviour:

TPage1Report page1 = new TPage1Report ();
page1.ReportParameters["param1"].Value = param1Value;
page1.DataSource = page1DataSourceInstance;
trbReport.ReportSources.Add (page1);
 
TPage2Report page2 = new TPage2Report ();
page2.DataSource = page2DataSourceInstance;
trbReport.ReportSources.Add (page2);

 

Now in the DetailItemDataBinding my datasource is present, but in the rendered Report the List and Graphs still empty.

 

Has someone solved the ReportBook Datasource in 2017 R2 yet (I used this above method successfully since 2009)?

 

Greetings

  Thomas

Katia
Telerik team
 answered on 02 Aug 2017
8 answers
1.0K+ views

How can we split a table with hundreds of records on multiple pages, using the latest  telerik reporting? I don't want a very html page, which contains the entire table, with a vertical scroll bar.

Thanks in advance.

Katia
Telerik team
 answered on 02 Aug 2017
1 answer
188 views

Hello, im having some issues with the report designer, im developing a report that has quite a lot of graphs and everytime i try to open the report devenv.exe hangs at 99% processor usage, and i know its because the graph previews, is there any way to disable the previews? or can you give me some workaround?

 

Katia
Telerik team
 answered on 02 Aug 2017
0 answers
74 views
I have a object like below

   
public class MyCheckDto
   {
       public string ErrorMessage { get; set; }
       public IEnumerable<EarningsDto> FristEarnings { get; set; }
       public IEnumerable<EarningsDto> AnotherEarnings { get; set; }       
 
   }
 
  public class EarningsDto
   {
       public decimal Field1 { get; set; }
       public decimal Field2 { get; set; }
        
   }

I get my data via web api, then i want to create a pdf using telerik reporting
i wanted to bind it to a objectdatsource but it does not show all the fields inside EarningsDto it shows FristEarnings as one single field. What am i doing wrong?

Justin
Top achievements
Rank 1
 asked on 01 Aug 2017
4 answers
111 views

Hi there. im in trial version. i plan to buy telerik devcomplete version. But my company using asp.net core framework netcoreapp 1.1. i try to use telerik reporting. but its not working for this framework. my company not allow to use .net framework 4.6. 

Please advice me.

 

thank you

Katia
Telerik team
 answered on 31 Jul 2017
1 answer
240 views
I'm having trouble deploying a Reports Rest Service.  When I deploy it in my test environment, I am able to test the API by going to http://servername/ReportsRestService/api/reports and I get a json file listing the file formats...  When I deploy the same files to a client's server (same Host OS - Windows Server 2012 - IIS 8.5), the URI gives a 500 error with no description why.  Any ideas as to what could be going on?
Milko
Telerik team
 answered on 31 Jul 2017
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?