Telerik Forums
Reporting Forum
2 answers
156 views
I have the following dataset:

organisation client pos desc total
a 1 1 a 10
a 1 2 b 11
a 1 3 c 12
a 2 1 d 20
a 2 2 e 21
a 2 3 f 22
a 3 1 g 30
a 3 2 h 31
a 3 3 i 32
b 1 1 j 40
b 1 2 k 41
b 1 3 l 42

An organisation can contain one client, but a second organisation has several clients.
The report is generated at the organisation level.

I need on this organisation report per client a table. See attached file for more information.

How do I create this table? Do i need a normal table with grouping? a cross table? or perhaps a sub-report?
I prefer to generate it completely in the designer, if possible!

thanks in advance!
Eric
Top achievements
Rank 1
 answered on 01 Nov 2017
7 answers
533 views
I am working on a report that is creating a table dynamically in the details section.  Everything is good up to 39 columns and then I get the following error.  This particular run of the report only has seven records so it doesn't seem like it would be too large.  It worked if I did not use a table but just put textboxes in the detail section but the excel download was too jumbled. 

Is there a limit to the number of columns in a table?  Is this something else?  Any help appreciated.

Access to the path 'C:\Documents and Settings\xxx\ASPNET\LOCALS~1\Temp\9a48e4f88d36442381c16e503333fcdc' is denied. 
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, DirectorySecurity dirSecurity)
   at System.IO.Directory.CreateDirectory(String path, DirectorySecurity directorySecurity)
   at Telerik.Reporting.Cache.File.FileCache.EnsureDirectoryCreated()
   at Telerik.Reporting.Cache.File.FileCache.SetValue(String key, Byte[] value)
   at Telerik.Reporting.Cache.SmartCache.SetValue(String key, Byte[] value)
   at Telerik.ReportViewer.WebForms.StreamManager.StreamReady(RenderStream renderStream)
   at Telerik.ReportViewer.WebForms.RenderStream.Finish()
   at Telerik.Reporting.Html5Rendering.Writers.Page.WritePageEndDocument()
   at Telerik.Reporting.Html5Rendering.Writers.Page.WriteEndPage()
   at Telerik.Reporting.Html5Rendering.Writers.Report.WriteEndPage()
   at Telerik.Reporting.BaseRendering.PageHandler.Telerik.Reporting.Paging.IPageHandler.EndPage()
   at Telerik.Reporting.Paging.PageCompositionBase.SendPhysicalPages()
   at Telerik.Reporting.Paging.PageCompositionBase.OutputPage()
   at Telerik.Reporting.Paging.PageCompositionBase.CreatePages()
   at Telerik.Reporting.Paging.PagerBase.Telerik.Reporting.Paging.IPager.CreatePages(IPageHandler handler, Report report)
   at Telerik.Reporting.BaseRendering.RenderingExtensionBase.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback)
   at Telerik.Reporting.Processing.ReportProcessor.RenderCore(ExtensionInfo extensionInfo, IList`1 reports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at Telerik.Reporting.Processing.ReportProcessor.RenderCore(String format, IList`1 reports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at Telerik.ReportViewer.WebForms.ReportPageOperation.RenderReport(String format, IList`1 processingReports, Hashtable deviceInfo, IRenderingContext renderingContext)
   at Telerik.ReportViewer.WebForms.ReportRenderOperation.PerformOperationOverride()
   at Telerik.ReportViewer.WebForms.ReportPageOperation.PerformOperationOverride()
   at Telerik.ReportViewer.WebForms.HandlerOperation.PerformOperation(HttpContext context, ICacheManager cacheManager)
   at Telerik.ReportViewer.WebForms.BasicHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Jans
Top achievements
Rank 1
 answered on 01 Nov 2017
6 answers
232 views
We would like to integrate the designer into our application

What we would like is to be able to wrap the exe so that we can pass in the template file we want to edit and then save the file back to our database

Is this at all possible?

Alex
Top achievements
Rank 1
 answered on 01 Nov 2017
1 answer
309 views

Hello.

We have a winforms project that is attempting to generate DOCX files using Teleirik Reporting. We are getting a "DOCX Rendering Format is not available" error. We're on the latest version of Telerik Reporting (11.2.17.1025) and have both Telerik.Reporting.OpenXmlRendering.2.7.2 and DocumentFormat.OpenXml (2.7.2.0) included in the project and set to Copy Local. Not sure where to go from here.

Luke
Top achievements
Rank 1
 answered on 30 Oct 2017
3 answers
171 views
Hello

I use a pie chart in my report. How it is possible to get the 3D effect with Silverlight ?
Can you explain me please ?

You can see me 2D pie chart into attached file.

Thanks
Dimo
Telerik team
 answered on 27 Oct 2017
1 answer
101 views

Hi everyone,

I'm having trouble with my report about sum group (see my idea in Attach files). I read many topic but i can't done it. How can I sum in one page and move that to next page (Exp: Group is overall show in 3 page.) ? It very difficult with me and I hope someone can help me. 

Thank you!

Noah
Top achievements
Rank 1
 answered on 27 Oct 2017
2 answers
355 views

Hi,
I'm using the trial to see if it fits our purposes but I'm having trouble getting it to do what we need for this report. I've attached a screenshot of the layout.

I've attached a basic outline image of the report body.

List 1 contains an array of strings that can potentially span multiple pages but must only partially cover the page as it has a block of text below it.
List 2 also contains an array of strings that can potentially span multiple pages and runs the full length of the page.

The issue is that as List 1 expands it pushes the detail box below it on to the next page and for our needs it needs to stay exactly in this position on the page. What we want is that a new page should be created once the text / data in List 1 overflows its boundaries leaving the details box below in place.

The layout of the page is required as it is printing onto a set piece of stationary and must match the layout specifications. So we can't use a footer for the details box as List 2 needs to be the full length on the page.

I've tried everything I can think of like wrapping the left section entirely in a list and formatting the data source per page, but List 1 still pushes the fields below it on to the next page.

Is this possible? Through the designer, handling events, something else?

Thanks,
Jon.

Todor
Telerik team
 answered on 26 Oct 2017
0 answers
43 views

Hello,

I have a report that has, as datasource, a .net library from my project. I would like to inject, in any way, a instance of that library so I can preview the report correctly. Let's say that I have a Person class as datasource, with some properties: Name, Age, Gender... and in preview, I want to see how report would be shown with a Person named Mike, who's 45 years old.

Is it possible? And how? Thanks.

Eugeni
Top achievements
Rank 1
 asked on 26 Oct 2017
4 answers
42 views

After upgrading all the references to R3 2017 (11.2.17.913) for our report library and report viewer app (Silverlight), a 7 page reports has stopped printing correctly.

All of the report appears in the report viewer as 2 pages, first main page (details section), which has 6 subreports along with many other fields, and then the final page which is the report footer (has pagebreak before).

When I switch into print preview mode on the viewer, all the data is still on the report, but the PageCount is incorrect, and grows on each page...  

= "Page : " + PageNumber + " of " + PageCount

Page : 1 of 2
Page : 2 of 3
Page : 3 of 4
Page : 4 of 5
Page : 5 of 6
...

When I print the report, or save to a PDF, it only prints/saves 3 pages.  the first 2 pages from the details section, and the report footer page.  5-7 pages are missing.

On the printed report, it lists the pages as 1 of 3, 2 of 3...

Please let me know if you need more information, or if there is a better way to receive support from Telerik.

Thanks in advance for your assistance.

Katia
Telerik team
 answered on 26 Oct 2017
0 answers
88 views

Hi,

We've been receiving some complaints in regard to the report viewer printing.  If a report takes 5 minutes to load/display in the viewer - when clicking the print icon - it then takes another 5 minutes before the print options pop up as if it is working out all the data again....  I was under the impression that the cached data would be used to do the print functionality - but it is re-running the report from scratch to prepare for the printer?   Is this the case or are we doing something wrong?

 

 

Stuart
Top achievements
Rank 1
 asked on 25 Oct 2017
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?