Telerik Forums
Reporting Forum
0 answers
4 views

I have a telerik report that has grouping sections based on a "Page Title"

The first page title is my Cover Page, which just contains a multi-line textbox that has its visibility set to TRUE only if the current group is the cover page

I want the textbox to be automatically centered in the page on rendering of the report without having calculate 11in-(header+footer+margins) and physically set the height of the textbox. Is this possible?

Sample attached

Steve
Top achievements
Rank 1
Iron
 asked on 15 Mar 2024
1 answer
9 views

Compare between non-delete and delete two textbox, just have value difference.

------------original report code

<TextBox Width="1in" Height="0.7cm" Left="0cm" Top="0cm" Value="=AVG(Fields.Actual_downtime_50_last)/AVG(Fields.Actual_runtime_50_last)" Format="{0:P0}" Name="textBox36" StyleName="">

<TextBox Width="1in" Height="0.609cm" Left="0cm" Top="0cm" Value="=(Fields.Actual_downtime_50_last)/&#xD;&#xA;(Fields.Actual_runtime_50_last)" Format="{0:P0}" Name="textBox37" StyleName="">

-----------after deleting value

<TextBox Width="1in" Height="0.7cm" Left="0cm" Top="0cm" Format="{0:P0}" Name="textBox36" StyleName="">

<TextBox Width="1in" Height="0.7cm" Left="0cm" Top="0cm" Format="{0:P0}" Name="textBox36" StyleName="">

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

I want to know how to fix this, because the final value isn't long

 

Momchil
Telerik team
 answered on 15 Mar 2024
4 answers
6 views

I have a report designed for a continuous roll printer using a 4 inch wide paper roll.  The report is 6 inches "wide", but is printed LANDSCAPE, so the axis are flipped, meaning the printed "width" ends up as 4 inches (good) and the printed "height" is 6 inches on the continuous axis.  So far so good, Telerik renders the report and it prints, HOWEVER; I want a page footer section that prints some information at the "bottom" of the label.  When in continuous roll mode Telerik is not honoring the page footer and instead prints this immediately after the detail like a group footer, however; there is no reason why it should not honor this because the report is LANDSCAPE so even on continuous roll paper the footer can be measured against the fixed 4in "width" of the label.  I have attached an image showing what Telerik is doing and what the expected output is.

This appears to me to be a bug in Telerik reporting.

The expected behavior is that the page footer would work normally if the report is landscape because in this case the fixed label width is actually the "height" (4in) of the report and the variable/continuous axis is the "width" (6in).

Any suggestions?

- Albert Boettger

AlbertBoettger
Top achievements
Rank 1
Iron
 answered on 04 Mar 2024
1 answer
25 views

Good morning.

I wanted to address an issue we're running into while trying to post a .Net Core / Angular app with a folder of standalone reports. For some unknown reason these will work fine on my machine, I have a couple dozen built from the Telerik Reporting standalone designer, but it won't work on an Azure VM.

The need to set up an Azure VM occurred to me when I realized that I couldn't update a SQL connection for a report unless the connection returns as valid, which in this case it's a private SQL resource so they set us up with a VM to momentarily upload the reports and edit them from the same internal domain as the SQL server. The problem I'm running into now is that we get the following error, seemingly unconditoinally, from the Azure VM environment:

Connection unsuccessful. Check the connection string and try again. Details: Expecting a non-empty string for 'providerInvariantName' parameter.

That error comes back even if we add providerInvariantName to the string. Something else is clearly going on, I don't exactly know what but it seems like it's an environment issue with the Azure VM if no changes to the sql string either cause a different error or succeed.

What I'd like to ask for is more insight into what kinds of things can cause this error so we understand the problem space a bit better. Please let us know your thoughts on what we need to look at in order to troubleshoot this.

Dimitar
Telerik team
 answered on 27 Feb 2024
1 answer
9 views

I created a report using Telerik Report Designer Standalone with sqlDataSource1 setup with the following ReportParameters like this:



C# coded that read that send the parameter as Int32

    var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
    // set any deviceInfo settings if necessary
    var deviceInfo = new System.Collections.Hashtable();
    var reportSource = new Telerik.Reporting.UriReportSource();
    var directory = Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location);
    var value = Convert.ToInt32(numericExportarPdf.Value);
    reportSource.Uri = "Report.trdp";
    reportSource.Parameters.Add("NRO_TICKET", value);
    Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("PDF", reportSource, deviceInfo);
    if (result.HasErrors) return;
    string fileName = result.DocumentName + "." + result.Extension;
    string path = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);
    string filePath = Path.Combine(path, fileName);
    using FileStream fs = new FileStream(filePath, FileMode.Create);
    fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);

I get the following error:

