Telerik Forums
Reporting Forum
3 answers
531 views
My Report.aspx page contains a ReportViewer control, and I set the TypeName & ReportSource during the ReportViewer1.Load method.

For all reports I try, some of my toolbar buttons are disabled (e.g. Previous Page, Next Page, Last Page) and what's more is the "First Page" button when clicked seems to act as the print button!

Also, the current page is always "0". See attachment.

Below is my markup/code for the Report.aspx page.
Private Sub ReportViewer1_Load(sender As Object, e As System.EventArgs) Handles ReportViewer1.Load
     
                'set report type
                Private repDataSource As New Telerik.Reporting.TypeReportSource
                repDataSource.TypeName = "XXX.Case_Report, XXX, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b10c045d816b947a"
                ReportViewer1.ReportSource = repDataSource
 
 
         
End Sub
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Report.aspx.vb" Inherits="xxx.Report" %>
<%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=7.0.13.426, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>
 
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<head runat="server">
    <style type="text/css">
         /* max height */
            html, body, form 
            
                height: 100%; 
                margin: 0px; 
                padding: 0px; 
                background-color:White
            
             
    </style>
    <title></title>
</head>
<body style="padding:0;margin:0">
    <form id="form1" runat="server">
     
        <telerik:ReportViewer ID="ReportViewer1"  runat="server" Width=100%
            Height="700px" ShowDocumentMapButton="False" ShowHistoryButtons="False"
            ShowNavigationGroup="true" ShowParametersButton="true"
            ShowPrintPreviewButton="False" ToolbarVisible=true  ></telerik:ReportViewer
     
    </form>
</body>
</html>
 

Stef
Telerik team
 answered on 15 Apr 2014
3 answers
1.8K+ views
Hey guys, I was wondering if there is a expression to round to a certain decimal point(EG. 11.9789 -> $11.98). I know with SQL reporting there is a Round(number,2) which solved this problem. 

Any help would be appreciated. Thanks
Stef
Telerik team
 answered on 15 Apr 2014
2 answers
110 views
Hi,

I'm having an issue with a clients environment where we are trying to upgrade SharePoint 2010 to sp2 and during the process the web.config on all sites are having the Telerik.reportviewer.axd key added multiple times.

Are you able to assist. Please see attached image
Johnathon
Top achievements
Rank 1
 answered on 15 Apr 2014
2 answers
217 views
I am running across a situation where I have the need to display a SubReport or not depending on if the data source contains any items.  That part is no problem, I can set the visibility of the SubReport to false if the data source contains no items.  However, the SubReport is in a Group Footer section, and even if I set the SubReport visibility to false, the group footer still allows the room for it, so I end up with an extra page with page header/footer.

I then try to set the visibility of the Group Footer section based on the same logic as the SubReport visibility, and that seems to work, except that it applies the same visibility to ALL group footers.  So say I have 5 groups, and only 1 of them needs to display the SubReport, it will set the visibility of the Group Footer to true for ALL 5 groups, rather than just the individual group that should display the SubReport.

The only solution I have found so far, is to programmatically set the Height property of the Group Footer section to 0, which works for the most part, as the section will grow to make room for the SubReport that needs to be displayed.  However, the SubReport is a dynamic height, and I need to force it to 7.65in.  I tried programmatically settings the Group Footer height to 7.65in when the SubReport needs to be displayed, but I get the same issue, where it sets the height to 7.65 for ALL groups instead of just the one.

How would I go about forcing the Height of the SubReport, in order for the Group Footer to size itself accordingly?  I do not see a Height property of the SubReport.  I think that the answer is just to set the height of the SubReport, that way it will be per group, rather than for the whole report, but I am just not finding the Height property.  Thanks.

Brian Williams
Brian
Top achievements
Rank 1
 answered on 14 Apr 2014
