Telerik Forums
Reporting Forum
1 answer
155 views

I don't understand the issue please guide some one here is pdf link please check it

https://drive.google.com/file/d/1XHSSO4x8yQop2z2V8tpzoJl02zK-LMd6/view?usp=sharing

Eric R | Senior Technical Support Engineer
Telerik team
 answered on 26 Nov 2021
1 answer
1.1K+ views

I have names. I want to set unique name as:  (name + ', ' + name + ', ' + ....) for text box value. This sql query work in my machine, but not work in telerik report designer, error message: 

The variable name '@myParameter' has already been declared. Variable names must be unique within a query batch or stored procedure.

 

DECLARE @myParameter VARCHAR(max)

SELECT @myParameter = COALESCE(@myParameter + ',', '') + g.[Name]
FROM [dbo].[NotificationEX] AS n
LEFT JOIN [dbo].[NotificationEXPurchaseMetods] AS m ON m.[ID] = n.[PurchaseMetod]
LEFT JOIN [dbo].[NotificationEXPurchaseMetodGroup] AS g ON g.[ID] = m.[Group]
WHERE [Placer] = 76875 AND [Status] IN (4, 14) AND [PublishedDate] >= GETDATE() - 365
GROUP BY g.[Name]

SELECT @myParameter 

 

This not help for my script: https://docs.telerik.com/reporting/knowledge-base/how-to-use-local-variables-in-a-sql-query-used-by-the-sqldatasource-component

Dimitar
Telerik team
 answered on 26 Nov 2021
1 answer
639 views

Hi,

Web Service Data Source has parameters as you can see from the picture below. We can define design-time value for the parameters. The design-time values help us during designing our report (for example, we can see selected properties from standalone & web report designer). In our case, we also need to modify some report programmatically, we need to create new web service data source or update existed one. 

  The question is how to set design-time value for a parameter of web service data source programmatically? 

Dimitar
Telerik team
 answered on 25 Nov 2021
1 answer
467 views

Hi,

We have upgraded our Telerik reporting version to 15.1.21.616 and we are using the Upgrade Wizard to update all the telerik assemblies in the project. When we called /api/reports/formats, below error occurs:

 

"ExceptionMessage": "Multiple actions were found that match the request:  Formats on type WebApi.Controllers.ReportsController GetClientsSessionTimeoutSeconds on type WebApi.Controllers.ReportsController", "ExceptionType": "System.InvalidOperationException",
"StackTrace": "   at System.Web.Http.Controllers.ApiControllerActionSelector.ActionSelectorCacheItem.SelectAction(HttpControllerContext controllerContext)\r\n   at System.Web.Http.Controllers.ApiControllerActionSelector.SelectAction(HttpControllerContext controllerContext)\r\n   at System.Web.Http.ApiController.ExecuteAsync(HttpControllerContext controllerContext, CancellationToken cancellationToken)\r\n   at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__15.MoveNext()"

 

Once we downgrade back to 15.0.21.224, the error gone.

Please help. Thank you.

 

 

Dimitar
Telerik team
 answered on 25 Nov 2021
0 answers
373 views

Good morning
I have to print a report already created with telerik report designer through a c # application, I looked at the guides but I can't print using the ReportProcessor.PrintReport method.
also is it possible to pass a json file when I start printing with the various data?
Mattia
Top achievements
Rank 1
 asked on 25 Nov 2021
1 answer
611 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
511 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
132 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
122 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.0K+ 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
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?