Issue converting .rpt file to .trdp file using Telerik Standalone Report Wizard

[John]

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]

Hello John,

Is the data previewable in the last step of the SqlDataSource Wizard? If yes, then there should be no problem with the data and you should be able to use the SqlDataSource Component with any of the data items.

If there is a problem with the data, please attach a trace listener to the Standalone Report Designer, reproduce the problem, and attach the log to your reply so that we can check the internal stack trace - Standalone Report Designer Problems Troubleshooting - Telerik Reporting.

I see in the image that the report consists of a static text header - "Input Report(English)" and a couple of the SubReport items. Each SubReport internally uses a normal TRDP/TRDX report, please make sure that you have also converted those from RPT.

Additionally, the SubReport item itself is a data item and you can assign the SqlDataSource component to its DataSource property in order to pass the data to it from the main report. You may refer to The property DataSource of the SubReport item for more information on this topic.

Please make sure that there is no problem with the data by previewing it on the last page of the SqlDataSource Wizard, then verify that all SubReports point to valid TRDP/TRDX reports and that the SqlDataSource component with the data is assigned to them so that they have access to that data.

In case you need further assistance, please send me a trace log plus the report definition in TRDP/TRDX format(plus the definitions of the SubReports' reports).

Regards,
Dimitar
Progress Telerik

[John]

Hi Dimitar,

We're reviewing the data from the SqlDataSource Wizard. We'll let you know if we have any doubts.

[John]

Dimitar,

We have a header and the details consist of many subreports. Can we provide a separate data source for each subreport? because we need to display the values in the subreports getting the data from different select queries.

We are not sure about specifying the data source for each subreport. 

Can you help us with this?

[Dimitar]

Hi John,

Yes, the SubReport item exposes a DataSource property to which you may assign a data source component. This will allow you to use a separate data source for each SubReport item in the main report.

For more information on this topic, you may refer to the SubReport Report Item at a Glance - Telerik Reporting article.

[John]

Hi Dimitar,

I created a sub report and set the data source. And included a textbox in the sub report. However, I'm having issue with binding the textbox's data field value. Also I'm unable to see the data source fields in the textbox expression.

Please guide us on how to get database field value in textbox.

[Dimitar]

Hi John,

The data source component that is assigned to the DataSource property of the SubReport item will be applied only at runtime.

For design purposes, you may open the report that will be used by the subreport item in the designer, and then you may create and assign a data source component to it. This will allow you to see the available fields in the Data Explorer when designing the report.

For more information on the topic, please visit the Working With Data at Design Time Explained - Telerik Reporting article.

Note that the data structure should be the same as the data source component in the main report that will be provided to the subreport when the main report is previewed so that the expressions are executed successfully.

[John]

Hello Dimitar,

My data source consists of six rows.  Different scenario ids (one of the table's column) are present in each of the six rows. I need to show the sub report's crossbar based on the scenario_id. I've attached the screenshot of the data retrieved from the select query to this comment.(Screenshot 2024-08-07 044906.png)

For eg: If I have 6 rows(6 scenario ids), then need to show 6 in separate crossbar.

I can only see the first row repeated up to six crossbars at this time. I've attached the screenshot to this comment.(Screenshot 2024-08-07 044449.png)

[Dimitar]

Hi John,

To display a different scenario ID for each SubReport instance, you may create a report parameter in the report used as an inner report by the SubReport item that will take the current scenario ID value through the = Fields.ScenarioID field in the main report, and filter the data in the crosstab accordingly using the report parameter value - Using Report Parameters in Expressions Explained - Telerik Reporting:

I would recommend having a look at the Create Master-Detail Reports by Using SubReport Items - Telerik Reporting KB article where a similar scenario is implemented.

In case you need further assistance, please send me copies of your reports and sample data, and I will prepare a sample solution and send it to you with my reply.

[John]

Hi Dimitar,

Thanks for the reply. I have created the report successfully using the standalone reporting tool.

Currently, I'm trying to load the report using the report viewer for a WPF application. However I'm facing issue with the report viewer.

I'm using the Telerik Reporting version 18.0. I included the error message with this reply.

Can you help us on how to load a report using the WPF report viewer programmatically(C#)?

Is it possible for you to share any example project?

[Dimitar]

Hi John, 

I recommend loading WPF Report Viewer in the XAML - Integrating the WPF Report Viewer in a WPF .NET Framework - Telerik Reporting, and then setting only the ReportSource property of the viewer in the C# code - Setting ReportSource to ReportViewers Explained - Telerik Reporting.

You may find sample projects with the WPF Report Viewer in the installation folder of the product, for example - C:\Program Files (x86)\Progress\Telerik Reporting 2024 Q3\Examples\CSharp.

[John]

Hi Dimitar,

We tried to load WPF report viewer in the XAML. However We are facing a DLL issue related to the  "Telerik.Reporting.ReportViewer".
We noticed that, For WPF application we used Telerik WPF version "2023.3.1010.40 " and the telerik reporting version is "18.0.24.305". 

Is the version mismatch is the root cause of the DLL issue we are facing right now?

can you help us to resolve the issue?

 

[Momchil]

Hi John,

I believe you are correct, the 18.0.24.305 version of the WPF Report Viewer is built with Telerik UI Controls for WPF version 2024.1.130.40 and is not guaranteed to work with earlier versions, such as 2023.3.1010.40. I suggest upgrading Telerik UI for WPF to 2024.1.130.40 or later but if you choose a newer version, ensure you have the necessary binding redirects.

Side note, if you are using Telerik UI for WPF only for the WPF Report Viewer, you can reference the Telerik UI for WPF assemblies available with Telerik Reporting installation. They are internally unlocked for the WPF Report Viewer but can only be used with the report viewer. The .NET Framework assemblies containing Telerik UI for WPF are located in "%programfiles(x86)%\Progress\Telerik Reporting <VERSION>\Bin\WpfViewerDependencies\Framework".

[John]

Hi Momchil,

I have updated the "Telerik UI Controls for WPF version"  to 2024.1.303.40.  I created a report using the Standalone Telerik Reporting. And I tried to open the created report using the report viewer (WPF C# application). 

I followed the article https://docs.telerik.com/reporting/embedding-reports/display-reports-in-applications/wpf-application/how-to-add-report-viewer-to-a-wpf-.net-framework-project

I added the necessary Dlls to the project as mentioned in the article. But still not able to see the report viewer and the report in the screen. 

My question:

1) While creating the report, I added the database source in the Standalone Telerik Reporting. Do I need to specify the data source programmatically?

I added the screenshots of Dlls and Xaml using in the project to this reply. Can you please help on this?

[Momchil]

Hi John,

If I understand correctly, you added the viewer using the built-in item template but you cannot see it at all when you run the application. If that is the case, I do not think the issue is related to the data source of the report as the report will not be processed if the viewer is not working. Thus, specifying the data source programmatically should not be necessary unless you used a custom object data source in the Standalone Report Designer. 

Do you see any runtime errors or errors from the WPF Report Viewer item template log? Creating a Trace Listener log can help us see potential issues. Additionally, since you upgraded Telerik UI for WPF to 2024.1.303.40 and assuming you are still using the 18.0.24.305 Reporting version, ensure the necessary binding redirects are applied in the application configuration file.

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Telerik.Windows.Controls" culture="neutral" publicKeyToken="5803cfa389c90ce7"/>
        <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="2024.1.303.40"/>
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Telerik.Windows.Controls.Input" culture="neutral" publicKeyToken="5803cfa389c90ce7"/>
        <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="2024.1.303.40"/>
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Telerik.Windows.Controls.Navigation" culture="neutral" publicKeyToken="5803cfa389c90ce7"/>
        <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="2024.1.303.40"/>
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
</configuration>

Last but not least, if the issue persists, consider sharing a runnable sample that replicates the issue so I can test it locally. 

[John]

Hi Momchil,

Now, I can see the report viewer. However, we are facing issues with the report.  I added the screenshot to this reply.

I added the necessary binding redirects in the application configuration file. Still facing the issue to load the report.

Can you please help us on this?

[Momchil]

Hello John,

Thank you for the new screenshot.

I see the viewer opens successfully and the report it resolved.

The error messages suggest the report is using a named connection string which cannot be resolved in the WPF application. Since you created the report with the Standalone Report Designer, it is possible the designer added the data connection to its configuration and saved only the alias in the report definition which is more secure.

However, if this data connection is not present in the configuration of the WPF application, the alias will be invalid when the report is processed in the context of the application. To resolve the issue, you can add the data connection in the config file of the application.

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <connectionStrings>
    <add name="AliasUsedInTheReport"
        connectionString="ActualConnectionString"
        providerName="TheDataProvider" />
  </connectionStrings>
</configuration>

You can check the data connections in your Standalone Report Designer by going to its Options page.

I hope this helps.

[John]

Hi Momchil,

Now we are able to see the report using the report viewer. Thanks for the guidance.

Right now, we are facing issue to pass the parameter from a WPF C# Project to the Telerik Report.

I added the screenshot to this reply.  please have a look.

What we did in the Standalone Report Tool

1) We created a report and added a parameter called "Name". 

2) We added the value as "= Parameters.Name.Value". 

3) On the report, we added a subreport and on top of that subreport we added a textbox.

