Telerik Forums
Reporting Forum
5 answers
519 views

Hi,

When generating a PDF report using the ReportProcessor from a trdx report,
is it possible to catch errors such as if a used field in the template is
not present in the dataset?

I'm using the ErrorEventHandler like this, but it is not triggered if a used field is not present in dataset.
It just renders the report anyway and leaves the label empty.

...
reportObject.Error += (innerSender, eventArgs) =>
{
    _logger.Error(eventArgs.Exception, "Error processing report PDF", reportId, parameters);
};


If you don't support it today, it would be great if I could decide, whether or not the processor should trigger the error handler in cases like this.

Cheers,
Casper

Ivan Hristov
Telerik team
 answered on 27 Mar 2020
1 answer
9.0K+ views

I'm currently reviewing Telerik Reporting (version Q2 2011, 5.1.11.713) and I run into an issue with a textbox with a fixed width, but allowed to grow vertically. The calculation of the number of lines (required to wrap the given text in) fails. The text (Value) below is actually wrapped in a single-line textbox, but actually doesn't fit on one line and gets wrapped! This is obviously not what we want (see attachment).

Properties set:

CanGrow = True
CanShrink = False
KeepTogether = True
Size = 8,91cm; 0,5cm
Value = "Courtage conform bemiddelinsovereenkomst d.d. 1-10-2011"
Style.Font = Verdana, 8pt, Regular
Style.VerticalAlign = Middle

Any help would be greatly appreciated!

Best regards,
Raymond

Deepak
Top achievements
Rank 1
 answered on 27 Mar 2020
2 answers
636 views

I've implemented the Telerik Reporting engine in a remote ASP.NET Core Web API by following this article. The implementation works as expected - I'm able to retrieve my report template, bind it to data & have a WinForms ReportViewer control render it on the client-side application.

I now wish to implement the ability to automatically print the reports without having to display a UI to users. Ideally we want them to click a button in the application (not from a ReportViewer toolbar) & have the report sent immediately to the printer. We will have the necessary settings available programmatically to configure the printer.

I'm aware of the ReportProcessor.PrintReport() method, which will allow me to do this. What I'm having trouble with is how to configure a ReportSource object that will be passed as the first parameter to PrintReport() that will allow it to request the report from my remote report endpoint. When displaying these reports in the ReportViewer control, a connection string is configured for the remote report server, but I can find no similar concept of any of the ReportSource objects. The closest I could get was by using UriReportSource, but I'm unsure what to set the Uri property to.

Any assistance would be greatly appreciated.

 

 

 

Hein
Top achievements
Rank 1
 answered on 26 Mar 2020
3 answers
366 views

Telerik Reporting - Telerik.ReportViewer.Blazor Version 14.0.20.115

This is the entirety of the page on which the ReportViewer is displayed:

 

<ReportViewer ViewerId="reportViewer1"
              ReportServer="@(new ReportServerOptions {  Url = "https://reporting.$WEBSITE.com", Username = "$NAME", Password = "$PASS" })"
              ReportSource="@(new ReportSourceOptions()
                            {
                              Report = "Foundation/LicenseUsages.trdp"
                            })"
              ParametersAreaVisible="true"
              ScaleMode="@(ScaleMode.Specific)"
              Scale="1.0" />

 

Expected behavior: The parameters area should be visible when the report loads.

Observed behavior: The parameters area is not visible by default, even though the button on the ReportViewer implies it should be. The button must be toggled off then on again to see the parameters area.

Eric R | Senior Technical Support Engineer
Telerik team
 answered on 25 Mar 2020
2 answers
616 views

I recently trying to understand how Telerik reporting works, most of the tutorials are based on the SQL server. I am using MS Access for a small project where the embedded database needed. I have some business logic running on the background. All the customise data stored in a Dataset table. While working with MS RDLC I can easily bind the data source to that particular dataset from the Report Data tab. But don't understand how can I achieve the same using Telerik Reporting.

I already visited below forum thread from 2013, but still cant understood.

Is it possible to use a dataset as the datasource for a report with groups?

 

is there any step by step guide for the beginners? I have already read the Docks. it will be very helpful if someone uploads an example project.

LEON
Top achievements
Rank 1
 answered on 25 Mar 2020
1 answer
514 views

I am trying to show a customer the total amount remaining after a 50% deposit plus whatever extra payments have been made.

The expression I'm using is:

 

= Floor(Fields.SubTotal - (Fields.SubTotal * .5) - IsNull(Fields.Payments, 0))

The field format is currency with two decimal places to account for dollars and cents. I assumed that Floor() would account for that fact and round every number down to the nearest penny. $1,350.375 would in fact become $1,350.37. Instead, Floor() is rounding to the nearest dollar and the value I get is $1,350.00. Does Floor/Ceiling take into account the format I want my number to be in? If not, why not? That seems intuitive to me but apparently it isn't to the developers who worked on those specific functions.

