Telerik Forums
Reporting Forum
0 answers
1 view

We converted the .rpt file to .trdp file using Telerik Standalone Report Wizard. The result is as in the screenshot.

But the data is not visible in the report. We are not sure about the reason. Can you help us on the below questions?

1) In our case, we have a table in the database with 3 columns it includes a binary datatype also. Whether this cause the data displaying issue?

2) If so, then to which format we have to convert the binary data?

I have attached the .rpt file.  (Rename .txt to .rpt).

John
Top achievements
Rank 1
 asked on 03 May 2024
0 answers
6 views

Hello Team, I'm trying to implement a User Defined Function to be access by Telerik Reports. Is a simple Replace function.

In Report designer I followed the instructions of copying the dll where the report designer is located. It runs fine using the following expression   TelerikFunctions.Telerik_F.Replace("t").

When I try to run it from an API, It does not return anything.

  • I added the TelerikFunctions.dll to the current project where TelerikReporting.dll is located.
  • I added the following entries on the  appsettings.json  
  •  

"configuration": {
"configSections": {
"section": [
{
"_name": "Telerik.Reporting",
"_type": "Telerik.Reporting.Configuration.ReportingConfigurationSection, Telerik.Reporting",
"_allowLocation": "true",
"_allowDefinition": "Everywhere"
},
{
"_name": "Telerik.ReportDesigner",
"_type": "Telerik.ReportDesigner.Configuration.ReportDesignerConfigurationSection, Telerik.ReportDesigner.Configuration",
"_allowLocation": "true",
"_allowDefinition": "Everywhere"
}
]
},
"telerikReporting": {
"assemblyReferences": [
{
"name": "TelerikFunctions",
"version": "1.0.0.0",
"culture": "neutral",
"publicKeyToken": "null"
}
]
}

I also placed the function in the wwwRoot where the reports are located. But still, it doesn't recognize the function.    

Class Library containing UDF

Carlos
Top achievements
Rank 1
Iron
 asked on 01 May 2024
1 answer
12 views

Hello, we're in the process of migrating from Oracle Reports (since it's no longer supported) and are evaluating Telerik Reporting as a solution. After looking up the the Standalone editor and make a few POC reports, we have a few questions.

For reference :

  • we have ~700 reports that we will migrate over time. They all are "static" reports, meaning that we only want to produce a PDF that will be downloaded by the user at the click of a button.
  • we don't intend to use the Telerik Report Server solution.
  • we want our reports to consume a REST url to get the needed data (which will return a JSON). Which means we probably will have a REST url for each report.

Here are our questions :

  1. What's the difference between the .NET Framework and .NET 6 standalone executables ? Why use one or the other ? Are the report files (.TRDP/.TRDX) produced identical between the two ?
  2. When upgrading Telerik Reporting, we understand that we have to be careful about the version and it's changes. What about the report files ? Do we have to "upgrade" each and every one of them manually each time we upgrade Telerik Reporting ? With ~700 reports, it would be way too much time consuming.
  3. Our development workflow would be the following. Are there any catch we should be aware ? Is it feasible ? 
    1. Create a REST url for the new report
    2. Create the new report with the standalone editor and set it's datasource with the newly created REST url
    3. Push the report on a custom report server
    4. Implement the call to the report in our application

  4. Lastly, what's the best practice for the report versioning ? We'd like to use a GIT to store our report files and show diffs between each revision. I understand I would not be possible with a .TRDP since it's an archive, so should we save and store our report file as .TRDX to achieve this ?

Thanks a lot for your help !

1 answer
12 views

I'm relatively new to the Standalone Report Designer, so I apologize if this is expected behavior. I'm connecting to Postgres and have everything set up correctly (AFAIK). If I open the .NET Report Designer via the EXE, the data connection initializes and I get data. However, if I click on a TRDP file to open the designer, the data connection doesn't initialize and I get an "Unable to establish a connection to the database" message with inner exception "Cannot load type for DbProviderTypeName "Npgsql.NpgsqlFactory". Why would opening the EXE directly be any different from opening via TRDP? This feels like a bug, but there may some documentation I just haven't made it to yet.

