Telerik Forums
Reporting Forum
5 answers
2.4K+ views
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.


FredDavis
Top achievements
Rank 1
 answered on 16 Mar 2020
2 answers
100 views
I have a dataset of products I'm trying to graph from a web service. When using the date field (which is a unix timestamp) as the category and the count of IDs as the values it's providing the incorrect results, even when I set the base unit to days/months/years etc. When I use another field other than date, the count returns what it should (as displayed in the difference between the two graphs in the screenshot). I've experimented with changing the groupings via the ToString() method on the date however it is producing inconsistent results. Any advice on what might be causing this?
Lachlan
Top achievements
Rank 1
 answered on 12 Mar 2020
1 answer
12.0K+ views
When I try to open the designer in visual studio I get the following error:
Value cannot be null. Parameter name: instance

I tried reinstalling the latest version of reporting but that did not fix it.

The designer worked before, the error began happening randomly one day.

Any suggestions?



Todor
Telerik team
 answered on 12 Mar 2020
7 answers
993 views

i followed the attachment in this post to create an object datasource. now i have to pass ten parameters into the datasource for getting some data from a query with almost one billion rows if not applied parameters. since i need to reuse existing infrastructure i have to use the method in our data layer project to get data. so adding dynamic object datasource is a must. how will i pass these parameters to the object datasource

also i would like to know if there is any way to pass all these 10 parameters as a model so i can forward the model from our webapi controller?

Todor
Telerik team
 answered on 11 Mar 2020
4 answers
398 views

Hello,

This is a thread that continues from the following post: https://www.telerik.com/forums/filter-graph-data

To give a default value to a graph, I have used this expression in the report parameter:

= AddMonths(Last(Fields.wDate), -12)

The above displays the past 12 months of data on a graph which has 5 years (60 months) of data.

However, the data that I have does not include weekends and public holidays. So in scenarios such as:

Latest date (Last(Fields.wDate)) is 2nd March 2020, and the 12 month previous data is from 2nd March 2019. 2nd March 2020 is on a Monday so data is recorded, but 2nd March 2019 was on a Saturday hence there is no data on it, which results in an error saying 'Missing or invalid parameter value. Please input valid data for all parameters.'

Is there a way where, if the -12 value is on a weekend or public holiday, it picks the data closest to it, for e.g. 4th March in this case. Or alternatively a function where I just get the latest year's worth of data by default? I have tried = Today().AddMonths(-12) but it also has the same issue.

I have also attached a screenshot of my report parameter.

Thank You

Kunal
Top achievements
Rank 1
 answered on 10 Mar 2020
3 answers
306 views
I create a report from JsonFile, I'm using vuejs, with asp.netcore, if i wanna change the json DataSource, for the data that i got from the consul to the REST api i vue, How can i do it dinamically
Todor
Telerik team
 answered on 10 Mar 2020
2 answers
96 views

Hello,

 I have an HTML Text Box that is rendering text as (at least) a double spaced. This needs to be single spaced. I have tried setting each list Item's (<li>

) enclosing span  to a line height of 105% and 100%  for two different attempts. Neither changed the spacing.

How is line spacing set?

 

HTML:

