Telerik Forums
Reporting Forum
7 answers
1.2K+ views
When working with picturebox, which sizing is "ScaleProptional", can we set alignment to be at right? dock doesn't seems to be working
Katia
Telerik team
 answered on 01 Feb 2017
0 answers
427 views

Hello,

I'm getting the data for the report with an object.

I've tried to save the data in a Base-64 string and load it the next time through the Base-64 string.

But the report doesn't show the data it the Table (I'm getting the no data message in the report).

I use this for getting the data for my table

this.dataTable.DataSource = DocumentItems;

The code used for getting the data from a Base-64 string is in the attached image.

Luka
Top achievements
Rank 1
 asked on 01 Feb 2017
1 answer
50 views

Hi,

i am facing a problem setting the reportsource of a Sub - Sub Report.

I am trying it like this....

 

using (System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create(reportingPath + report_Name, settings))
{
    Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();
    ExportReport = (Telerik.Reporting.Report) xmlSerializer.Deserialize(xmlReader);
    if ((ExportReport != null))
    {
        ExportReport.ReportParameters["Id"].Value = Id;
 
        // Subreport for Column1
        if ((ExportReport.Items.Find("SubReport_Column1", true)).Count() == 1)
        {
            Telerik.Reporting.SubReport SubReport_Column1 = (Telerik.Reporting.SubReport) ExportReport.Items.Find("SubReport_Column1", true)[0];
            ((Telerik.Reporting.UriReportSource) (SubReport_Column1.ReportSource)).Uri = reportingPath + SubReport_Colum1_Name;
                         
            if ((SubReport_Column1.Items.Find("SubReport_Column1_Details", true)).Count() == 1)
            {
                Telerik.Reporting.SubReport Report_SubReport_Column1_Details = (Telerik.Reporting.SubReport) SubReport_Column1_Details.Items.Find("Column1_Details", true)[0];
                ((Telerik.Reporting.UriReportSource) (Report_SubReport_Column1_Details .ReportSource)).Uri = reportingPath + report_Column1_Details;
            }
        }
         
        ...

 

Hope somebody can help me out?

I am not sure, what is the right way to set the SubReport.URI of the SubReport.
    if ((SubReport_Column1.Items.Find("SubReport_Column1_Details", true)).Count() == 1)

 

 

 

 

Lars
Top achievements
Rank 1
 answered on 01 Feb 2017
1 answer
214 views
I am having difficulty creating a chart for the values in the attached Excel. Column A is the different types of measurements, column B is the measure (scale 1 - 10) and column C is the measurement date. I want to plot these values on a chart so that the y-axis has a scale of 1 - 10 and the x-axis has the dates. I'd also like different colors or glyphs to represent the different types of values.
Katia
Telerik team
 answered on 01 Feb 2017
3 answers
410 views
I've got a simple 5-column report and I can't figure out how to swap the column order.  In a designer UI this *should* be as simple as dragging a column to the left or right, but I can't figure out what Telerik's Report Designer wants.  Attached is a snapshot of the simple report.
Katia
Telerik team
 answered on 31 Jan 2017
1 answer
200 views

I downloaded the "AngularJSDemo" project and it works out of the box.  Still in my (TypeScript) AngularJS project does not.  I am using the sample directive declaration:

iapp.directive('report', function () {
   return {
      restrict: 'EA',
      transclude: 'true',
      scope: {
         name: '@',
         parameters: '@'
      },
      template: "",
      link: function (scope:any, element, attrs) {
         //create the viewer object first, can be done in index.html as well
         var reportViewer = $("#reportViewer1").data("telerik_ReportViewer");
         if (!reportViewer) {
            $("#reportViewer1").toggle();
           
            $(document).ready(function () {
               var d: any = $("#reportViewer1");
               var f: Function = $("#reportViewer1")["telerik_ReportViewer"];
               //$("#reportViewer1").telerik_ReportViewer({
               f({
                  error: function (e, args) {
                     alert('Error from report directive:' + args);
                  },
                  reportSource: {
                     report: scope.name,
                     parameters: JSON.parse(scope.parameters),
                  },
                  serviceUrl: '/api/reports/',
                  scale: 1.0,
                  ready: function () {
                     alert("up's");
                  },
               })
            });
         }
         //on state change update the report source
         scope.$watch('name', function () {
            var reportViewer = $("#reportViewer1").data("telerik_ReportViewer");
            if (reportViewer) {
               var rs = reportViewer.reportSource();
               if (rs && rs.report)
                  if (rs.report != scope.name &&
                     rs.parameters != scope.parameters) {
                     reportViewer.reportSource({
                        report: scope.name,
                        parameters: JSON.parse(scope.parameters),
                     });
                  }
            }
         });
      }
   }
});

and a similar template as follows:

<div class="container-fluid" ng-controller="reportViewModel">
   <!--<h2>{{Title}}</h2>-->
   <div class="spacing">Title:  {{report.settings.title}}</div>
   <div class="spacing">Name: {{report.settings.reportName}}</div>
   <div class="spacing">Params: {{report.settings.reportParams}}</div>
   <hr />
   <report name="{{report.settings.reportName}}" parameters="{{report.settings.reportParams}}"></report>
</div>

-----------------------------------------------------

All looks good, and I can see that the "link" and "$watch" functions being called as expected, still the report viewer does not show-up!  I do see that when the "$watch" (for "name") gets triggered that the "var reportViewer = $("#reportViewer1").data("telerik_ReportViewer");" always returns "undefined" (reportViewer is undefined).  if I go to the browser and type: ".../api/reports/" I do get to the controller (as expected), but it should be called upon initialization (within link") but it never happens... 

If someone have a bit of a clue what else I should be looking for it will be nice to know, until then... thanks.

Ed.

 

Katia
Telerik team
 answered on 30 Jan 2017
3 answers
429 views

I have a MVC application and am trying to pass parameters from client side to objectdatasource.

The client code is like:

 @(Html.TelerikReporting().ReportViewer()
                      .Id("report-viewer1")
                      .ServiceUrl(Url.Content("~/api/reportservice/"))
                      .TemplateUrl(Url.Content("~/content/reportviewer/templates/telerikReportViewerTemplate.html"))

                        ....................

                     .ReportSource("report.trdp", new Dictionary<string, object>() { { "parameter1", "value1" }, { "parameter2", "value2" } })

                )

report.trdp is created with Reporting Designer.  it is configured to get the data from objectdatasource (binding to the extension assembly and function).

The question is: how can I pass "parameter1" and "parameter2" from the client side to the extension function at the server side to limit the data query?

Jerry
Top achievements
Rank 1
 answered on 30 Jan 2017
7 answers
764 views

Hello,

I have made a report that has important properties in its code behind that I am attempting to access using "ReportDefinition.PropertyName" in expressions. This technique works perfectly in the Preview tab at design time, however in the Html5 WebForms ReportViewer control, this method of referencing properties always returns null. Note that 1) I know that the properties are not null, and 2) in the same report in the same control, I'm successfully referencing a method in the code behind that returns a string including some of the values of those same properties. Currently my references to ReportDefinition are mostly in TextBoxes, but moving them to report parameters does not solve the problem.

