Telerik Forums
Reporting Forum
or
Ask question
All Questions
Unanswered
Answered
13,677 questions
2 answers
631 views
How To Load Data From Dataset Tables?

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.

General Discussions
LEON
Top achievements
Rank 1
 answered on 25 Mar 2020
1 answer
540 views
Currency and Floor/Ceiling

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?

 

Report Designer (standalone)
Katia
Telerik team
 answered on 24 Mar 2020
2 answers
148 views
Parameter box too wide and not visible

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

Report Designer (standalone)
P
Top achievements
Rank 1
 answered on 24 Mar 2020
1 answer
666 views
Changing DateTime parameter format and set time selection on html5 web form

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

General Discussions
Todor
Telerik team
 answered on 20 Mar 2020
1 answer
390 views
Reporting in ASP.NET Core - Config issue

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?

General Discussions
Al
Top achievements
Rank 1
 answered on 19 Mar 2020
1 answer
275 views
Edit or modify a report using Stand Alone Report designer

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?

General Discussions
Eric R | Senior Technical Support Engineer
Telerik team
 answered on 18 Mar 2020
10 answers
547 views
Line Chart - Smooth line curves backwards

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!

General Discussions
Eric R | Senior Technical Support Engineer
Telerik team
 answered on 18 Mar 2020
3 answers
225 views
Refresh report on a separate tab using JQuery.

     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?

 

 

General Discussions
Braden
Top achievements
Rank 1
 answered on 16 Mar 2020
3 answers
241 views
NavigateToUrlAction.Target not working

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.

General Discussions
Todor
Telerik team
 answered on 16 Mar 2020
