Telerik Forums
Reporting Forum
1 answer
277 views
Hi.

After reading some threads about memory management in Telerik Reporting, I noticed that it is a known issue that memory management and performance on the component have some room for improvement. At this moment, I'm facing some challenges to keep the memory usage low when reports are generated, so that I can get my application more scalable and support more concurrent users, and I've been trying some stuff to get around the issue.

We are wondering if it would be a good idea to replace the usage of the ReportViewer control in our web page by using ReportProcessor.RenderReport, using HTML as the format. That way we can just place the resulting HTML on the page and release all resources. Here is how the code would look like:

//Note: "ec" below is my Telerik report class
Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();  
Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("HTML", ec, null);  
System.Text.ASCIIEncoding enc = new System.Text.ASCIIEncoding();  
string htmlResult = enc.GetString(result.DocumentBytes);  
reportProcessor = null;  
result = null;  
lblResult.Text = htmlResult;


We thought this approach could be good for two reasons:

1. The call to RenderReport is synchronous and runs on the same thread as the page - that way I have control of when the render finishes, so I can release the resources after everything is done. The call to ReportViewer.RefreshReport() doesn't work that way, as per our observation (seems to run on a separate thread, so we have no way of capturing the moment the report finishes rendering to clear resources).
2. We don't want/need the toolbar provided by the ReportViewer component.

I'd like an opinion from Telerik on the approach above. Does it make sense?

Another question: the code above renders only the first page of the report in HTML. Is there a way I can get the other pages? I couldn't find information about this on the documentation of the RenderReport method.
Chavdar
Telerik team
 answered on 23 Mar 2010
0 answers
113 views
Hi,

We are using Telerik Reporting and Telerik Openaccess in our project.

We plan to have a common stored procedrue that returns granular data. Teleik Openaccess is used to call the stored procedure.

This stored procedure normally returns about a million rows and upto 4 million rows in extreme cases.

On the frontend, we use crosstab control of telerik reporting to group data as per the requirement.

We will have about 20 different types of telerik reports and all will call this common stored procedure. However, each report will group data in a different way.

I would like to know the following

1. Can crosstabs of Telerik reporting can handle this data volume (1 miilion - 4 million records)

2. What is the maximum volume crosstabs can handle without degradation in performance.

3. Is the above approach the recommended approach? If not, what is Telerik's recommendation?
mennam
Top achievements
Rank 1
 asked on 23 Mar 2010
5 answers
284 views
Hi Telerik team,
I've made a report, run alright on design and html mode. When i embedded in consume page, it gived error: 
An error has occured while processing Report '':
Format of the initialization string does not conform to specification starting at index 0.

Steps:
Create a new project for reports as advise. Put the project in the same solution as my consume project. Physical path however is another place.
Create a report, feed data using store proc. ---> the result as expected until here.
Create a Web form, whose report viewer is assigned to just-made report.
I got the error above.
Am i missing something ?
Thank you

Bogice
Top achievements
Rank 1
 answered on 22 Mar 2010
0 answers
83 views
hi there,

i will build a report, that contains around 21 columns.. i my view, i think its thats too much for one row (with all the data)

one solution might be: to break the data into two rows in the detail section, so that two header rows and two data rows appear.. the problem at this solution is the readability, because of the second header row

another idea is a master-detail output... but i don't know how i could realize it...

so anyone ever had a similar problem or an better idea?

kind regards,
basti
Farouk
Top achievements
Rank 1
 asked on 22 Mar 2010
4 answers
134 views
I think this was a problem with Q1 2009 that has resurfaced.

Thanks,
-Brian
Brian Workman
Top achievements
Rank 2
 answered on 22 Mar 2010
6 answers
457 views
Hello all,

I have an issue perhaps you guys can solve, if I can explain it well enough.  I am using Telerik Reporting 2009_3_1211 for the web.  I have one report with subreports.  When generated to PDF, everything looks fine.  But in the viewer, there is an extra page at the front (page 1) that only shows the "outer" report's PageHeader.  If you navigate to page 2, you see the rest of the report.  Again, this doesn't happen when generated to PDF.  This is the general layout.

"outer" report:
    pageHeader
(an extra page is shown at the beginning with only this item)
    reportHeader (empty)
        detail - contains subreports
    pageFooter

subreport:
    
pageHeader (empty)
    reportHeader
    GroupHeader
        GroupHeader
            detail
        GroupFooter
    GroupFooter

Some notes:
- If I move the subreports to the reportHeader section, the extra page shows up at the end instead of the beginning (this one will also show in the PDF).
- I have messed with the KeepTogether flags in all sorts of combinations (in fact, the PDF was showing the extra Page 1 until I set the subReport's reportHeader's KeepTogether to false).
- No matter how big the report is, the viewer always shows only 2 pages.  Page 1 is the outer report's ReportHeader, and page 2 is everything else.
- In the html, I have the ReportViewer's Height set to 100%.
- I've checked for the following things that Steve @ Telerik mentioned in another recent post:
       - Report Width is greater than than the available page space (Page Width - Left Margin - Right Margin). 
       - There is a sub-report, which contains a report that is too wide, and while at design-time that is not obvious, at run-time it might cause the carry over to occur. 
       - There is a report item with boundaries going out to the right from its parent section.

With all that said... Any ideas?
James Strope
Top achievements
Rank 1
 answered on 22 Mar 2010
1 answer
65 views
Hi,

Is there a way to resize a group section at runtime? There are properties for items but seems to have nothing for sections.

Thanks a lot,

Ben
Peter
Telerik team
 answered on 22 Mar 2010
1 answer
574 views
hi,

How do I change report designer ruler style from cm to in or from in to cm ?

- Milind Shevade
Steve
Telerik team
 answered on 22 Mar 2010
2 answers
120 views
Hello Telerik Team!

In order to get an attractive printout, i have to change (downsize) the paragraph spacing, because the spacing is too much.
We have to printout Richtext and for this we convert rtf into html. Here we can't set the setting, because we don't know how.

Best regards and thanks for helping
Markus
Caipus
Top achievements
Rank 1
 answered on 22 Mar 2010
4 answers
284 views
I just installed the Telerik Reporting Q3 2009 tools. The installer added a tab in my toolbox called #13119. It is emtpy. There is also a tab called Telerik Reporting Q3 2009. It contains the following controls: Pointer, Barcode, Table Wizard, Barcode, Table Wizard (yes, the controls are duplicated in the tab).

I have tried reinstalling the reporting tools. Any ideas?


Thanks,
Jimmy
Jimmy Hill
Top achievements
Rank 1
 answered on 22 Mar 2010
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?