4) Using the expression we gave the value as "= Parameters.Name.Value" to the textbox.

What we did programmatically(C#)

1)  For testing purpose, we statically specified the file path.

2) We Created the report parameter called "Name".

3) Finally, Refreshed the report to display it.

 

Please help us to know what we missed to do. Also please help us to know "how to pass a dynamic Data Source from C# to Telerik report".

[Momchil]

Hi John,

I am glad to hear you were able to preview the report in the viewer.

Regarding the issue with the report parameter. Can you elaborate on the issue you experienced? Is the parameter value missing from the main report? 

Looking at the report definition and the C# code used to pass the parameter value, it seems that the main report's parameter is set up correctly and should work as expected. However, there are two issues I see with the layout of the report.

1. The subreport and the textbox inside the main report overlap which is not recommended. The subreport may be hiding the textbox and preventing you from seeing it.

2. It appears the value of the "Name" parameter is passed correctly to the subreport but the ReportSource property of the subreport item is blank. Therefore, the subreport will not load any report.

If you need to use the parameter to reference a specific report, I suggest writing an expression for the report source.

That said, let me try to address your question about passing a dynamic data source from C# code to a report.

There are different ways you can achieve that. You can set up an object data source in the report, allowing the report to call the necessary code for data retrieval. The following articles should help if you choose this option.

