Telerik Forums
Reporting Forum
1 answer
673 views

How can I get the row count from a table that is in the detail, but show that total in a textbox in the footer?

The datasource on the table in the detail doesn't seem to be accessible from anywhere but the table. 

The datasource on the report itself is different, containing some common items for display, but no data.

I've seen solutions that talk about adding a list or table to the header, but that doesn't seem to be allowed. The report designer does not allow that.  "It is not allowed to add Table to pageHeaderSection1" 

Is there a solution for this? Some way to make a report function that can be called from an expression? Or something like a field in the detail that is identified such that its value can be accessed in the footer?

Thanks

Todor
Telerik team
 answered on 24 Nov 2021
1 answer
544 views

HI All,

We have 2 web servers , 2 app  in our prod environment. Suddenly after server reboot activity, on one of the server we are facing issue "Error registering the viewer with service". When request hit to one of the server then only user see error. We are using File Storage for the implementation. I suspect some settings or configurations might have changed in one server. What all things can we check for this ? Trace log show below error in affected server:
"Make sure you are using CacheStorage inside single-instance application deployment only."

Todor
Telerik team
 answered on 23 Nov 2021
0 answers
150 views

I am Using telerik.reporting.cache.stackexchangeredis.2 15.0.21.224 to implement redisStorage. But it is not digitally signed. How can i get the digitally signed version of this package

 

1 answer
142 views

How do I remove the expanders on this chart that I've circled?

 

Todor
Telerik team
 answered on 22 Nov 2021
4 answers
2.1K+ views

(Test carried out using the BarcodeTypes demo report)

On my development machine, all export formats work fine.

When deployed to Azure, some formats work, some don't:

_ PDF, CSV, XLS, Tiff & MHTML all work fine

_ XLSX, PowerPoint, RTF and Word all give the same GDI+ error

I have found other instances of GDI+ errors on the forum (related to PictureBox, PDF export, ...) but this seems to be a different type of exception

 

I am aware of Report Export issues on Azure with cheap plans, and have upgraded to a higher plan (Basic); PDF export didn't work on cheaper plan and that works now, so I assume this is an unrelated issue.

Error message:

