RDLC Reports Loading too slow even to fetch a single row from Mssql

I have created a telerik report which uses Norwegian characters in the report as well as in the csv data sources. But in the Report designer when I go to the preview tab I can see that some special characters that are from the csv data source are missing. Characters in question is 'ØÆÅ'. All the special characters in the report (hard coded) are shown correctly, only the characters from the csv file that is not shown. Hence I went through the Configure CSV data Source and I found out that when parsing the CSV , there also these characters are missing (Shown in the attachment). How can this be fixed or does special characters are not supported for CSV files?

I have 4 textboxes that correspond to a multi-select dropdown parameter.  The space for the textboxes is a set width on my report.  Depending on which options you choose from the parameter dropdown, the other textboxes visibility will toggle on and off.  I have also set the width of the text boxes to change depending on how many are selected (if 2 options are selected, each is 1/2 of the given space.  If 3 are selected, each will be 1/3 of the space.

My problem now is I need to set the location of the textboxes depending on what is chosen.  If the first and third text box are shown and the second and fourth are hidden, the first and third will each be half of the space.  BUT I would need the third box to scoot over against the first.  Now, it stays at its original location and creates whitespace, causing the 3rd box to go onto a second page.

box1 box2 box3 box4

box1_____box3____

Is there a way to make box 3 move to the left up against box1 if box 2 is hidden?

 

Thanks,

Phillip

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:

 

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

 

Any ideas or am I completely doing it wrong?

 

 

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

     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..

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.

 

 

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

 

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>

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.