5 answers
2.6K+ views
Unhandled Exception: System.IO.PathTooLongException: The specified path, file name, or both are too long...
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.IO.PathTooLongException: The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.
   at System.IO.PathHelper.GetFullPathName()
   at System.IO.Path.LegacyNormalizePath(String path, Boolean fullCheck, Int32 maxPathLength, Boolean expandShortPaths)
   at System.IO.Path.GetFullPathInternal(String path)
   at System.IO.Path.GetFullPath(String path)
   at System.Windows.Forms.IntSecurity.UnsafeGetFullPath(String fileName)
   at System.Windows.Forms.IntSecurity.DemandFileIO(FileIOPermissionAccess access, String fileName)
   at System.Windows.Forms.FileDialog.get_FileName()
   at System.Windows.Forms.FileDialog.OnBeforeVistaDialog(IFileDialog dialog)
   at System.Windows.Forms.FileDialog.RunDialogVista(IntPtr hWndOwner)
   at System.Windows.Forms.CommonDialog.ShowDialog(IWin32Window owner)
   at Fiddler.frmViewer.actSaveSessionArchive(IWin32Window wndOwner, Session[] arrSessions, String sSuggestedFilename) in C:\JenkinsHome\jobs\FiddlerReleaseBuild\workspace\Fiddler2\Viewer.cs:line 6393
   at System.Windows.Forms.MenuItem.OnClick(EventArgs e)
   at System.Windows.Forms.MenuItem.MenuItemData.Execute()
   at System.Windows.Forms.Command.Invoke()
   at System.Windows.Forms.Control.WmCommand(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at Fiddler.frmViewer.WndProc(Message& m) in C:\JenkinsHome\jobs\FiddlerReleaseBuild\workspace\Fiddler2\Viewer.cs:line 12337
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3221.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
----------------------------------------
Fiddler
    Assembly Version: 5.0.20182.28034
    Win32 Version: 5.0.20182.28034
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Fiddler.exe
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3221.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.3221.0 built by: NET472REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2612.0 built by: NET471REL1LAST_B
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Xceed.Zip.v5.4
    Assembly Version: 5.4.13572.13590
    Win32 Version: 5.4.13572.13590
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Xceed.Zip.v5.4.DLL
----------------------------------------
Xceed.Compression.Formats.v5.4
    Assembly Version: 5.4.13572.13590
    Win32 Version: 5.4.13572.13590
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Xceed.Compression.Formats.v5.4.DLL
----------------------------------------
Xceed.FileSystem.v5.4
    Assembly Version: 5.4.13572.13590
    Win32 Version: 5.4.13572.13590
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Xceed.FileSystem.v5.4.DLL
----------------------------------------
Xceed.Compression.v5.4
    Assembly Version: 5.4.13572.13590
    Win32 Version: 5.4.13572.13590
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Xceed.Compression.v5.4.DLL
----------------------------------------
Microsoft.mshtml
    Assembly Version: 7.0.3300.0
    Win32 Version: 7.0.3300.0
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.mshtml/7.0.3300.0__b03f5f7f11d50a3a/Microsoft.mshtml.dll
----------------------------------------
Fiddler.AtCacheInspectors
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Inspectors/Fiddler.AtCacheInspectors.dll
----------------------------------------
Standard
    Assembly Version: 2.6.2.0
    Win32 Version: 2.6.2.0
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Inspectors/Standard.DLL
----------------------------------------
SyntaxView
    Assembly Version: 2.6.2.0
    Win32 Version: 2.6.2.0
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Inspectors/SyntaxView.dll
----------------------------------------
FiddlerOrchestra.Addon
    Assembly Version: 1.0.20182.28033
    Win32 Version: 1.0.20182.28033
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Scripts/FiddlerOrchestra.Addon.dll
----------------------------------------
FiddlerOrchestra.Connection
    Assembly Version: 1.0.20182.28033
    Win32 Version: 1.0.20182.28033
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Scripts/FiddlerOrchestra.Connection.dll
----------------------------------------
netstandard
    Assembly Version: 2.0.0.0
    Win32 Version: 4.6.25908.2
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Scripts/netstandard.DLL
----------------------------------------
FiddlerOrchestra.Protocol
    Assembly Version: 1.0.20182.28033
    Win32 Version: 1.0.20182.28033
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Scripts/FiddlerOrchestra.Protocol.dll
----------------------------------------
FiddlerOrchestra.Utilities
    Assembly Version: 1.0.20182.28033
    Win32 Version: 1.0.20182.28033
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Scripts/FiddlerOrchestra.Utilities.dll
----------------------------------------
RulesTab2
    Assembly Version: 2.6.2.0
    Win32 Version: 2.6.2.0
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Scripts/RulesTab2.dll
----------------------------------------
SimpleFilter
    Assembly Version: 2.6.2.0
    Win32 Version: 2.6.2.0
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Scripts/SimpleFilter.dll
----------------------------------------
Timeline
    Assembly Version: 2.6.0.3
    Win32 Version: 2.6.0.3
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Scripts/Timeline.dll
----------------------------------------
Microsoft.JScript
    Assembly Version: 10.0.0.0
    Win32 Version: 14.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.JScript/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.JScript.dll
----------------------------------------
System.Windows
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2046.0
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Windows.dll
----------------------------------------
JScript Thunk Assembly
    Assembly Version: 0.0.0.0
    Win32 Version: 14.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.JScript/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.JScript.dll
----------------------------------------
KesKUZuK
    Assembly Version: 0.0.0.0
    Win32 Version: 14.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.JScript/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.JScript.dll
----------------------------------------
Microsoft.GeneratedCode
    Assembly Version: 1.0.0.0
    Win32 Version: 4.7.2612.0 built by: NET471REL1LAST_B
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Security
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2650.0 built by: NET471REL1LAST_B
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Security/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Security.dll
----------------------------------------
System.Net.Http
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2661.0 built by: NET471REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Net.Http/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Net.Http.dll
----------------------------------------
Microsoft.GeneratedCode
    Assembly Version: 1.0.0.0
    Win32 Version: 4.7.2612.0 built by: NET471REL1LAST_B
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Newtonsoft.Json
    Assembly Version: 11.0.0.0
    Win32 Version: 11.0.2.21924
    CodeBase: file:///C:/Users/Pavel_Balinski1/AppData/Local/Programs/Fiddler/Newtonsoft.Json.DLL
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.


General Discussions
FredDavis
Top achievements
Rank 1
 answered on 16 Mar 2020
Narrow your results
Done
Selected tags
Tags
General Discussions
Report Designer (standalone)
Report Designer - Web
.NET Core
Report Parameters
Report Viewer - HTML5
.NET Framework
Report Viewer - ASP.NET
Rendering
Report Viewer - Blazor
DataSource SQL
Report Viewer - Angular
DataSources
Table
Rest Service
Report Viewer - WPF
Expressions
Report Viewer - MVC
Binding
Programming
Report Viewer - WinForms
Styling
.NET 5
Conditional Formatting
Grouping
DataSource Object
Graph
Report Viewer - HTML5 WebForms
Report Book
Filtering
SubReport
Upgrade
DataSource JSON
DataSource WebService
CrossTab
Installation
PictureBox
HTMLTextBox
Licensing
Report Wizard
Serialization
Actions
Sorting
Converters
Security
Events
Interactivity
Performance
Accessibility
TOC
Localization
Map
DataSource CSV
Report Viewer - Silverlight
CrossSection
AI Coding Assistant
+? more
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Learn how
164 165
166
167 168
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Learn how
Want to show your ninja superpower to fellow developers?
Learn how