Telerik Forums
Reporting Forum
1 answer
335 views

We have a custom report screen that uses multiple reporting frameworks to render reports as files (typically Excel). The available reports are loaded dynamically at runtime, the user picks a report which retrieves and displays the report parameters for the users to enter values, and then the report can be rendered to the file type that they choose.

We will be creating single reports (.trdp files) and report books (.trbp files) and uploading those onto the server for use with this screen. We are currently using the R1 2023 Reporting framework. Our application is written in c# and uses .NET Framework 4.8.

I have almost everything working with the Telerik framework but cannot find anywhere to create a ReportBook object from a .trbp file. The closest I found was this forum post (https://www.telerik.com/forums/reportbook-by-path-name)and this article on Deserializing from XML (https://docs.telerik.com/reporting/embedding-reports/program-the-report-definition/serialize-report-definition-in-xml). This does not work and I assume things have totally changed given the post was over 10 years old.

Using the code below gives the exception "Data at the root level is invalid. Line 1, position 1." The .trbp file that we are attempting to load was designed using the Telerik Standalone Report Designer.

var reportBook = new Telerik.Reporting.ReportBook();

using (System.IO.FileStream stream = new System.IO.FileStream(reportPath, System.IO.FileMode.Open))
{
    Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();                    
    reportBook = (Telerik.Reporting.ReportBook)xmlSerializer.Deserialize(stream);
}

Is it possible to load a .trbp file into a ReportBook object? If so, how?

Thanks,

Jason

1 answer
158 views

How can I put the x-axis 0 exactly at the origin?

I am using the Telerik Reporting Designer inside Visual Studio 2022

Platform:

Telerik Reporting R3 2022, using Telerik for .Net

.Net Framework 4.5.2

Visual Studio 2022, 64 bit

 

Todor
Telerik team
 answered on 24 May 2023
1 answer
167 views

Hello,

we've upgraded to VS2022 and .NET 7.

The reports are giving us a lot of problems, it looks like we have too rebuild them in the Standalone Report Designer. Import fails

The default Telerik WPF ReportViewer has this


<tr:ReportViewer Grid.Row="0" x:Name="ReportViewer1" HorizontalAlignment="Stretch" EnableAccessibility="true">
        <tr:ReportViewer.ReportSource>
		<telerikReporting:UriReportSource Uri=""/>
	</tr:ReportViewer.ReportSource>
</tr:ReportViewer>

 

 

Can we change the Uri programmatically in a MVVM project? Something like


<tr:ReportViewer Grid.Row="0" x:Name="ReportViewer1" HorizontalAlignment="Stretch" EnableAccessibility="true">
    <tr:ReportViewer.ReportSource>
	<telerikReporting:UriReportSource Uri="{Binding ReportSource}"/>
    </tr:ReportViewer.ReportSource>
</tr:ReportViewer>


where reportsource is ExampleReport.trdp

 

Jeroen

Jeroen
Top achievements
Rank 1
Iron
Iron
 answered on 23 May 2023
1 answer
547 views

We have a JSON dataset where one of the nodes is a list of products. We have generated a DataSource based on this product list. Within each product node, there is an AdditionalInfos node, which is a list of data that complements each product. Find example attached.


        "ProductList": {
           "Product": [
          {
            "@Item": "Item1",
            "@BeginDate": "17/05/2023",
            "@Total": 253054.99,
            "AdditionalInfos": {
              "AdditionalInfo": [
                {
                  "@Key": "Vehiculo",
                  "@Value": "MCG02"
                },
                {
                  "@Key": "Terminal",
                  "@Value": "TERMINAL A"
                },
 
              ]
            }
          },
          {
            "@Item": "Item2",
            "@BeginDate": "16/05/2023",
            "@Total": 1234678.12,
            "AdditionalInfos": {
              "AdditionalInfo": [
                {
                  "@Key": "Vehiculo",
                  "@Value": "MCG03"
                },
                {
                  "@Key": "Terminal",
                  "@Value": "TERMINAL B"
                },
 
              ]
            }
          },
          {
            "@Item": "Item3",
            "@BeginDate": "15/05/2023",
            "@Total": 5646548.35,
            "AdditionalInfos": {
              "AdditionalInfo": [
                {
                  "@Key": "Vehiculo",
                  "@Value": "MCG04"
                },
                {
                  "@Key": "Terminal",
                  "@Value": "TERMINAL B"
                },
 
              ]
            }
          },
         ]
	}

Our goal is to generate a graphical representation of the product lines grouped by the AdditionalInfo lines with the Key "Terminal." The desired output should be as follows:

Terminal A
        Item1      17/05/2023       253054.99
Terminal B
        Item2     16/05/2023       1234678.12
Item3     15/05/2023       5646548.35

We would like to know the best approach to achieve this in Telerik Reporting Standalone. Is it possible to generate a DataSource with all the information at the same level and then perform grouping based on it?

Any guidance or examples would be highly appreciated. Thank you in advance for your assistance!

1 answer
691 views

I have a Telerik Reporting project that is included in my web application solution.  When the solution is built using VSBuild in the Azure DevOps pipeline, I caget the following error:

##[error]Inspire.Report\Properties\licenses.licx(1,0): Error LC0003: Unable to resolve type 'Telerik.Reporting.TextBox, Telerik.Reporting, Version=16.1.22.622, Culture=neutral, PublicKeyToken=a9d7983dfcc261be'

I've tried ignoring *.licx files and the report project but I still get this error.  Any advice on how to get a Telerik Reporting project built in an Azure DevOps pipeline?

Justin
Telerik team
 answered on 18 May 2023
2 answers
308 views
I am having trouble integrating the web report designer into my react app using instructions in https://docs.telerik.com/reporting/knowledge-base/how-to-use-web-report-designer-in-react-js. 

Looking for help, I downloaded the recommended example for integrating web designer into react apps (https://github.com/telerik/reporting-samples/tree/master/WebReportDesigner%20in%20React%20Application/src).

When loading this example in Visual Studio code, I get a 404 error. I have done a NPM install and NPM start. I am new to react, so may be missing a step?
Shoshanah
Top achievements
Rank 1
Iron
 answered on 18 May 2023
1 answer
168 views
1 answer
457 views

We followed your instructions to make the reports (https://www.youtube.com/watch?v=UF1mL6vzJDs&t=738s). But I have 1 question, how do we decentralize these reports?

For example:
We have 2 reports on 2 html pages, report1.html and report2.html
We have 2 users, user_a and user_b

user_a can only access report1.html
and user_b can only access report2.html

----------------------------------------------------------------------

Microsoft Visual Studio Professional 2022 (64-bit) Framework: .NET 6 Telerik Reporting trial version 17.0.23.118 Telerik HTML5 Report Viewer Page R1 2023

----------------------------------------------------------------------

Please guide how to do the above authorization
Thank you
Momchil
Telerik team
 answered on 16 May 2023
1 answer
169 views

Good Afternoon Telerik Forums,

 

I am having a new issue with one of my reports where it is constantly making new pages of the report with the same information. (Header), (Body) and (Footer). and it persists indefinitely.

 

example

Top Atheletes 2022

Date: April 2022

 

Athlete 1 - 2022

Athelete 2 - 2022

etc..

(Page 1)

 

Top Atheletes 2022

Date: April 2022

 

Athlete 1 - 2022

Athelete 2 - 2022

etc..

 

(Page 2)

 

Top Atheletes 2022

Date: April 2022

 

Athlete 1 - 2022

Athelete 2 - 2022

etc..

 

(Page 3)

 

It finally stops itself at around 68 pages of the same repeated report. How can I just get my one page report instead of endless copies? :P

 

Austin
Top achievements
Rank 2
Iron
Iron
Iron
 answered on 15 May 2023
1 answer
218 views

We have a stored procedure that is supposed to run other stored procedures based on a parameter that gets set by the first stored procedure. However, while everything works fine in the Microsoft SQL Server Management Studio, when the stored procedure is run through the report, the very first if statement is run instead of the correct if statement.

Todor
Telerik team
 answered on 15 May 2023
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?