Telerik Forums
Reporting Forum
2 answers
300 views

I am trying to move a project from the Visual Studio Report Designer to the standalone Report Designer. Most of my reports are inherited from Telerik.Reporting.Report, so I want to be able to keep the custom code in each class, but to load the report from a TRDP file.

The class definition and constructor of my classes looks something like:

public partial class MyReport : Telerik.Reporting.Report
{
    public MyReport()
    {
        InitializeComponent();
        // ... class specific code ...
    }
}

 

I would like to be able to initialize the report with a trdp file to look something like the following:

public class MyReport : Telerik.Reporting.Report
{
    public MyReport()
    {
        LoadReport("c:\SomeFolder\MyReport.tdrp");
        // or
        LoadReport(Resources.MyReport);
        // ... class specific code ...
    }
}

 

Any ideas or am I completely doing it wrong?

 

 

Richard
Top achievements
Rank 1
 answered on 20 Apr 2018
1 answer
218 views

Hi,

I am trying to export the reporting dataset to CSV. The built-in export to CSV function does not fit my needs as my use case is for a CSV export of all data used to plot the line-graph that the user is currently looking at. In order to do this, I have created a function on the report which outputs the  and I then extract the SQL query, add the user selected parameters and then re-execute the statement against the DB.

 

I have several questions about this -

  1. This feels like a huge overhead given that the dataset has already been pulled from the database but I cannot find any way to access the used by the report. Can I access the reports ?
  2. I am using the HTML5 report viewer and cannot find any way to access the InstanceReportSource, this means I can't access the parameters sent to the report and I need to get the parameters from the ReportViewer instead. This is problematic as the parameters aren't loaded until after the user clicks Preview; our reports automatically load and 50% of the time this will be the CSV data that the user wants. As a I have added a function that will return the default values used upon the reports first run but again, thIs feels like a huge overhead and gives us maintainability issues etc. Is there a way to access the InstanceReportSource so I can get the parameters used by the report?
  3. I am open to suggestions that will make this easier/more maintainable, is there a better way to solve this problem? 

Thanks

Paul
Top achievements
Rank 1
 answered on 19 Apr 2018
0 answers
79 views

     Hi there,

I want to use the same connectionString as i am using it on local running application as i want to use the same connectionString after deployment..

Danish
Top achievements
Rank 1
 asked on 19 Apr 2018
0 answers
203 views

Hi

When try to export the report from the server i get this error

:'An error has occurred while processing Table 'table1
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not
found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote

The problem when i set the connection string from code its working but the data source can not read the connection string from app.config with the same connection, There any permission or setting to set on the server to access app.confg by report dll???

 

Note: in my local it working without any problem, also i using asp.net core and the report access the connection from app.config

 

So if the answer check the connection string its working all not the connection same the application and the application working with the same connection.

I think the problem the report dll can not reach to app.config.

 

 

abdullah
Top achievements
Rank 1
 asked on 18 Apr 2018
0 answers
126 views

Hi,

 

I have a report in which I use telerik, when I generate the report it looks perfect, however, when I generate a .xls file I have 3 rows for the header (it should be merged into one), there are some extra lines being generated by the report in Detail Section when I use textboxes.

I attached a file as an example, you can see that there are some blank lines till line 10.

Do you have an idea on how to solve this problem?

Thanks

 

Ricardo
Top achievements
Rank 1
 asked on 17 Apr 2018
2 answers
137 views
Trelerik Report Designer version is - 10.2.16.1025

https://www.telerik.com/support/whats-new/reporting/release-history/telerik-reporting-r3-2016-sp1-(version-10-2-16-1025)

See sample report content below as proof of concept for the error we are encountering. Follow these steps:

1) Go to Preview

2) Try export to Powerpoint Presentation

3) Encounter exception when exporting to .pptx - seems like the Angle=270 attribute on the textbox is the culprit. This was working in Telerik Reporting 10.1.16.615.

Report content:

