Telerik Forums
Reporting Forum
2 answers
66 views
Hello,

I created a report using the Standalone Designer (in .trdp format). In the data connection, I configured it to use a shared connection. From within the Designer, everything works fine — I can preview and export to PDF without any issues.

I then created a console project (code shown below) to try exporting the report to PDF.

In the project's configuration file, I added a connection string to use.

However, when executing the following line:


RenderingResult result = reportProcessor.RenderReport("PDF", sourceReportSource, deviceInfo);

I get an error in the Inner Exception:
Keyword not supported: 'host'.

My PostgreSQL connection string is:
"Host=localhost;Port=5432;Database=crp;Username=postgres;Password=****"

But the connection string is correct — it’s exactly the same one I use in the Standalone Designer, where it works without any problem.

If I embed the connection string directly in the report instead of using a shared connection, everything works fine.

Any idea what could be causing this?



        static void Main(string[] args)
        {
            var builder = new ConfigurationBuilder()
                .SetBasePath(Directory.GetCurrentDirectory())
                .AddJsonFile("appsettings.json", optional: false, reloadOnChange: true);

            IConfiguration config = builder.Build();

            string connectionString = config.GetConnectionString("crp");

            string reportName = @"D:\dev\telerik-reporting\reports\report.trdp";

            var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();

            // set any deviceInfo settings if necessary
            var deviceInfo = new System.Collections.Hashtable();
            var sourceReportSource = new Telerik.Reporting.UriReportSource();
            sourceReportSource.Uri = reportName;
          
            sourceReportSource.Parameters.Add("procedure_id", 6);

            RenderingResult result = reportProcessor.RenderReport("PDF", sourceReportSource, deviceInfo);

            if (!result.HasErrors)
            {
                //string fileName = result.DocumentName + "." + result.Extension;
                string fileName = "file.pdf";
                string path = @"D:\";
                //string path = System.IO.Path.GetTempPath();
                string filePath = System.IO.Path.Combine(path, fileName);

                using (System.IO.FileStream fs = new System.IO.FileStream(filePath, System.IO.FileMode.Create))
                {
                    fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
                }
            }

        }


Andrea
Top achievements
Rank 1
Iron
 answered on 24 Jun 2025
1 answer
16 views

Hi All : 

I am working with Crystal Report to Telerik Report conversion. After I have generated a target trdp file, I found that the parameters in crystal report is not installed to the target report.

I have to manually install the parameters back to the

Here is the original Crystal Report with a parameter. 

The target report :  (No parameter can be found in Report Explorer, I have to install the parameter to make the start the preview(

 

 

My Question is : Do I have to manually install the parameter to the target Telerik report after running the conversion tools? 

 

Thank you in advance.

 

Ivet
Telerik team
 answered on 24 Jun 2025
1 answer
23 views

Problem's Summary : 

Section Formula information lost after Crystal report to Telerik report conversion

What has been done :

I have converted a Crystal report having multiple sections , each section has its own background color controlled by Formula :Also I have used formula to control data formatting (color) in the original Crystal Report.

 

After I have used the convert it to Telerik Report.

I found that the formula is missing in the converted Telerik Report, there is no any coloring effect in new report. 

 

My Question is : does the Telerik Crystal Report Converison tools support Formula conversion ?

 

Thank you

Ivet
Telerik team
 answered on 23 Jun 2025
1 answer
27 views
We have a project (.Net Core / Angular) that we've been working on with a client for the past year. It's an application with Telerik reports to which we both built a development / sandbox for user training as well as vetting changes and we also built a production app for final use. The development app database has open access to VPN and I've had no trouble connecting the reports to the SQL server. The second database, for prod, will not work over VPN and must be used on-site.

What we've been able to vet for the prod Azure SQL server:

1) Both the ActiveDirectoryManagedIdentity connection and username / password connections have been vetted as working.
2) Running the project from a VM where the prod server is local the reports work fine.
3) Deploying the app to Azure causes the Telerik reports to fail with the following message:

"Unable to get report parameters. An error has occurred. Unable to establish a connection to the database. Please verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application"

I was able to confirm that if I make this same connection (username and password rather than Managed Identity) my DefaultConnection as well for other data in the application everything works and the data still pulls, it only seems to fail in the Telerik reports.