2 answers
114 views
When I create a report viewer, I pass in the parameters, but the report still uses the default parameters. Also when I expand a group to show details it resets back to the default parameters. I am using customer parameters.


    $(function () {


        $("#reportViewer1")
            .telerik_ReportViewer({
                serviceUrl: "/api/TelerikReports/",
                templateUrl: '/Content/Telerik/Report/telerikReportViewerTemplate.html',
                reportSource: {
                    report: "SomeReportType",
                    parameters: {
                        StartDate: $('#StartDate').data("kendoDatePicker").value(),
                        EndDate: $('#EndDate').data("kendoDatePicker").value(),
                        DC: $('#Dcs').data("kendoComboBox").value()
                    }
                }
            });
    })


        function ShowReport() {

            var viewer = $("#reportViewer1").data("telerik_ReportViewer");

            
            viewer.reportSource({
                report: viewer.reportSource().report,
                parameters: {
                    StartDate: $('#StartDate').data("kendoDatePicker").value(),
                    EndDate: $('#EndDate').data("kendoDatePicker").value(),
                    DC: $('#Dcs').data("kendoComboBox").value()
                }
            });
            viewer.refreshReport();
        }



Donald
Top achievements
Rank 1
 answered on 14 Apr 2014
8 answers
336 views
Hi,

Our company is currently in the process of evaluating Telerik reporting and I had one question. I have line series graph with multiple line series. I want to show a vertical line marker on each line series at some predefined points. I am able to show the line series graphs itself but I don't know how to show these vertical line markers. Attached is a PDF that shows a line series graph and there are vertical dotted lines on each series. How do I show these vertical dotted lines on the graph? Is there some kind of datapoint conditional formatting that I can do? 

Thanks,
Mandar
Mandar
Top achievements
Rank 1
 answered on 14 Apr 2014
3 answers
236 views
I'd like to be able to put a full page loader while our application is exporting a previously rendered & currently displaying report to pdf / excel. This means being able to run client side code once the export has finished. Is this possible?

We have our current report viewer set up as follows:

 <telerik:ReportViewer ID="Viewer" runat="server" 
            Width="100%" Height="100%" ClientIDMode="Static"
            ParametersAreaVisible="False" ViewMode="PrintPreview"
            ToolbarVisible="false" DocumentMapVisible="false" Skin="Promapp" SkinsPath="~/Content/Skins">
        </telerik:ReportViewer>

When the user clicks on the PDF icon above this viewer we call this javascript code:

ExportReport: function (exportType) {
        if (typeof Viewer === "undefined") { return; }
        Viewer.ExportReport(exportType);
    },


So, ideally what I'd like to do is in this ExportReport function call our existing Loader() jquery function, and then have a callback function defined once the export has completed which can have our existing LoaderRemove() function. How exactly can I define this callback - is there an OnReportExported event?

Other threads have mentioned as a possibility to define a custom server-side function in our code that will export the report programatically as explained here (http://www.telerik.com/help/reporting/programmatic-exporting-report.html). We could then have our own ajax call to an action that will do this. However, from this post it is not clear how to exactly pass in the currently displayed report instance - since that is already rendered on the screen prior to the user being able to click the export button. How exactly do you pass in this report instance? Is there an ID or something you can pass in, and a telerik method that you can call to retrieve it?

Thanks to anyone who can reply.

Paul


Nasko
Telerik team
 answered on 14 Apr 2014
1 answer
110 views
Hello,

After tinkering for a while I have the html5 viewer coming up in a project, and I'm feeding it a report that has Parameters with childParameters as well.

Unfortunately, whenever I select the parent dropdown parameter it resets to the 1st item in the list, even though the child dropdowns are filtering the data correctly.

Any idea if this is a bug and/or what I can do to fix this behavior?

Thanks
Hinata
Top achievements
Rank 1
 answered on 14 Apr 2014
9 answers
408 views
Hi,

Is there a way to print from the 2010 Q3 Silverlight Report Viewer without having to view the report first?


Ta,
Grant.
Witold
Top achievements
Rank 1
 answered on 14 Apr 2014
9 answers
276 views
Has anyone else had a problem exporting a report to Excel that generated a dialog box that reads:

Errors were detected in '[filename]', but Microsoft Office Excel was able to open the file by making the reports listed below. Save the file to make the changes permanent.

Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.


I am building a report programmatically, not using the designer. But it is a simple, tabular report, and exports perfectly to all the other formats.

The version of Telerik reports is Q2 2008.

Has anyone seen this before?

Thanks,
Kirby
Nasko
Telerik team
 answered on 14 Apr 2014
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?