Telerik Forums
Reporting Forum
1 answer
556 views
I have multiple tables that I would like to join together based on e.g. CustomerID. I know I could use a report parameter, which I already am using for the date. What I want to do is filter by the date report parameter, but align the table rows by the Customer ID in each table so it looks like a seamless report. Can I do this through binding?? If so, how?
Todor
Telerik team
 answered on 15 Jun 2021
1 answer
1.0K+ views

Goal: Change a trdx's web services data sources from using web service requests to using inline data strings and then render a PDF.

The trdx was created using the Invoice Report Wizard and has two data sources (one for header and one for detail). Both actually call the same web service method but use different data selectors ($.result and $.result.MemberReceiptDetails). I need to replace these calls with inline json strings (again, they'll be identical) and remove the parameters.  I see the Report class has a DataSource property but how does this relate to multiple datasources?.

 

            XmlReportSource reportSource = new XmlReportSource();

            Report report = GetReportFromResources("Member.DuesReceipt.trdx");

            //Change data sources here

            StringBuilder builder = new StringBuilder();
            using (System.Xml.XmlWriter xmlWriter = System.Xml.XmlWriter.Create(builder))
            {
                Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer =
                    new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();

                xmlSerializer.Serialize(xmlWriter, report);
            }

            reportSource.Xml = builder.ToString();

            var reportProcessor = new ReportProcessor();
            RenderingResult result = reportProcessor.RenderReport("PDF", reportSource, null);

Dimitar
Telerik team
 answered on 15 Jun 2021
1 answer
776 views

Please refer the snapshot attached.

The telerikReportViewer.js file is not loading properly. I checked the path, its linked correctly (Refer Snapshot : telerikReportViewer1.png)

But still my reports are not loading properly.

It looks like its not about the file path, something else seems to be causing this error.

Please help.

Plamen Mitrev
Telerik team
 answered on 14 Jun 2021
1 answer
265 views

Hello,

I am trying to view a working example of the tr-report viewer, but it does not appear the rest api for the example angular report viewer is working. This is what happens when I run the example application using this serviceUrl: https://demos.telerik.com/reporting/api/reports/

Plamen Mitrev
Telerik team
 answered on 14 Jun 2021
1 answer
251 views

Goal: I want to create a .NET Standard class library with trdx reports so that I can deploy it with projects on various platforms.

I added a trdx file to the new library and made it an embedded resource but could not access it. I then stepped back, simplified, and added the report to a .NET Framework 4.7 Windows Forms app, again as an embedded resource.

        public Form1()
        {
            InitializeComponent();

            var a = System.Reflection.Assembly
                .GetExecutingAssembly()
                .GetManifestResourceStream("Reports.Report1.trdx");

            TypeReportSource reportSource = new TypeReportSource();
            reportSource.TypeName = "Reports.Report1.trdx";

            var reportProcessor = new ReportProcessor();
            RenderingResult result = reportProcessor.RenderReport("PDF", reportSource, null);
        }

a is populated (as a check) but rendering results in: {"Invalid report type"}

Neil N
Top achievements
Rank 2
Iron
Iron
Veteran
 answered on 11 Jun 2021
1 answer
621 views
As an example, I have a report with two report parameters. The first is year, the second is month. If I have AutoRefresh on, it reruns the query if I pick year OR month. So I disabled the AutoRefresh on the first parameter, so it would only re-run the query after setting the second parameter. However, when I do this, the second parameter does not AutoRefresh, and I have a Preview button.  Is this the way it was designed, or is something wrong??
Todor
Telerik team
 answered on 11 Jun 2021
1 answer
517 views

I have attached the error of the code while trying to integrate it into Core. Image of Report 1 &2 is the actual code, and Error image 3, 4, 5 is the result of the code error.

 

Thanks

Plamen Mitrev
Telerik team
 answered on 10 Jun 2021
2 answers
416 views

Hi!

My datasource includes one field which is a comma separated list of items. What I like to do is display these items in three columns inside my report.

Items: "item1, item2, item3, item4, item5, ... , itemX"
Displayed as

item1     item4    item7
item2    item5    item8
item3    item6    item9

How can I achieve this?

Regards
Heiko

Plamen Mitrev
Telerik team
 answered on 09 Jun 2021
1 answer
225 views

hi,

what is we have to do to distribute Telerik Reporting assemblies and merge them into a single
EXE or DLL that can be used by the custom application.

thx in advance,

Regards

Todor
Telerik team
 answered on 09 Jun 2021
2 answers
378 views

I am using Telerik reporting in a VB.net app.  The reports each preview correctly, but if I print directly to a printer, it comes up blank.  To PDF it saves a blank file.  To a physical printer, it goes through the motions with the driver, but nothing is actually printed.

Telerik.Reporting.dll is version 15.0.21.326.

What am I missing?

code below:

Public Sub SaveReport(ByVal myreport As Telerik.Reporting.Report, filename As String)
       
        Dim reportProcessor As Telerik.Reporting.Processing.ReportProcessor = New Telerik.Reporting.Processing.ReportProcessor()
        Dim instanceReportSource As Telerik.Reporting.InstanceReportSource = New Telerik.Reporting.InstanceReportSource()
        instanceReportSource.ReportDocument = myreport
        Dim renderingResult As Telerik.Reporting.Processing.RenderingResult = reportProcessor.RenderReport("PDF", instanceReportSource, Nothing)
        Dim fs As FileStream = New FileStream(filename, FileMode.Create)
        fs.Write(renderingResult.DocumentBytes, 0, renderingResult.DocumentBytes.Length)
        fs.Close()
    End Sub

 

Public Sub PrintReport(ByVal myreport As Telerik.Reporting.Report, ByVal Copies As Integer)
        strModErr = "Module1_PrintReport"
        Dim printerSettings As PrinterSettings = New PrinterSettings()
        Dim printController As PrintController = New StandardPrintController()
        Dim reportProcessor As ReportProcessor = New ReportProcessor()
        Dim instanceReportSource As Telerik.Reporting.InstanceReportSource = New Telerik.Reporting.InstanceReportSource()

        Try
            instanceReportSource.ReportDocument = myreport
            printerSettings.PrinterName = My.Settings.DriverLogPrinter
            printerSettings.Copies = Copies
            reportProcessor.PrintController = printController
            reportProcessor.PrintReport(instanceReportSource, printerSettings)
        Catch ex As Exception
            WriteErrorToLog(Err.Number, strModErr + " - " + Err.Description)
            Dim inner As Exception = ex.InnerException
            Do
                If inner IsNot Nothing Then
                    WriteErrorToLog(666, inner.GetType().Name + ": " + inner.Message)
                    inner = inner.InnerException
                End If
            Loop While inner IsNot Nothing

        End Try
    End Sub
   
Phil
Top achievements
Rank 1
Iron
 answered on 09 Jun 2021
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?