• ObjectDataSource Component
• Connecting the ObjectDataSource component to a Data Source
• Using Parameters with the ObjectDataSource Component

Another option is to modify the report at runtime before you pass it to the viewer. The following example demonstrates how you can create an instance from your TRDP report and adjust the data sources programmatically.

Edit the Report Data Source Components at Runtime

Then, you can pass the final InstanceReportSource to your WPF report viewer and the modified report definition should appear.

I hope this answers your questions and helps you move forward with your Reporting integration.
Let me know if any other questions come up.

[John]

Hi Momchil,

We have doubt on the below items

"How to load data bytes to Telerik Reporting". We need to pass parameter to the reporting tool at runtime also.  Can you help us on this?

[Momchil]

Hi John,

By load data bytes to Telerik Reporting, do you mean that you would like to download the report as а byte array from some remote location and preview it in the viewer? If that is the case, you can save the report somewhere locally and pass an URI report source to the viewer, or you can use the data stream to create an instance of the report (see Unpackaging), wrap it in an instance report source, and provide that to the viewer.

Regarding the question about passing parameters. In some of the code snippets from our previous messages, you already pass parameters to the viewer's report source so I am assuming that you want to add new parameters to the report dynamically. Is this correct? The following articles should help in this scenario.

• Add a Report Parameter programmatically
• Managing Reports with code
• Access items from the calling application

I hope this helps.

[John]

Momchil,

In the database, the report is saved as byte array. We need to preview the byte array in the viewer.

"If that is the case, you can save the report somewhere locally and pass an URI report source to the viewer, or you can use the data stream to create an instance of the report (see Unpackaging), wrap it in an instance report source, and provide that to the viewer."

As you recommend, Is the mentioned approach is best for our requirement? Is there a more efficient way to implement this?

[Momchil]

Hi John,

It depends on your requirements.
Since the reports are stored as a byte array in your database, both options I mentioned above should work.

To me, the option with the instance report source seems easier to implement but it may not be the best if you want to reduce traffic to your SQL database, especially if you have large reports with many embedded images and/or inline data sources.

Perhaps you can implement a report definition cache of sorts in which you download a report once, save the TRDP/TRDX/TRBP file in a desired location, and update it only if it has been modified since the last time you downloaded it from the database. This way, you will only need to query the last modified date and not the entire report.

Still, I cannot claim that this is the best option available so I encourage you to investigate other ideas and choose what is best for you. When you are working with declarative report definitions, the main report sources you can use are the UriReportSource, InstanceReportSource, and the XmlReportSource. How you work with the report definition files before they are fed to the viewer however is up to you.

[John]

Hi Momchil,

We have a doubt. For a report contains two sub report and two data sources. How can we map the database data to the textboxes in the sub reports? How to assign the data source to sub reports. Can you please guide us on this?

[Momchil]

Hi John,

To assign each data source to the corresponding subreport, I recommend using the DataSource property of the SubReport item. This will replace the data sources from the actual reports referenced by the SubReport items. Thus, to make the process of designing the child reports easier, you can copy the intended data sources from the parent report and you will see the correct fields in the expression editor.

Also, if you want to bind the subreports to a specific parent data scope, such as a group from the main report or a collection field, you can add a binding that changes the subreport item's data source property to the ReportItem.DataObject or the specific field.

