Telerik Forums
Reporting Forum
1 answer
90 views

developing a report in VS and upon running only produces data in column 1 and doesn't return all the records.  (See picture 1).  I imported the report into Report Designer connected the connection to an Access DB and run the report and returns records as they should. (See Picture 2).  I am not sure what is happening. I copied all the header columns and detail columns from Report Designer and pasted in my VB project.  

There isn't anything wrong with the SQL as it produces all records if running the query on its own.  

Silviya
Telerik team
 answered on 20 Nov 2018
1 answer
226 views
Am new to Telerik reporting. Have tried creating a report where data source accesses SQL Server stored procedure that uses sp_executesql command. There are no temporary tables in this sql. The resulting data source does not show any of the columns from the stored procedure. Is there a work-around for dealing with this? Thanks
Silviya
Telerik team
 answered on 20 Nov 2018
1 answer
83 views

With the Pie Graph in Telerik reporting, the Pie looks kind of blah when we compare it to our Pie graph we use with Kendo UI.

The designer would like to see the same roundedBevel treatment in the Reporting too.

See attached. 

Possible?

 

 

Silviya
Telerik team
 answered on 20 Nov 2018
1 answer
102 views

Hi All!

I want to build a graph with time values:

YAxis - Numeric (i convert TimeSpan to integer with TimeSpan.TotalSeconds and and use this number in the graph)

XAxis - Category

please see the attached screen.

How i can replace numeric values with Time values? I tried formatting and it does not help. probably need to listen to events, but I could not find an example.

I really need your help.

Nasko
Telerik team
 answered on 19 Nov 2018
1 answer
160 views

Hi

I am new to your reporting tool (coming from Crystal Report and trying to run away from it!).

I am trying to build a report that I will feed at runtime with a .Net dataset. How can I do it?

I saw https://docs.telerik.com/reporting/faq-xml-support but some links are not valid anymore.

I have also seen https://www.telerik.com/forums/using-telerik-report-designer-with-xml-datasource but it is 5 years old.

How does it work?

Silviya
Telerik team
 answered on 16 Nov 2018
1 answer
584 views

Hi

I am trying to add the converter for Crystal Reports in the stand alone designer. I have trier to follow the instructions from  https://www.telerik.com/support/kb/reporting/details/converting-reports-from-various-versions-of-crystalreports but can't get it to work.

I have edited both Telerik.ReportDesigner.x86.exe.config and Telerik.ReportDesigner.exe.config as shown here below but after the config is saved, the designer application just does not start. If I comment out the new sections, the designer app starts correctly. What am I doing incorrectly? 

<?xml version ="1.0"?>
<configuration>
<configSections>
<section
name="Telerik.Reporting"
type="Telerik.Reporting.Configuration.ReportingConfigurationSection, Telerik.Reporting"
allowLocation="true"
allowDefinition="Everywhere"/>

    <section
        name="Telerik.ReportDesigner"
        type="Telerik.ReportDesigner.Configuration.ReportDesignerConfigurationSection, Telerik.ReportDesigner.Configuration"
        allowLocation="true"
        allowDefinition="Everywhere"/>    
</configSections>

<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
</startup>

  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <!--
      <probing privatePath="path-to-the-assemblies"/>
      -->
      <dependentAssembly>
        <!-- Required for interoperability with older versions of Telerik Reporting -->
        <assemblyIdentity name="Telerik.Reporting" culture="neutral" publicKeyToken="a9d7983dfcc261be"/>
        <bindingRedirect oldVersion="0.0.0.0-12.2.18.1017" newVersion="12.2.18.1017"/>
      </dependentAssembly>
  
  
  <dependentAssembly>   
        <assemblyIdentity name="CrystalDecisions.CrystalReports.Engine"publicKeyToken="692fbea5521e1304"culture="neutral"/>   
        <bindingRedirect oldVersion="13.0.20.2399"newVersion="13.0.3500.0"/>   
      </dependentAssembly>   
      <dependentAssembly>   
        <assemblyIdentity name="CrystalDecisions.Enterprise.Framework"publicKeyToken="692fbea5521e1304"culture="neutral"/>   
        <bindingRedirect oldVersion="13.0.20.2399"newVersion="13.0.3500.0"/>   
      </dependentAssembly>   
      <dependentAssembly>   
        <assemblyIdentity name="CrystalDecisions.Enterprise.InfoStore"publicKeyToken="692fbea5521e1304"culture="neutral"/>   
        <bindingRedirect oldVersion="13.0.20.2399"newVersion="13.0.3500.0"/>   
      </dependentAssembly>   
      <dependentAssembly>   
        <assemblyIdentity name="CrystalDecisions.Shared"publicKeyToken="692fbea5521e1304"culture="neutral"/>   
        <bindingRedirect oldVersion="13.0.20.2399"newVersion="13.0.3500.0"/>   
      </dependentAssembly> 
  
  
    </assemblyBinding>
  </runtime>

  <connectionStrings>
    <add name="Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString"
        connectionString="Data Source=(local);Initial Catalog=AdventureWorks;Integrated Security=SSPI"
        providerName="System.Data.SqlClient" />
  </connectionStrings>
  
  <Telerik.ReportDesigner DefaultWorkingDir="Examples">
  </Telerik.ReportDesigner>

