Telerik Forums
Reporting Forum
2 answers
250 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
144 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
374 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
302 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
169 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
440 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
309 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
1 answer
121 views
My Pie chart display #1.  I want to exploded one slice.  Can I do it from the properties sheet?  If not, how I can achieve it? Progamming C# in whitch event?  Example please.
Nasko
Telerik team
 answered on 11 Apr 2014
3 answers
174 views
Just downloaded the Reports trail.  Looked at the quickstart documentation and the VB.NET silverlight example (which runs just fine).

I attempted to replicate the demo on my own, so I created a solution with a report class, a web project, and a silverlight project.  I referenced all the proper dll's per the demo example.  I added the svc file as the documentation described.  The preview of the report class works, it loads and displays records from my database.

After going over it line by line I can find no substantive differences between my project and the demo project but I have 2 problems:

1. The report viewer does not show in the designer.  This is not a big deal but it does show in the demo.

2. when I run the project everything renders fine but the report says 'A report cannot be created form Report1, ReportClassLibrary1', which is the name of the report class and project respectively.

The only difference between the demo and my project is I use a sql data source pointing to a sql server 2008 r2 on a server hosted on my local network.  I put in a simple select Name query against a client table.  As I said the report works in the preview tabs provided by the report designer.

I checked all the paths and names pretty carefully, I can find nothing wrong except what I may be missing because I don't know exactly all the details of how everything fits together (but I have a pretty good idea, I think).

So...what can I try to get this working?  I need be I can upload the sample project I created, but the database will need to be provided and the connection string changed.
Hinata
Top achievements
Rank 1
 answered on 11 Apr 2014
7 answers
407 views
Sorry, could not think of a proper title for this question: I have a customer requirement for an invoice which I have designed and working perfectly. The trouble I am having is that they want a "Terms and Conditions" page to be printed on the back of the invoice (duplex printing) and I am struggling with how and where to add this into the report so it always prints on a seperate page.

The invoice will always be page 1 and will 100% of the time be only 1 page.

I have only recently purchased the report control so I am hoping it is just my newbie brain not knowing how to get this done.

Thank you for your assistance.
Nasko
Telerik team
 answered on 11 Apr 2014
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?