Telerik Forums
Reporting Forum
1 answer
6 views

 

Support team,

I am exploring a trial of Telerik. I have installed the Reports Server on a remote windows server. and it is running. I have made users in the User Management and given them all the permissions.

In the Telerik Report Designer, running on my local machine, I am trying to Add A Report Server. I entered the server URL from my server, then the local user and pwd.

I get the error "Error while logging into the server. Please check the URL and credentials."

I assume I have the right URL. It came from the setting screen on the reports server. I saw another user's ticket with this issue, from years ago, and it suggested installing Fiddler and sending the logs. I have installed Fiddler, but do not know how to simulate logging into the reports server.

Any help would be appreciated.

Thanks

Amy

Dimitar
Telerik team
 answered on 10 May 2024
0 answers
3 views
I have a scenario where I have multiple components, including tables, panels with textboxes, and charts/graphs. I want to add a page break after a specific panel to ensure that it appears on the new page regardless of the size of the content on the previous page. I do not see any straightforward way to do this, and the keepTogether property doesn't always work.
0 answers
3 views
Hello

I have these rows of data coming from DataSource example is in the attached file image


- Want to do some math expressions of every row like Subtraction(BRUTO - DESCUENTO) and show the value in NETO painted in the pink line and circle for individual rows of data.
- I tried to use the expressions SUM(DOC_UNID_BRUTO) and SUM(DOC_UNID_DESCUENTO) try to get the Total SUM of these fields but are just getting the individual first value.
- And the last thing is I want to do a subtraction of the total of NETO and DESCUENTO in the last bottom right corner
0 answers
3 views
Hello there,

I have this issue when generating my report, it duplicates the number of pages based on the amount of rows of data that my DataSource provides to the Report.
Another detail is the external border when generated from the report but in the preview or the designer doesn't show the border
How I can remove it?

I am using a table wizard connected to the data source (SQL Data Source).

Example in the attached file
Elias
Top achievements
Rank 1
Iron
 asked on 08 May 2024
2 answers
11 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
Iron
 answered on 08 May 2024
1 answer
14 views

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

Dimitar
Telerik team
 answered on 06 May 2024
1 answer
14 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
13 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
17 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
21 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
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?