Example of an expression I'm using in a TextBox: '= IsNull(ReportDefinition.OrderNumber, "INVALID ID")'

Why can I successfully reference methods using ReportDefinition at both design time and run time, but only successfully reference properties at design time?

Thanks,

Shane

Shane
Top achievements
Rank 1
 answered on 27 Jan 2017
1 answer
147 views

I am trying to create a bibliography in my report using the Chicago style citation format. I am unable to create the proper indents. The style dictates that if a citation is more than one line the second and subsequent lines are indented further in than the first line of the citation. This makes it easy to read multiple citations on a page.

I can achieve this in html using negative margins with css. I know the htmltextbox supported html/css is limited and so far I have not been able to create this formatting. 

Is there any way to do this?

I've thought about adding spaces or tab characters in my data dynamically at runtime taking into account the page size and font size but I was hoping there would be an easier way.

 

Stef
Telerik team
 answered on 27 Jan 2017
7 answers
1.7K+ views
Hi there,   
   I'm new to Telerik reporting and I'm haveing a problem with the expressions. I have 3 textboxes with number values and 1 other textbox that woill be the total of the 3. But when I run the report it gives me an error "The expression contains object "fldMMHQ_USD" that is not defined in the current context". I don't understand. The textbox is there, I see the values, but the "Total" textbox doesn't seem to the others. Here is my expression: = fldMMHQ_USD + fldMM_USD + fldEMPR_USD. Thanks for the help
Stef
Telerik team
 answered on 27 Jan 2017
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
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?