<!-- Add assembly references -->
<!--
<Telerik.Reporting>
<AssemblyReferences>
<add name="MyFunctions" version="1.0.0.0" />
</AssemblyReferences>
</Telerik.Reporting>
-->

<!--  
<system.diagnostics>
<trace autoflush="true" indentsize="4">
<listeners>
<add name="myListener" type="System.Diagnostics.TextWriterTraceListener" initializeData="C:\Temp\Telerik.ReportDesigner.log" />
<remove name="Default" />
</listeners>
</trace>
</system.diagnostics>
-->
</configuration>

Silviya
Telerik team
 answered on 16 Nov 2018
8 answers
1.2K+ views

Hi There, 

We Telerik Reporting version to convert a data set in csv format and exporting it to PDF format.

There are around 41,000 rows in the csv file. And it generates around 1,000 pages in PDG format. 

controls used in the report are only csvDataSource, crosstab and textbox. No images used.

There are 2 groups, by store and then fiscal month. They are used for the bookmarks in PDF format report.

It takes much time generates the report and receiving System.OutOfMemoryException while exporting the report to PDF. 

But if I reduce the number of records in the source csv file, I'm able to export the data to PDF, so the code is working.

The requirement is to generate all data in one single PDF report as it's enterprise level report, filter/ report parameter is not an option in this case.

See attached screenshot of the error message.

Can anyone know this issue and give some suggestions?

 

Thanks a lot!

Susie

Todor
Telerik team
 answered on 13 Nov 2018
1 answer
893 views

This question is two-fold:

First, I've found documentation where you can add an error handler to the Report.Error handler on individual reports, either in the constructor for the report or the usage of it. However, I'm hoping there might be a global way to add a handler to all reports so I can start logging errors during report rendering to ELMAH/etc. Are there any examples of this?

 

Second, once the errors are logged I would like to show a friendlier message on the report view rather than the error stack trace. I've seen am approach where the backend error handler throws an exception which fires the frontend viewer's errror handler to display some text, but could I just overwrite the stack trace info in the error object to a friendlier message in a single place to get that functionality for all reports?

Ivan Hristov
Telerik team
 answered on 13 Nov 2018
2 answers
492 views

I have been unable to get a Report Preview to work in Visual Studio (I am using 2017). The specific problem is that when I run the preview, I get the error "Could not load file or assembly '(my assembly), Version=(the version), Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified."

We require this custom assembly for various common lookups and data access, including accessing an S3  bucket using AWSSDK.S3.

Anyway, I have searched the web and these forums, and have tried dozens of solutions, none of which work. To prevent needless repletion of solutions that don't work, some solutions I have tried are on these links:

https://www.telerik.com/support/kb/reporting/details/how-to-use-external-assemblies-with-custom-user-functions-in-the-report-designer

https://www.telerik.com/forums/report-preview-fails-due-to-dependency

https://www.telerik.com/forums/designer-use-when-code-references-external-dlls

There are others, too but all basically the same thing. Either the solution tells me to add the runtime assemblyBinding and AssemblyReferences to the app.config, or to put the assemblies in the folder where the Report Designer executable is (i.e., "C:\Program Files (x86)\Progress\Telerik Reporting R2 2018\Report Designer"). That later is pretty dumb, as we would need to copy it there each time we rebuild the assembly, and I hope its not the actually solution... Regardless, I tried both of these solutions, and both together at the same time, and they simply do not work. I continue to get the error.

Most of the posts about this are from years ago, however, so perhaps things have simply changed, and those solutions do not work any more. I am sure we're not the only people trying to use telerik reports that call out to custom libraries.

So, the question is, how do we get the Report Preview to work in VS2017 when the report needs to access functions in an external, custom assembly?

Thanks in advance!

Todor
Telerik team
 answered on 13 Nov 2018
1 answer
110 views
Since the null-coalescing operator (??) and the IsNull function appear to do the same thing, I was wondering if there is a performance benefit of using one over the other.
Ivan Hristov
Telerik team
 answered on 13 Nov 2018
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
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?