w3wp.exe Error: 0 : An error occurred while rendering the report in separate thread: System.Runtime.InteropServices.ExternalException (0x80004005): A generic error occurred in GDI+.
   at System.Drawing.Imaging.Metafile..ctor(IntPtr referenceHdc, Rectangle frameRect, MetafileFrameUnit frameUnit, EmfType type, String desc)
   at System.Drawing.Imaging.Metafile..ctor(IntPtr referenceHdc, Rectangle frameRect, MetafileFrameUnit frameUnit, EmfType type)
   at Telerik.Reporting.Processing.Imaging.ImageUtils.CreateMetafileCore(Size sizePx) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\Processing\Imaging\ImageUtils.Full.cs:line 105
   at Telerik.Reporting.Processing.Imaging.ImageUtils.CreateMetafileImage(SizeF sizeMm) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\Processing\Imaging\ImageUtils.Full.cs:line 91
   at Telerik.Reporting.Processing.Imaging.MetafileImageFactory.CreateImage(SizeF sizeMm) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\Processing\Imaging\ImageFactory.cs:line 26
   at Telerik.Reporting.ExcelRendering.Barcode.RenderInternal(IWorksheet worksheet, RenderingContext context) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\ExcelRendering\Barcode.cs:line 21
   at Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, RenderingContext context) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\ExcelRendering\RenderingItem.cs:line 364
   at Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, RenderingContext context) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\ExcelRendering\RenderingItemContainer.cs:line 108
   at Telerik.Reporting.ExcelRendering.Table.RenderInternal(IWorksheet worksheet, RenderingContext context) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\ExcelRendering\Table.cs:line 31
   at Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, RenderingContext context) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\ExcelRendering\RenderingItem.cs:line 364
   at Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, RenderingContext context) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\ExcelRendering\RenderingItemContainer.cs:line 108
   at Telerik.Reporting.ExcelRendering.Section.RenderInternal(IWorksheet worksheet, RenderingContext context) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\ExcelRendering\Section.cs:line 26
   at Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, RenderingContext context) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\ExcelRendering\RenderingItem.cs:line 364
   at Telerik.Reporting.ExcelRendering.Group.RenderInternal(IWorksheet worksheet, RenderingContext context) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\ExcelRendering\Group.cs:line 47
   at Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, RenderingContext context) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\ExcelRendering\RenderingItem.cs:line 364
   at Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, RenderingContext context) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\ExcelRendering\RenderingItemContainer.cs:line 108
   at Telerik.Reporting.ExcelRendering.Report.RenderInternal(IWorksheet worksheet, RenderingContext context) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\ExcelRendering\Report.cs:line 202
   at Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, RenderingContext context) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\ExcelRendering\RenderingItem.cs:line 364
   at Telerik.Reporting.ExcelRendering.Report.Render(IWorkbook workbook) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\ExcelRendering\Report.cs:line 137
   at Telerik.Reporting.OpenXmlRendering.Spreadsheet.SpreadsheetReport.Telerik.Reporting.Processing.IRenderingExtension.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting.OpenXmlRendering\Spreadsheet\SpreadsheetReport.cs:line 40
   at Telerik.Reporting.Processing.ReportProcessor.RenderCore(ExtensionInfo extensionInfo, IList`1 processingReports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\Processing.ReportProcessor\ReportProcessor.RenderReport.cs:line 236
   at Telerik.Reporting.Processing.ReportProcessor.RenderCore(String format, IList`1 reports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\Processing.ReportProcessor\ReportProcessor.RenderReport.cs:line 157
   at Telerik.Reporting.Services.Engine.ReportRenderer.Render(ReportRendererArgs args) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\Services.Engine\ReportRenderer.cs:line 40
   at Telerik.Reporting.Services.Engine.Rendering.RenderWithCulture(ReportRendererArgs args) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\Services.Engine\Rendering.cs:line 152
   at Telerik.Reporting.Services.Engine.Rendering.ThreadFunc(Object o) in c:\temp\reporting\RBuild-23266\Reporting_Build\Source\Code\Telerik.Reporting\Services.Engine\Rendering.cs:line 120

 

 

Any hep would be greatly appreciated,

 

Erik

Jordan
Top achievements
Rank 1
Iron
 answered on 21 Nov 2021
0 answers
312 views

Hi,

I am trying to Implement the RedisStorage in my application which uses Telerik Reporting but doesn't seem to get any hold of it. Can anyone please help me how to use it.

1 answer
2.1K+ views

I found some bits of code from long ago but still can't figure it out.

Any up to date clear code You could give me ?  I am using Angular/.NET core 5.0.

I am putting the report in the wwwroot and setting to copy always so the report seems to be there. The report has no parameters.

 

I get the error below


   [HttpGet]
        //https://localhost:44374/reports/testreport
        public string TestReport()
        {
            string webRootPath = _webHostEnvironment.WebRootPath;

            var rptName = Path.Combine(webRootPath, "Reports\\AllForms.trdp");
            var report = new Telerik.Reporting.Report { DocumentName = rptName };
            var instanceReportSource = new InstanceReportSource { ReportDocument = report };

            var reportProcessor = new ReportProcessor();
            var result = reportProcessor.RenderReport("PDF", instanceReportSource, new Hashtable());

            return "xxx";
        }

 

The current data set presented in the report did not produce any significant content, so no pages were generated. If you need to see the whole report content, including blank pages, please contact the report author.

Dimitar
Telerik team
 answered on 18 Nov 2021
1 answer
189 views

Hello,

We have a dynamic report book we create for one of our reports. It has been working for several years. 

We just implemented load balancing and had to change our "ReportServiceConfiguration" to use MsSqlServerStorage instead of FileStorage. That works for all of the other reports except for this report book.

When you run the reportbook it behave strangely, sometimes it will display a few pages, other times it will get an error "index out of range exception". It is as if something is cached and it gets confused when switching servers. 

We are using ASP.NET MVC.

Any suggestions?

Todor
Telerik team
 answered on 15 Nov 2021
1 answer
95 views

Hi,

I've set reportHeaderSection.Visible to false.  The contents of the page are blank but the reportHeaderSection still remains as a blank page.

How do I hide the entire section to remove the blank reportHeaderSection page?

Please reply to mrogers@sabreindustries.com.  Our login is a general email address which will not be sent to me.

Thank you for your help.

Mark Rogers

Sabre Industries, LLC.

Neli
Telerik team
 answered on 11 Nov 2021
1 answer
117 views

Hi guys,

I currently have a problem with the PageCount in a very specific situation.

I have a Report made in the Visual Studio Designer. This Report has a different Subreport based on a Parameter.
This Report is in a ReportBook in these variants with different parameters.

And this ReportBook is displayed in a ReportViewer.

Now the PageCount isn't always correct.
With always I mean, some versions of the Report have the correct number, some don't.

If the Report is not in the Book, the PageCount is correct.
If I try the same with a ReportBook in the Standalone Designer, it is also correct.

The PageNumberingStyle is set to ResetNumberingAndCount, so that can't be any problem.

Since it's a big C# project with Database connections, it's hard to give the whole code and just some snippets aren't relly informative.

But has anyone any idea what could help or how I could count the pages without the build in function?

Greetings Benedikt

Benedikt
Top achievements
Rank 4
Iron
Iron
Iron
 answered on 10 Nov 2021
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
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?