[John]

Hi Momchil,

We are currently facing issue with PDF export. The table report cuts off the far right portion of the table and puts it on new paper. But i want all the columns fit in same page. Can you help us on this issue? We attached the screenshot in this reply.

Also can you suggest how to use a report parameter to a SQL query?

[Momchil]

Hello John,

Indeed, in a physical page format such as the PDF export items that are too wide for the current page size cause horizontal page breaks.

The general way to deal with such scenarios is to adjust the page settings (paper size, margins, etc.) and reduce the width of the problematic item(s) until everything fits on a single page. You do not need to export to PDF each time either, you can switch to the designer's print preview mode to get a good idea of how the report will look once it is exported to PDF.

Regarding how you can use a report parameter in an SQL query. I suggest going through the Using Parameters with the SqlDataSource Component article because there are different ways you need to set up your select statement depending on the data provider you are using. The examples in the article are in code but the configuration of the SQL data source's properties is the same if you use one of the report designers.

[John]

Hello Momchil,

We are facing an error "{"Cannot find resource named 'Telerik.Windows.Controls.GridView.GridViewCell'. Resource names are case sensitive."}", when we tried to upgrade the Telerik WPF version from 2023.3.1010.40 to 2024.1.130.40. 

Additional Details

We are using Telerik Reporting of version "18.0.24.305" for our application, and the solution consist of multiple projects.

Attached the screenshot of the error with this reply.

Can you please guide us to resolve the issue?

[Momchil]

Hi John,

Indeed, the WPF viewer from Telerik Reporting version 18.0.24.305 depends on Telerik UI for WPF version 2024.1.130.40 (see 2024 Q1 18.0.24.305) so the assembly versions should match.

However, we have seen this error before when the viewer's XAML files are not merged into the Application.xaml. Please, ensure the viewer's styles are set (see Setting the Theme of WPF Report Viewer) and that the Telerik.ReportViewer.Wpf.Themes assembly is not from a different Reporting version.

Still, if the above does not help, consider sending a runnable sample that contains the issue and I will troubleshoot it on my end.

[John]

Hi Momchil,

We fixed the version upgrade issue. Thanks for your guidance.

We need help on "integrate the license key with a WPF C# project".  Because we have an active license maintenance with Telerik. We are getting a trail message on the application. we need to stop showing that trial popup.

We are using Telerik Reporting and Telerik WPF controls. How to add the license key to our project for both. Can you please guide us on this?

[Momchil]

Hello John,

Glad to hear you upgraded successfully.

My understanding from earlier was that you upgraded Telerik Reporting and Telerik UI for WPF to their corresponding 2024 Q1 versions. However, this release does not have the new licensing model and should not show trial messages, provided you have installed the DEV versions. Am I correct in assuming that you have now upgraded to 2025 Q1?

In this case, if you have an active DEV license for Telerik Reporting and Telerik UI for WPF, you can activate both products in a similar fashion because of the uniform licensing mechanism. You can download your license key and find instructions for activating it in your account's License Keys page.

For your convenience, here are the corresponding documentation articles for Telerik Reporting and Telerik UI for WPF.

• Learn how to set up the Telerik Reporting License Key. - Telerik Reporting
• Installing License Key - Telerik UI for WPF

[John]

Hello Momchil,

We are currently using WPF trial version 2024.1.130.45. And we tried to integrate the license key for Telerik UI for WPF with our application, to not get the trial popup in our application. however we are unable to make it work .

1) Can you please confirm whether the license key integrations works only on the versions from 2025 Q1 or Earlier versions of Telerik UI for WPF also supports the license key? (Issue faced: Telerik.Windows.Licensing namespace is missing on the 2024.1.130.45)

2) We are unable to find the dev version of 2024.1.130.45 from the Telerik official site? Can you share the dev msi for Telerik UI for WPF 2024.1.130.45?

[Dimitar]

Hello John,

Thank you for the provided information about your scenario!

Regarding the first question, the license key integrations were introduced with the 2025 Q1 releases of the Telerik products. Since you are using a version from 2024, you can upgrade to a Developer license in the old manner, see the Upgrading Telerik UI Trial to Developer License - Telerik UI for WPF article for details.

Regarding the second question, I am unable to share the MSI here as this is a public forum thread. I inspected your account and confirmed that you do have a developer license for the Telerik UI for WPF product. Considering this, you should be able to download the DEV MSI from the https://www.telerik.com/account/downloads/product-download?product=RCWPF URL assuming that you are logged in with this account.

In case you need further assistance, please contact your sales lead or open up a support ticket so that the colleagues from the Telerik UI for WPF team can assist you with upgrading to the DEV version of the product.