Telerik Forums
Reporting Forum
1 answer
70 views
I have an object data source that looks a bit like

ThingData
    Location
    ThingName
    ThingId
    SummaryData (List)
           SummaryA
                Field
                Field
           SummaryB
                Field
etc.

I have grouped by 'ThingId' and I have added List to the detail section of the of the Report. The List DataSource is set to SummaryData.

In the List I can use SummaryA and SummaryB fields, everything is fine.

In Print Preview (and Export) however, there is always a page break before each List, even though it could fit on the preceding page. It works fine in the standard view.

I searched this forum and found references to this being a bug due to be fixed, that post was in 2013. Looking at other options:

- Grouping: I don't think I can group unless I flatten my data

- SubReport: This would mean a SQL call for each SummaryData row, which I want to avoid

Anyone have any suggestions? Thanks.



Nasko
Telerik team
 answered on 15 Apr 2014
3 answers
541 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.9K+ 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
113 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
223 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
120 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
349 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
250 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
132 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
415 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
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?