I've attached an image demonstrating that the named connections match both in the Telerik reports and in my appsettings.Production.json. What I'd like to know is what next steps you would recommend for resolving this. 
1 answer
22 views

We have a ASP.NET MVC application.

We translated the report viewer as per info provided here to german: Localization of the HTML5 ReportViewer Explained - Telerik Reporting

Now the viewer still shows "Page # of #", and also the dropdown for export still shows english file extensions:

How do we translate these elements as well?

 

Kind regards.

Ivet
Telerik team
 answered on 19 Jun 2025
1 answer
22 views
Hi... I have a signature saved in a text sql field, and I want to print it in a telerik report, but I haven't idea of how do it, please help me explicitly
Ivet
Telerik team
 answered on 19 Jun 2025
1 answer
36 views

I am currently using Telerik Reporting version 15.1.21.616 (R2 2021 SP1) in my ASP.NET application. I noticed that the report viewer only exports to the legacy Excel format (.XLS) and there is no option for Excel (.XLSX) in the export formats.

I have checked the Bin directory of my installation, and I do not see the Telerik.Reporting.XlsxRendering.dll assembly, which I understand is required for XLSX export.

Ivet
Telerik team
 answered on 17 Jun 2025
1 answer
32 views

Tried to replicate this with prod clone DB on local, works fine. We are not able to find the cause, please help. Below are some information that can help.

 

templateUrl: '/assets/app/telerikReportViewerTemplate-14.1.20.618.html'

 

Designer that we used the create the report:

Below error is rendered on report:

Getting below in pageContent response:    

"pageContent": "<div><div class=\"sheet page1\" style=\"padding-left:76px;padding-right:76px;padding-top:76px;padding-bottom:76px;width:971px;height:643px;\"><div class=\"layer\"><div title=\"\" class=\"Consolidate s0-f38b615dd534d3fdd4832f\" data-id=\"Consolidate_1\" style=\"position:absolute;overflow:hidden;left:76px;top:76px;width:960px;height:164px;font-family:&quot;Tahoma&quot;;font-size:8pt;color:Red;text-align:start;\" data-search-id=\"_440b124cb22f4a74aec496b5d0b1d897\"><div style=\"position:absolute;top:5px;white-space:pre;left:5px;\">An error has occurred while processing Report 'Consolidate':</div><div style=\"position:absolute;top:18px;white-space:pre;left:5px;\">An error occurred while sending the request.</div><div style=\"position:absolute;top:31px;white-space:pre;left:5px;\">------------- InnerException -------------</div><div style=\"position:absolute;top:44px;white-space:pre;left:5px;\">The response ended prematurely.</div></div></div><div title=\"\" style=\"position:absolute;left:76px;top:76px;width:0px;height:643px;\"></div><div title=\"\" style=\"position:absolute;left:1047px;top:76px;width:0px;height:643px;\"></div><div title=\"\" style=\"position:absolute;left:76px;top:76px;width:971px;height:0px;\"></div><div title=\"\" style=\"position:absolute;left:76px;top:719px;width:971px;height:0px;\"></div></div></div>",

1 answer
33 views

Hi Guys,

mit Blazor Wasm project is working localy.

So i published it on the server and run the ReportViewer: 

Unable to get report parameters. An error has occurred. Type: Telerik.Reporting.ReportSerialization.Current.ReportSerializable`1[Telerik.Reporting.Report]

 

In Browser Dev: 

The Server was a Linux Server with Docker. I installed

sudo apt-get update sudo apt-get install -y libfreetype6 sudo apt-get install -y libfontconfig1

sudo apt-get install libc6-dev sudo apt-get install libgdiplus

 

 

added this: Telerik.Drawing.Skia and

RUN apt-get update \
    && apt-get install -y --allow-unauthenticated \
        libc6-dev \
        libgdiplus \
        libx11-dev \
    && rm -rf /var/lib/apt/lists/*

 

so all packages installed like tutorial and another forum posts i found. I used the demo all same. have someone an idea?

Best Regards

Serkan

 

 

 

Dimitar
Telerik team
 answered on 16 Jun 2025
2 answers
23 views
Updated to the latest Reporting (19.1.25.521) and found that UriReportSource is missing. Is it another namespace? If so which one?
Ivet
Telerik team
 answered on 16 Jun 2025
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
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?