Telerik Forums
Reporting Forum
0 answers
138 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
149 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
430 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
159 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
175 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
706 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
3 answers
437 views

Hello,

       I am using Telerik Reporting R3 2016 and generating some clustered bar chart. I need to increase gap between each item in grouped bars. I have attached screenshot, please refer. Is that possible to increase gap between grouped bars?

Silviya
Telerik team
 answered on 13 Apr 2018
1 answer
256 views
How do I pass parameters from one sub report to another so that I can use for filtering? I have a sub report in the header of the parent report. I would like the sub report to not show on a page where another sub report exists. I would normally use something static like page number, but the report pages vary depending on data.
Silviya
Telerik team
 answered on 11 Apr 2018
1 answer
331 views

I am trying to create a report that has justified text and has portions of the text underlined.  I'm using an HtmlTextBox and can set the properties to justify the text and underline portions of it.  However, it displays the underline by underlining each word separately, leaving a space between the lines.  Is there any way to force the underline to be one continuous line when using justified text?

Thanks!

Silviya
Telerik team
 answered on 10 Apr 2018
1 answer
205 views

From other forum posts it seems we cannot add multiple detail sections.  I am wondering how to accomplish the following task. (pictures attached)

Dataset is preformatted, and can't easily change.  Currently, the section headers are just treated as inline text in column 1, and background color for all cells is changed to black based off of a formatting field provided in the data.  This works great (Existing.PNG).

 

I received a request that they want to extend the text beyond the width of column 1 and center it. (Proposed.PNG)

Ideally, if I could have a second detail section, I could have a formatted textbox that spans the columns, and another detail section with the spreadsheet type cells.  I would then use conditional formatting to hide visibility.

 

Short of being able to have a second detail section, how could I perform this task with Telerik Reporting?

 

 

 

 

 

Joel
Top achievements
Rank 2
 answered on 09 Apr 2018
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?