<p><span style="font-size: 13px; font-family: consolas"><span style="font-size: 13px; font-family: consolas">&nbsp;Notes to Merchant:</span></span></p><p><span style="font-size: 13px; font-family: consolas"><span style="font-size: 13px; font-family: consolas"> <p></p><p></p></span><p></p></span></p><p></p><p></p><p></p><p></p><p></p><p></p><ol><li><p><span style="font-size: 13px; font-family: consolas; line-height: 100%"><span style="font-size: 13px; font-family: consolas">&nbsp;1. No substitution of any articles allowed</span></span></p></li><li><p><span style="font-family: consolas; line-height: 100%">&nbsp;<span style="font-size: 13px"><span style="font-size: 13px">2. Articles must not exceed the stated cost of $200.00, unless with authorized signature.</span></span></span></p></li><li><p><span style="font-family: consolas; line-height: 100%">&nbsp;<span style="font-size: 13px"><span style="font-size: 13px">3. Invoices must not exceed the stated amount on the request form, unless with authorized signature.</span></span></span></p></li><li><p><span style="font-family: consolas; line-height: 100%">&nbsp;<span style="font-size: 13px"><span style="font-size: 13px">4. Do not accept request forms from parents 30 past date marked on voucher.</span></span></span></p></li><li><p><span style="font-family: consolas; line-height: 100%">&nbsp;<span style="font-size: 13px"><span style="font-size: 13px">5. All invoices must be received 30 days from the date of distribution to be honored.</span></span></span></p></li><li><p><span style="font-family: consolas; line-height: 100%">&nbsp;<span style="font-size: 13px"><span style="font-size: 13px">6. Send or bring invoices monthly to:</span></span></span></p></li></ol><p><span style="font-family: consolas"></span></p><p><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff">&lt;</span></span></span><span style="font-size: 13px; font-family: consolas; color: #800000"><span style="font-size: 13px; font-family: consolas; color: #800000"><span style="font-size: 13px; font-family: consolas; color: #800000">div</span></span></span><span style="font-size: 13px; font-family: consolas"><span style="font-size: 13px; font-family: consolas"> </span></span><span style="font-size: 13px; font-family: consolas; color: #ff0000"><span style="font-size: 13px; font-family: consolas; color: #ff0000"><span style="font-size: 13px; font-family: consolas; color: #ff0000">style</span></span></span><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff">="</span></span></span><span style="font-size: 13px; font-family: consolas; color: #ff0000"><span style="font-size: 13px; font-family: consolas; color: #ff0000"><span style="font-size: 13px; font-family: consolas; color: #ff0000">text-align</span></span></span><span style="font-size: 13px; font-family: consolas"><span style="font-size: 13px; font-family: consolas">:</span></span><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff">center"&gt;</span></span></span><span style="font-size: 13px; font-family: consolas"><span style="font-size: 13px; font-family: consolas">Baltimore City Schools</span></span><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff">&lt;</span></span></span><span style="font-size: 13px; font-family: consolas; color: #800000"><span style="font-size: 13px; font-family: consolas; color: #800000"><span style="font-size: 13px; font-family: consolas; color: #800000">br</span></span></span><span style="font-size: 13px; font-family: consolas"><span style="font-size: 13px; font-family: consolas"> </span></span><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff">/&gt;</span></span></span><span style="font-size: 13px; font-family: consolas"><span style="font-size: 13px; font-family: consolas">Office of Home and Hospital Program</span></span><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff">&lt;</span></span></span><span style="font-size: 13px; font-family: consolas; color: #800000"><span style="font-size: 13px; font-family: consolas; color: #800000"><span style="font-size: 13px; font-family: consolas; color: #800000">br</span></span></span><span style="font-size: 13px; font-family: consolas"><span style="font-size: 13px; font-family: consolas"> </span></span><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff">/&gt;</span></span></span><span style="font-size: 13px; font-family: consolas"><span style="font-size: 13px; font-family: consolas">2000 Edgewood Street – Lower Level</span></span><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff">&lt;</span></span></span><span style="font-size: 13px; font-family: consolas; color: #800000"><span style="font-size: 13px; font-family: consolas; color: #800000"><span style="font-size: 13px; font-family: consolas; color: #800000">br</span></span></span><span style="font-size: 13px; font-family: consolas"><span style="font-size: 13px; font-family: consolas"> </span></span><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff">/&gt;</span></span></span><span style="font-size: 13px; font-family: consolas"><span style="font-size: 13px; font-family: consolas">Baltimore, MD 21216</span></span><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff">&lt;</span></span></span><span style="font-size: 13px; font-family: consolas; color: #800000"><span style="font-size: 13px; font-family: consolas; color: #800000"><span style="font-size: 13px; font-family: consolas; color: #800000">br</span></span></span><span style="font-size: 13px; font-family: consolas"><span style="font-size: 13px; font-family: consolas"> </span></span><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff">/&gt;</span></span></span><span style="font-size: 13px; font-family: consolas"><span style="font-size: 13px; font-family: consolas">Attention: Allen Blackwell / Annette White</span></span><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff">&lt;/</span></span></span><span style="font-size: 13px; font-family: consolas; color: #800000"><span style="font-size: 13px; font-family: consolas; color: #800000"><span style="font-size: 13px; font-family: consolas; color: #800000">div</span></span></span><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff"><span style="font-size: 13px; font-family: consolas; color: #0000ff">&gt; <p></p><p></p><p></p></span></span></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><ol></ol> 

Michael
Top achievements
Rank 1
 answered on 10 Mar 2020
2 answers
106 views

 I need to print a voucher document, one page/ document per person.

 I have defined a data source to retrieve a single record (Select FullName, StudentId from Table where Student ID = '1234567')  but when I try to set the value of a text box in 'Edit Expression' there are no Fields in the Field list. When I key in =Fields.FullName, nothing appears in the preview. When I key in [=Fields.FullName] then I see [=Fields.FullName] in the Preview.

 

What am I missing?

 

Thank you

Michael
Top achievements
Rank 1
 answered on 10 Mar 2020
3 answers
113 views

Hi, 
I have the following problem. I have a report that contains a few graphs with X axis as DateTime and a subreport which is also a graph reused in many reports. It is not acceptable to me to set label, major and minor points units and ranges in designer since in one case I can have 7 days process, and in other case 5 minutes process. According to this I need to calculate total time and decide if I will set label, major and minor points in seconds, minutes or hours, and also to calculate range so that I have approximately 10 major points on the graphs X axes. To achieve this i am modifying values set in designer programmatically at runtime. I tried the following approaches, neither is working:

1. I used ItemDataBound event on report and subreport hoping that in the time it fires I will have report data source filled, so that I can use data source to get collection of data to calculate. This was not the case. Data source was still null at the time of firing. 

2.I tried to calculate explicitly by calling the public method in a report that will do the calculation. This was a successful approach for the graphs in the report since I call this method from outside the report after assigning data source, but still can't find a way to call public method in the subreport from the main report after the subreport bound the data source.

I would appreciate help.

Todor
Telerik team
 answered on 09 Mar 2020
1 answer
9.9K+ views
i know that it has been said that the IIf function evaluates both the true and false expression and reports an error if either causes an error and this is done by design. I'm just confused how, without a user function, to do certain, everyday things. For example.. In case of this simple report:

item.... sold... avg price.. in stock..  avg days
A112       5        112.00             5               22
A113       0            !DIV             1               12
A114       1        114.00             0             !DIV

in a normal situation you would get the avg price by using the expression =iif(Fields.sold>0,Fields.totalprice/Fields.sold,0) and avg days in stock =iif(Fields.instock>0,Fields.totaldaysinstock/Fields.instock,0)
but in telerik reports the expression will cause a divide by 0 error because both expressions in the iif() are evaluated. These are simplified examples and I understand there is an avg() function, but there is more processing going on that voids it's use.

Todor
Telerik team
 answered on 06 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?