I end up with one field showing the deposit (50%): 1,350.38

and another field with the balance owing: 1,350.38

I realized that in the formula above, the portion (Fields.SubTotal * .5) doesn't convert this value to two decimal places (it remains 1,350.375) and so it subtracts 1,350.375 from the Subtotal (2,700.75), returning the value 1,350.375 which it then rounds up to 1,350.38 But when you add the Balance Owing to the original deposit, I always get a value that is one penny higher than the original subtotal.

Is there a way to do this correctly in the Standalone Reporter?

 

Katia
Telerik team
 answered on 24 Mar 2020
2 answers
126 views

Hello, 

Is there a way to set max width for parameter boxes in the parameter area?

I am using a drop-down parameter with string values. The box becomes very wide because it contains some long string values but then it becomes unusable. See the attached pictures.

 

Best Regards

P
Top achievements
Rank 1
 answered on 24 Mar 2020
1 answer
636 views

I have tried to change USA MM/dd/yyyy format to Finnish dd.MM.yyyy and also add time part in HH:mm:ss to html5 web form page. I have tried it with editing datetime parameter editor customization from these links guidance:

https://docs.telerik.com/reporting/html5-report-viewer-howto-custom-parameter-editor

https://www.telerik.com/forums/report-parameter-datetime-picker-format-on-ui#WWhMNlOLgEODawH80sWuzg

https://docs.telerik.com/kendo-ui/api/javascript/ui/datetimepicker

but format is still MM/dd/yyyy when displayed and no time possible to select or set

 

 

My project is mainly copy from your html5 web form example where I have added script part is next:

<script type="text/javascript">
    $(document).ready(function () {
       $("#reportViewer1")
           .telerik_ReportViewer({
               reportServer: "~/",
               parameterEditors: [
               {
                   match: function (parameter) {
                      return parameter.type === "System.DateTime";
                  },
 
                  createEditor: function (placeholder, options) {
                      $(placeholder).html('<input type="datetime"/>');
                      var dateTimePicker = $(placeholder),
                                           parameter,
                                           valueChangedCallback = options.parameterChanged,
                                           dropDownList;
 
                      function onChange() {
                          var dtv = this.value();
                          if (null !== dtv) {
                              dtv = myadjustTimezone(dtv);
                          }
                          valueChangedCallback(parameter, dtv);
                      }
 
                      return {
                          beginEdit: function (param) {
                              parameter = param;
 
                              var dt = null;
                              try {
                                  if (param.value) {
                                      dt = myunadjustTimezone(param.value);
                                  }
                              } catch (e) {
                                  dt = null;
                              }
 
                              $(dateTimePicker).find("input").kendoDateTimePicker({
                                  format: "dd.MM.yyyy HH:mm:ss",
                                  parseFormats: ["MM.dd.yyyy", "HH:mm:ss"],
                                  change: onChange,
                                  value: dt
                              });
 
                              dropDownList = $(dateTimePicker).find("input").data("kendoDateTimePicker");
                          }
                      }
                  }
               }]
           });
    });
 
    function myadjustTimezone(date) {
        return new Date(Date.UTC(date.getFullYear(), date.getMonth(), date.getDate(), date.getHours(), date.getMinutes(), date.getSeconds(), date.getMilliseconds()));
    };
    function myunadjustTimezone(date) {
        return new Date(date.getUTCFullYear(), date.getUTCMonth(), date.getUTCDate(), date.getUTCHours(), date.getUTCMinutes(), date.getUTCSeconds(), date.getUTCMilliseconds());
    };
</script>

 

Regards

Harri

Todor
Telerik team
 answered on 20 Mar 2020
1 answer
363 views

I've been struggling to get reports running in ASP.NET Core.  

I have the demo and it works.  It is a Core 2.2 app.  I've tried to add it in to my app which is a 3.1 app nothing is going well.

I started with the beautiful "Cannot access the Reporting REST service" error. Reading through tons of things I figured out my reports controller is giving an error.

So now I'm trying to get /api/reports/formats to display properly.  I'm hoping if I can get this working, the rest will fall in to place. It work in the demo, but I get:

InvalidOperationException: Property 'JsonResult.SerializerSettings' must be an instance of type 'System.Text.Json.JsonSerializerOptions'.

Can anyone give me a pointer in the right direction?

Al
Top achievements
Rank 1
 answered on 19 Mar 2020
1 answer
241 views

I have created a Telerik reporting application with MVC. I was able to publish and deploy the Application to one of the Azure server.

Now my Question is, how to edit or modify a report from the server using Stand Alone Report designer and publish it back to the server?

Eric R | Senior Technical Support Engineer
Telerik team
 answered on 18 Mar 2020
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?