My current setup:

  • Standalone Report Designer v18.0.24.305
  • Npgsql v6.0.10
  • Npgsql.dll exists in the same directory as Telerik.ReportDesigner.Net.exe
  • Connection string and assembly reference added to Telerik.ReportDesigner.Net.dll.config
  • config file snippet:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <connectionStrings>
        <clear />
        <add name="Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString" connectionString="Data Source=No Local Servers Found!;Initial Catalog=AdventureWorks;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>
        <add name="{theName}" connectionString="{theConnectionString}" providerName="Npgsql" />
    </connectionStrings>
  
    <Telerik.Reporting>
        <AssemblyReferences>
            <add name="Npgsql" />
        </AssemblyReferences>
    </Telerik.Reporting>
</configuration>

1 answer
14 views

In https://docs.telerik.com/reporting/getting-started/first-steps-designing#step-2-create-the-sample-report in step 3, "Click Next to execute the query and the Execute Query... button on the next screen to preview the result. Then, click Finish." (selecting Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString), I get this error message:

Configure SQL Data Source - sqlDataSource1

An error has occurred.
Parameter information cannot be retrieved: Connection
Timeout Expired, The timeout period elapsed while
attempting to consume the pre-login handshake
acknowledgement, This could be because the pre-login
handshake failed or the server was unable to respond back in
time. The duration spent while attempting to connect to this
server was - [Pre-Login] initialization=15089;
handshake=7147;

I have the same problem when trying to create a new connection.

Turning off the Windows Defender firewall for private network and trying again:

Configure SQL Data Source - sqlDataSource3
An error has occurred.
Parameter information cannot be retrieved: Cannot open
database AdventureWorks• requested by the login. The login
failed.
Login failed for user 'xxx•.

Turning on the firewall again, and I still get "The login
failed"

See screenshots.

In the c:\Program Files (x86)\Progress\Telerik Reporting 2024 Q1\Examples\Data\AdventureWorks OLTP\ folder, there is an instawdb.sql that creates and populates the AdventureWorks db. There is no AdventureWorks db in my local SQL server installation. Should I/can I run this script manually?

Or am I doing something else wrong?

 

Todor
Telerik team
 answered on 17 Apr 2024
1 answer
16 views

I have round adhesive labels with a hole in the middle. I would like to design these labels using the report designer. To see the actual shape of my label, I use a background image in Designtime. This way I can place the text boxes around the hole.

How can I hide this background image when printing or previewing?

thanks

Thomas

Momchil
Telerik team
 answered on 17 Apr 2024
1 answer
18 views

Hi there,

Does anyone have an idea why textboxes are not aligning properly in the preview mode?

Telerik Report Designer
Version: 17.2.23.1114
Target Framework: .NET Framework 4

Thank you.

Momchil
Telerik team
 answered on 12 Apr 2024
1 answer
7 views

I have a report catalog of 20 some reports

I pass a parameter to the report cataglog  ie  RanchID 

My parameter shows up on the report catalog header

 

I need to pass that same parameter to the report I launch from the catalog.

Thank you

 

Momchil
Telerik team
 answered on 11 Apr 2024
1 answer
30 views

Hi,

 

We have a requirement to create a report using the "Standalone Report Designer". We just want to open the standalone reporting tool from our desktop application at a button click and allow user to create their own reports. For that we have to pass the content of the report from the desktop application to the standalone tool. We tried to pass the argument in "Process.Start" Method. But we got an error message as in the attached image. 

Could you please help us to work on the standalone Report Designer tool with  C# WPF desktop application?

We want to know how the below items will be work.
1) How to open the standalone report designer programmatically (C#)?
2) How to pass the content from C# to the tool?

Thank You !

1 answer
12 views
When we open a report with Telerik.ReportDesigner.exe we can edit a HTML Text Box in the Design view (like visible in the image here: Overview Design view) and it's also possible to format the text directly by using the In-Place Editor (like here: Editor).

But we miss this WYSIWYG Editor in Telerik.ReportDesigner.Net.exe (v. 18.0.24.130).
We can only edit the text with the HTML tags and it's no longer possible to adjust the style of a single word by selecting the formatting options like bold, italic, font color, etc.

Telerik.ReportDesigner.Net.exe:
Option "Design view" is missing and even if we edit the text directly (not in the Edit Expression Dialog), we always see the HTML tags.



Telerik.ReportDesigner.exe:


Are we missing something or is this not supported anymore by the newest version of the ReportDesigner.Net?
Momchil
Telerik team
 answered on 04 Apr 2024
Top users last month
Mark
Top achievements
Rank 1
Yurii
Top achievements
Rank 1
Leland
Top achievements
Rank 2
Iron
Iron
Iron
Hon
Top achievements
Rank 1
Iron
Deltaohm
Top achievements
Rank 3
Bronze
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?