Telerik Forums
Reporting Forum
1 answer
218 views
Is it at all possible, when writing an assembly to be referenced by the standalone designer, to pull information from the designer itself, like maybe the open report file name, etc.
Nasko
Telerik team
 answered on 12 Dec 2014
1 answer
780 views
Hello

I have a big Report with a lot of objects ( > 100'000) get processed in a report. This works fine on the first time but the memory usage is very high. (>200mb). I inspected a lot of possible reasons and found out that the all my objects in the datasource for my report get cached by the reportviewer. As i'm loading the data from a database after interaction from a user (filter, export etc.) i don't need this cache. 
Because of the cache the memory is not getting released until the cache is released and that could be a long time. So if i run my report multiple times i got in trouble with the high memory usage ( > 2.5 GB).

What can i do? I tried to move the cache (http://www.telerik.com/help/reporting/configuring-telerik-reporting-session-state.html) to the file system but this is not working as expected.

Best regards
Stef
Telerik team
 answered on 12 Dec 2014
2 answers
188 views
I'm referring to http://www.telerik.com/help/reporting/object-data-source-how-to-bind-to-data-set.html just in case my other post will have a reply that I need to use *.aspx for report in MVC for data set...

Right now, I can open the report but it is showing no data. If SELECT Name, ProductCategoryID FROM Production.ProductCategory where ProductCategoryID < 4, it will actually show 3 row of data (direct query from database), but instead, what I get is a repeat of the header 3 times. If I omit the where statement from the sql query, it will show 4 row of data, and the web page report also will show the header 4 times...

I'll appreciate help (or working project file Q3 2014, visual studio 2013)

Default.cs
========


        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {

                var objectDataSource = new Telerik.Reporting.ObjectDataSource();
                objectDataSource.DataSource = GetAllData(); // GetData returns a DataSet with three tables

                objectDataSource.DataMember = "ProductCategory";

                //Telerik.Reporting.Report report = new Telerik.Reporting.Report();
                Report2 report = new Report2(); //added this instead...

                report.DataSource = objectDataSource;

                Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource();
                reportSource.ReportDocument = report;

                reportViewer1.ReportSource = reportSource;

                reportViewer1.RefreshReport();
            }
        }


        static DataSet GetAllData()
        {
            const string connectionString =
                "Data Source=.;Initial Catalog=AdventureWorks;Integrated Security=True";

            string selectCommandText = "SELECT Name, ProductCategoryID FROM Production.ProductCategory where ProductCategoryID < 4;;" +
                "SELECT Name, ProductCategoryID FROM Production.ProductSubcategory;" +
                "SELECT Name, ProductNumber FROM Production.Product;";

            SqlDataAdapter adapter = new SqlDataAdapter(selectCommandText, connectionString);
            DataSet dataSet = new DataSet();

            adapter.Fill(dataSet);

            dataSet.Tables[0].TableName = "ProductCategory";
            dataSet.Tables[1].TableName = "ProductSubcategory";
            dataSet.Tables[2].TableName = "Product";
            return dataSet;
        }
Nasko
Telerik team
 answered on 12 Dec 2014
9 answers
1.1K+ views
Our scenario is as follows:

We have a web page that acts as a generic report container. The web page is passed a numeric ReportID which it uses to look up the file name of a tdrx file which it subsequently loads into the viewer as a URIReportSource. This gives us the ability to modify our reports without having to publish a new binary to the web server.

We would like for our report container page to be able to turn off the visibility of certain parameters, however no matter which ReportViewer event we capture (we tried them all), the Report property of the viewer is always blank, so we have no programmatic access to the parameter collection of the report object. All of the examples we have found of hiding report parameters use compiled reports rather than URI report sources and the methodologies applied do not work in our usage scenario.

How do we programmatically hide parameters for a URIReportSource-based report?

We are running version 7.0.13.228 of the web report viewer.
Stef
Telerik team
 answered on 11 Dec 2014
2 answers
110 views
Is there any sample project for Q3 2014 that use Dataset for MVC project? I appreciate help to share it with me...
Nasko
Telerik team
 answered on 11 Dec 2014
1 answer
154 views
Hi,
           I am using Telerik Report Viewer Q2 2014 8.1.14.618. I get error "Operation could destabilize the runtime."  if compilation mode is debug else it works fine. Hence I am not able to debug code. Any idea why I getting it and what i can do to resolve it.



Thanks And Regards,
Sharad kumar Rathore
Stef
Telerik team
 answered on 11 Dec 2014
1 answer
538 views
I am getting this while using html5 report viewer in my MVC projectUnable to get report parameters: Report 'Application.Reports.Report1, WebAppUsingTelerikReport' cannot be resolved.After clicking the error in console it says The requested resource does not support http method 'GET'


@{
Layout = null;
var typeReportSource = new TypeReportSource() { TypeName = "Application.Reports.Report1, WebAppUsingTelerikReport"
};
}

<script type="text/javascript">
$(document).ready(function () {
debugger;


$("#reportViewer1")
.telerik_ReportViewer({
serviceUrl: "/api/reports/",
templateUrl: '../ReportViewer/templates/telerikReportViewerTemplate-8.2.14.1027.html',
reportSource: {
report: "@typeReportSource",
},
viewMode: telerikReportViewer.ViewModes.INTERACTIVE,
scaleMode: telerikReportViewer.ScaleModes.FIT_PAGE_WIDTH,
scale: 1.0,
ready: function () {
}
});
});
</script>
Stef
Telerik team
 answered on 10 Dec 2014
6 answers
91 views
We are having issues with some notes that appear in our report footers in 8pt Arial coming out "warped" (i.e. kind of italic but not quite).  We use this font in some detail lines and in the page footer and those appear fine.  If we render the report to PDF and then print it, it is also fine.  We only have the problem when we use the ReportProcessor PrintReport option.  I have double, triple checked that we are not doing anything different with these textboxes in the reports.  They are all set to 8pt Arial no bold, no italic.  In the same footer, some come out fine and some are warped.  No rhyme or reason that I can see.
The attached picture shows two sets of notes - the first group from a report footer that show the problem and the second group from a detail section that are fine.

Any ideas?
Hinata
Top achievements
Rank 1
 answered on 10 Dec 2014
1 answer
139 views
We use the ReportProcessor to RenderReport directly to PDF.  To minimize the size of the file, we set FontEmbedding to None.
If that is the case, a file emailed to someone who wants to read it on an iOS device will only see the contents that use the Arial font.
If I modify the report to only use 2 fonts (Arial and the bold version of Arial) the report grows in size like so:
Embedding=None => 50kB
Embedding=Subset (Arial) => 100kB
Embedding=Subset (Arial and Arial Bold) => 140kB
Is this expected?
Is there a better approach?

I was under the impression that iOS would automatically use the other fonts we were originally using (Verdana, Gill Sans) without having to embed them.  Reference: http://support.apple.com/en-us/HT202771

If our product owner isn't okay with the increased file sizes, I'm considering a solution that uses Ghostscript to edit any PDF that needs to be sent to a customer that needs to read it in iOS.  It appears there's an option to open the PDF and embed the fonts that are referenced.
Any other ideas or input is greatly appreciated.
KS
Top achievements
Rank 1
 answered on 09 Dec 2014
3 answers
137 views

hi,

I have created a report using telerik ..
my code is given below.

Report7

 

 

objreport1 = new Report7();

 


and I have created a Reportbook control .its id is Reportbookcontrol1.
after that I assigned report to the report  to the report book control like

ReportBookControl1.Reports.Add(objreport1);

then I got an error :

The best overloaded method match for 'System.Collections.ObjectModel.Collection<Telerik.ReportViewer.WebForms.ReportInfo>.Add(Telerik.ReportViewer.WebForms.ReportInfo)' has some invalid arguments

so I cannot view anything in reportviewer.
so how to add my report to the reportbook control ?
Please help me .it is urgent

thanks
sindu.

Stef
Telerik team
 answered on 08 Dec 2014
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?