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.
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.
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?
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
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
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?
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?
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!
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?
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.