Telerik Forums
Reporting Forum
0 answers
1 view

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
8 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
12 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
11 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
12 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
4 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
19 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
9 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
2 answers
16 views
currently we are using webservice datasource to generate a report but i want to change this datasource from webservicedatasource to jsondatasource, when i manually put the json in inline, its working perfectly but how to pass the data from programatically , as of now we are using telerik.reportserver.httpclient dll and createdocumentdata model to send an data to report but i could not see any fields available in the model to accept json data. Anyone help on this and its a large report it has lot of tables , list ,fields etc
1 answer
19 views

We have a JSON dataset (attached) where one of the nodes is a list of products. We are displaying these products in a table in the detail section. This table has the corresponding ProductList Datasource and has 3 columns: "UP", "Total", "Net UP".  We obtain the "UP" and "Total" directly from the DataSource (Fields.[@UP], Fields.[@Total]). To obtain the "Net UP" we need to check all Discounts nodes in the same line that [@Type]= "Comercial" , take the [@Rate] and multiply it with the Fields.[@UP] of that line.

We are trying to do this inserting a table to which we have bound its DataSource to the Fields.Discounts.Discount field in the "Net UP" column. With this we can obtain the [@Rate] of the discount but the problem here is that we can not address the Fields.[@UP] because it is in another context.

Do you have any idea how we can achieve that?

Top users last month
Dominik
Top achievements
Rank 1
Giuliano
Top achievements
Rank 1
Dominic
Top achievements
Rank 1
Glendys
Top achievements
Rank 1
Iron
NoobMaster
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?