Telerik.Reporting.Processing.CancelProcessingException: An error has occurred while processing the report. Processing canceled. Check the InnerException for more information.
 ---> System.Exception: Invalid value of report parameter 'NRO_TICKET'.
   --- End of inner exception stack trace ---
   at Telerik.Reporting.Processing.Report.ValidateParameters()
   at Telerik.Reporting.Processing.Report.ProcessItem()
   at Telerik.Reporting.Processing.ReportItemBase.ProcessElement()
   at Telerik.Reporting.Processing.Report.ProcessElement()
   at Telerik.Reporting.Processing.ProcessingElement.Process(IDataMember dataContext)
   at Telerik.Reporting.Processing.Report.Process(Boolean processItemActions, Boolean documentMapEnabled)
   at Telerik.Reporting.Processing.ReportProcessor.ProcessReport(Report report, IPathResolver pathResolver, IProcessingContext parentContext, IEnumerable`1 parameters, Key rootKey, Boolean interactivityEnabled, Boolean documentMapEnabled, PageLayoutInfo pageSettings, ErrorEventHandler errorHandler, List`1 documentNodes, Boolean& documentMapAvailable)
   at Telerik.Reporting.Processing.ReportProcessor.ProcessResolvedReports(ResolvedReportDocument resolvedReportDocument, IList`1 parameters, IProcessingContext contextPerDocument, Boolean interactivityEnabled, Boolean documentMapEnabled, PageLayoutInfo pageSettings, List`1 processedReports, ErrorEventHandler errorHandler, List`1 documentNodes, Boolean& documentMapAvailable, ListSlice& tocReportsSlice)
   at Telerik.Reporting.Processing.ReportProcessor.ProcessReportSource(ReportSource reportSource, IRenderingContext context)
   at Telerik.Reporting.Processing.ReportProcessor.ProcessReportSource(ReportSource reportSource, Hashtable deviceInfo, IRenderingContext context)
   at Telerik.Reporting.Processing.ReportProcessor.ProcessAndRender(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at Telerik.Reporting.Processing.ReportProcessor.ProcessAndRenderStateless(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at Telerik.Reporting.Processing.ReportProcessor.<>c__DisplayClass47_0.<RenderReport>b__0(SingleStreamManager sm)
   at Telerik.Reporting.Processing.ReportProcessor.RenderReportSafe(Func`2 renderCallback, String format, IRenderingContext renderingContext)
   at Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, ReportSource reportSource, Hashtable deviceInfo, CancellationToken cancellationToken)
   at Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, ReportSource reportSource, Hashtable deviceInfo)

If I remove the parameter the report works fine, I added changing to Decimal Type value as my DB engine is MS-SQL 2022 Express. I added filters and get same error. I don't know what to do anymore What I am missing

1 answer
17 views

Hi,

Is there a supported or recommended way to mark/tag a report definition with a version number?

Currently, we use:

  • reports created in the standalone designer, saved to *.trdp
  • ASP.NET Core .NET 6 application, that:
    • hosts the reporting REST service
    • uses EFCore IDefinitionStorage based report storage
    • has functionality to import *.trdp files into the database storage

It will be very useful to be able to automate the report import process on a deployment of the application so that it will only overwrite an existing report in the storage when it is a newer version.

Thanks.

Dimitar
Telerik team
 answered on 09 Feb 2024
1 answer
15 views
Looking to see what the best approach would be to integrated a graphQL data source into Telerik Reporting?  So far, wrapping it with a WebService or ObjectDataSource are options, but I am hoping that there is a more direct way.
Nikolay
Telerik team
 answered on 08 Feb 2024
1 answer
28 views

In Telerik Report Designer, I am having the worst time trying to figure how to find a proper scope name to get the sum of a given expression for every dataitem processing until the end of each page.

For the sake of simplicity, my datasource only has 1 column: saleAmount.

Sample values that fit on page 1

  • 100
  • 200
  • 150

Footer running sum of page 1: 450

Remaining values that fit on page 2

  • 20
  • 30

Footer running sum of page 2: 500

According to this Telerik Reporting article, it seems I should use RunningValue(scope, Sum(Fields.saleAmount))

I've already spent a significant time trying to figure out what exactly should I use as scope parameter,

Please see the attached sample (MyPageRunningTotalSampleReport.zip)

Momchil
Telerik team
 answered on 31 Jan 2024
1 answer
30 views

Hello Team,  

I have a report that contains 2 images. one jpg --> base64   and one PDF --> base64. I use expression to fill the value for the picture Box controls as shown below. 

When I run the report the PDF image is missing. I also tried to paste the B64 text, but it didn't work. I'm I missing a step?   

Using Report Designer version 17.2.23.1010.  .NET Framework 4

1 answer
24 views
For the standalone / web report designer, is it open source and allow customization? 
Dimitar
Telerik team
 answered on 22 Jan 2024
Top users last month
horváth
Top achievements
Rank 2
Iron
Iron
Steve
Top achievements
Rank 2
Iron
Erkki
Top achievements
Rank 1
Iron
Mark
Top achievements
Rank 2
Iron
Iron
Veteran
Jakub
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?