Telerik Forums
Reporting Forum
1 answer
277 views

I am using Telerik Reporting 12.1.18.620 in my ASP.NET (4.8) web application. It has been working fine for years but I suddenly encountered this error.

    public void SetReport()
    {
        if (hidReportName.Value.Length > 0)
        {
            var reportPlaintext = hidReportName.Value.QsDecrypt();
            var report = string.Format("TelerikReports.{0}, TelerikReports, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null", reportPlaintext);
            try
            {
                Type reportType = Type.GetType(report);
                IReportDocument reportDocument = (IReportDocument)Activator.CreateInstance(reportType);
                Report = reportDocument as Report;
                ReportViewer.ReportSource = (ReportSource)reportDocument;  //Here is where the error occurs
            }
            catch (Exception)
            {
                throw new Exception(String.Format("Error loading Telerik report '{0}'", ReportName.QsDecrypt()));
            }
        }

I have searched extensively and tried to resolved this error but I am stymied. This is a huge blocker because I can't deploy the latest (non-reporting) code to production until this is fixed. I have been working on this for a week now with no luck.

Please help!

Dimitar
Telerik team
 answered on 25 Oct 2023
1 answer
507 views

Hi,

when i open an image on pc it is perfect instead on report the image load is rotate 180 degree.

can i rotate image on telerik report designer?

 

Michele
Top achievements
Rank 1
Iron
 updated answer on 24 Oct 2023
0 answers
100 views

Hello I'm having issues when report is being generated thru report viewer its creating empty spaces.

Preview Looks good.

Report viewer.

Appreciate any help thanks.

2 answers
1.2K+ views

Hello.
Currently I am designing a report, very simple report like below.
I'm using Web report designer written in Razor pages (.NET 6)
I run the Web report designer on Linux (docker/kubernetes) and on Windows (IIS)

The properties of two textBoxes (marked above textBox40 and textBox42) are like below

on Linux

The report preview looks like this

In the preview above, the word "przekroczenia" (exceedance in Polish) has been cut off but should be moved to a new line.

After exporting the report to XLSX

In the preview above, after exporting the report to XLSX, the letters are cut off.

After exporting the same report to PDF, it looks like this

In the preview above, after exporting the report to PDF, there is no spaces and there is no text wrapping.

on Windows

The report preview looks like this

In the preview above, everything looks good.

After exporting the report to XLSX

In the preview above, after exporting the report to XLSX, the letters are cut off.

After exporting the same report to PDF, it looks like this

In the preview above, everything looks good.

My appsetting.json file contains

"telerikReporting": {
  "extensions": [
    {
      "name": "PDF",
      "parameters": [
        {
          "name": "FontEmbedding",
          "value": "None"
        }
      ]
    }
  ]
}

I have tried all options related to FontEmbeddingFull, Subset, None and the result is always the same.
The only thing that changes is the PDF file size (and this is logical).

What should I set in order to fix all errors.
Report exported to XLSX on Windows and Linux looks the same badly. The letters are cut off.
Report exported to PDF on Linux looks very bad. There is no spaces and there is no text wrapping.
Report exported to PDF on Windows looks good.

Regards!

OPTeam SA
Top achievements
Rank 1
Iron
 updated answer on 18 Oct 2023
1 answer
142 views

Hi,

Our ERP System uses Telerik Reports and we use the standalone report designer as part of the package.

We're running in to an issue where computers that use DPI scaling, i.e. increasing the text size to 125% on the windows side is leading to a lot of extra white space in the report.

I wanted to see if there's any parameters that can be used in the Standalone Report Designer to enable DPI scaling.

Thank you.

Momchil
Telerik team
 answered on 18 Oct 2023
1 answer
199 views

Hi, I have stored procedure which is splitted on 2 parts.

CREATE PROCEDURE dbo.MyProcedure
@ReportPart smallint
AS
IF @ReportPart = 0
BEGIN
SELECT ColumnPart0Id, ColumnPart0Name, ColumnPart0Code
FROM Table
END
ELSE IF @ReportPart = 1
BEGIN
SELECT ColumnPart1Address, ColumnPart1PostCode, ColumnPart1Contractor
FROM Table
END


When I execute procedure in Telerik Report Designer (SQL Data Source) with

EXEC dbo.MyProcedure
@ReportPart = 0

everything is ok, but after execute query

EXEC dbo.MyProcedure
@ReportPart = 1

I have error "Can't setup column 'ColumnPart0Name'. This value violates limit MaxLength of this column".

It's weird because in @ReportPart = 1 there isn't any column name like ColumnPart0Name, it exists in first "IF" .

Is it bug?

Query works fine in SSMS.

 

Wojciech
Top achievements
Rank 1
Iron
 answered on 18 Oct 2023
1 answer
182 views
Hi all, We have following requirements: 
1. We have an angular application which is going to load .trdp report from report API hosted inside the web app. 
2. These .trdp file have many controls which needs dynamic and custom binding.
3. Data should be pulled from OData API
4. Data pulled from point 3 should be conditionally bind to the different controls in .trdp file in report rest API.

We are facing the following challenges.
1. How to load .trdp file in a programmatic way at the reporting API.
2. How to bind the data to the controls after loading programmatic instance of .trdp report.
3. How to bind the loaded report object in html way in report viewer in Angular.

There are ways to do same in .NET desktop application but how to do same in Web, please advise.

1 answer
182 views
Hi, can we change language of Telerik report preview tool. Like "next page" can be changed to another language.
Dimitar
Telerik team
 answered on 16 Oct 2023
1 answer
106 views

I'm trying in VS2019 the "Telerik Reporting REST Service" project template, however when trying to reach http://localhost:<port>/api/reports
we got the message:

Multiple actions were found that match the request.

Are some suggestions in the forums about how to fix this (none of those worked for me), Besides I would expect an empty project template working.

Any ideas?

 

Thank you.

Momchil
Telerik team
 answered on 16 Oct 2023
1 answer
256 views

Hi,

I would like to use/not use a parameter as a filter depending on the user entered value. If it's 0 then I want to ignore the filter.

Here is my configuration in report designer.

 

Essentially I want to achieve this:

SQL if parameter  aualtranpstper= 0 then 

pst_yer = parameter aualtranpstyer

 

SQL if parameter  aualtranpstper<>0

pst_yer = parameter aualtranpstyer and pst_per = parameter aualtranpstper

 

What should my value column in this screen look like?

I posted the same question after reading here https://www.telerik.com/forums/conditional-filtering-and-to-skip-filter-on-empty-report-parameters#205578 but thought it better to create new question.

Thanks for your help.

 

AW

 

 

 

 


 

 

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
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?