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 :
Here are our questions :
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 !
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:
<?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>
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?
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
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.
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
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 !
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?