Telerik Forums
Reporting Forum
2 answers
109 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
327 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
204 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
88 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
388 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
267 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
98 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
124 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
287 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
2 answers
740 views
Q1 2014 silverlight

I am using the ObjectDataSource with a business object with this signature:

Public Class TransferReportClass
    <DataObjectMethod(DataObjectMethodType.Select)> _
    Public Function TransferReportList(ByVal sn As String, _
                                       ByVal transferBy As Integer, _
                                       ByVal sortBy As Short, _
                                       ByVal allDates As Boolean, _
                                       ByVal FromDate As Date, _
                                       ByVal ToDate As Date, _
                                       ByVal direction As Short) As List(Of DataTransfer)

If I initialize the parameters in the configure data source wizard the report runs fine.
However I want to pass the paramenters at run time so in RenderBegin I do this:

        args.ParameterValues("sn") = Application.Current.Resources("sn")
        args.ParameterValues("transferBy") = rp.transferBy
        args.ParameterValues("sortBy") = rp.sortBy
        args.ParameterValues("allDates") = rp.allDates
        args.ParameterValues("FromDate") = rp.FromDate
        args.ParameterValues("ToDate") = rp.ToDate
        args.ParameterValues("direction") = rp.direction

When I was rusing a data method that returned a dataset instead of a list as above the report worked fine.
I changed it to return a list of my data bojects becuase I need to do some formating and the class already
handles everything.

when I run the report now I get the following error:

An error has occured while processing Report 'TransferReport':
An error has occured while resolving ObjectDataSource1 data source: cannot convert to type System.Int32

It must be talking about the parameters, so I modified the methods signature in an attempt to appeaise it,
I changed Interger to Int32, Shoert to Int16, and Date to Datetime, with no effect.
Stef
Telerik team
 answered on 11 Apr 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?