Telerik Forums
Reporting Forum
3 answers
361 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
608 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
504 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
124 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
629 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
347 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
228 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
10 answers
494 views

Hello,

I'm currently trying to create a line chart programmatically and was successfully able to do so. However I noticed that in certain cases, the smooth line type produces odd results. When the x-axis has a date scale and 2 points are too close to one another, depending on the y-axis values the line will sometimes curve backwards (see the black line in the smooth_line attachment). I'm using a cartesian coordinate system as recommended by your documentation. I've attached images of the chart using both straight and smooth line types. The data is the same, only the line type is different. We have not had this issue creating similar line charts in kendo jquery ui or kendo angular. We would like to use the smooth line type (instead of the straight) for our reporting charts. Is there way to prevent this issue from happening, or is there a different coordinate system that we can use to achieve the desired results? Please advise. Thanks!

Eric R | Senior Technical Support Engineer
Telerik team
 answered on 18 Mar 2020
3 answers
211 views

     I have a page that has 5 separate tabs. The first tab is set to active so it will load first. The Telerik Report is on the 5th tab so it will not load automatically. It will only load automatically if it's the first tab. I've tested this by setting the tab with the report as the first tab and it will load just fine.

Previously we were using 2016 R3 version and using the command:

$("[data-command='telerik_ReportViewer_refresh']").first().click();

This never gave us issues. We recently upgraded to 2020 R1 and now this command will not work. Is there a way to refresh the page manually by JQuery?

 

 

Braden
Top achievements
Rank 1
 answered on 16 Mar 2020
3 answers
226 views

Hello,

We currently have a picture box on our PDF report that we want to open in a new tab / window on click but it is not working.

The designer file looks like this

            // 
            // pictureBox1
            // 
            navigateToUrlAction1.Url = "= MapLocation(Fields.UniqueId)"; // This calls and returns a url and is working fine
            navigateToUrlAction1.Target = Telerik.Reporting.UrlTarget.NewWindow; // Added this manually just in case, when using the designer and choosing New window under Link target it does not add this line, I assume its default behavior?
            this.pictureBox1.Action = navigateToUrlAction1;

 

We have tried to set the url to just http://google.com but same results.

Todor
Telerik team
 answered on 16 Mar 2020
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?