<?xml version="1.0" encoding="utf-8"?>
<Report Width="16cm" Name="Report1" SnapGridSize="0.1cm" xmlns="http://schemas.telerik.com/reporting/2012/4.1">
  <Items>
    <PageHeaderSection Height="2cm" Name="pageHeaderSection1" />
    <DetailSection Height="5cm" Name="detailSection1">
      <Items>
        <TextBox Width="3.00000010093053cm" Height="1.99999939441683cm" Left="6.49999954581262cm" Top="2.19999989906947cm" Value="textBox1" Angle="270" Name="textBox1">
          <Style TextAlign="Center" VerticalAlign="Middle" />
        </TextBox>
      </Items>
    </DetailSection>
    <PageFooterSection Height="2cm" Name="pageFooterSection1" />
  </Items>
  <PageSettings PaperKind="A4" Landscape="False">
    <Margins>
      <MarginsU Left="2cm" Right="2cm" Top="2cm" Bottom="2cm" />
    </Margins>
  </PageSettings>
  <StyleSheet>
    <StyleRule>
      <Style>
        <Padding Left="2pt" Right="2pt" />
      </Style>
      <Selectors>
        <TypeSelector Type="TextItemBase" />
        <TypeSelector Type="HtmlTextBox" />
      </Selectors>
    </StyleRule>
  </StyleSheet>
</Report>
Silviya
Telerik team
 answered on 16 Apr 2018
1 answer
406 views

Hello,

 

Currently, we are building  a telerik report, using Cell merge and conditional formatting functionality.

 

As per the attached screen, we have 3 different checkbox on the top of the screen and based on that we are displaying 3 different columns for each day (Image 1).

User can uncheck any of the checkbox and respective columns should be removed from the report and other columns should be working responsively and take remaining space and divide the space into 2(Image 2). Here, second column is not properly being set based on the total width(Here the first checkbox is unchecked).

 

If user is unchecking the last checkbox, the columns width are not being set and the space is still being occupied for 3rd-last column(Image 3) due to merge cell feature.

 

To achieve the same, we are hiding and showing the columns based on conditional formatting.

 

Urgent help would be highly appreciated.

 

 

 

 

 

 

Todor
Telerik team
 answered on 16 Apr 2018
1 answer
143 views

So, we have a TESTenvironment where we test our product, including our Telerik reports. Once a report is deemed production ready, it is moved into our LIVE environment.

I would like to print a "TEST" watermark on reports generated from our TEST environment. Is there a built in way to determine where my data is coming from, or do I need to add a field to my data source that contains this information?

We have many reports, so if there's a built-in function or way to do this, that would save a lot of work.

Thanks!

Katia
Telerik team
 answered on 16 Apr 2018
0 answers
164 views

Hi,

I have a problem with page number when using group in telerik report designer.

i could not reset the page number when changing the group.

 

Any Idea,

Regards.

 

Kamil
Top achievements
Rank 1
 asked on 14 Apr 2018
1 answer
674 views

*** ReportProcessor.ProcessReport STARTED ***

*** ProcessReport #0 STARTED ***
Exception thrown: 'Telerik.Reporting.Processing.CancelProcessingException' in Telerik.Reporting.dll
Exception thrown: 'Telerik.Reporting.Processing.CancelProcessingException' in Telerik.Reporting.dll
Exception thrown: 'Telerik.Reporting.Processing.CancelProcessingException' in Telerik.Reporting.dll
Exception thrown: 'Telerik.Reporting.Processing.CancelProcessingException' in Telerik.Reporting.dll
Exception thrown: 'Telerik.Reporting.Processing.CancelProcessingException' in Telerik.Reporting.dll
Exception thrown: 'Telerik.Reporting.Processing.CancelProcessingException' in Telerik.Reporting.dll
*** ProcessReport #0 DONE in 00:00:00.2332595 ***

Exception thrown: 'Telerik.Reporting.Processing.CancelProcessingException' in Telerik.Reporting.dll
*** ReportProcessor.ProcessReport DONE in 00:00:00.2631089 ***

 

Above you will find the most useless log a developer can receive.

Obviously something went wrong, but what!? Was it the report, the datasource, a bad conditional formatting, a mistyped column!? Why not actually THROW the exception, at least visual studios will allow me to inspect the exception, and devs should be handling exceptions anyways so this isnt really doing anyone any favors. But this, the way it is now, im on a wild goose chase trying to figure this one out. What can i possibly do to help me pinpoint the exact issue!?

Imagine you asked me for a log and the above was all i was able to produce, you wouldnt know where to begin looking would you?

Todor
Telerik team
 answered on 13 Apr 2018
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?