Telerik Forums
Reporting Forum
5 answers
1.3K+ views

As shown in the image, the Amount totals are calculating correctly ( Price*NetUnits=Amount). However, when using the SUM function in the Subtotal, the calculation is off by a penny. The SUM function is adding the amounts then Rounding which is causing the issue. See the calculations below.

Line 1 (7/25/2016) - Price $13.06 * Net Units 9.44 = Amount $123.286 (Rounded $123.29)

Line 2 (7/29/2016) - Price $13.06 * Net Units 8.30 = Amount $108.398 (Rounded $108.40)

Subtotal $123.286 + $108.398 = $231.684 (Rounded $231.68)

Line 1 + Line 2 = $231.69

Any help would be appreciated. Thanks!

 

Jennifer
Top achievements
Rank 1
 answered on 30 Sep 2016
2 answers
92 views
We seem to have encountered a rendering bug in the WPF ReportViewer (Q3 2013) where the last character in nearly all the text items inexplicably does not appear. 

In the attached image, the following problems are evident:
- On the vertical axis, PU001 should be seen, instead its PU00 (the 1 disappears off the end)
- On the horizontal axis, the first value after 0 should be 500 (instead its 50, the last 0 disappears off the end)
- In the legend, the blue box should have the label "Mitigated" (instead its "Mitigate", the last 'd' disappears off the end)

When the report is exported to pdf however, everything appears as expected, so I'm assuming this is a bug in the WPF Report viewer. Obviously it is very important that these values are displayed correctly (especially on the axis, where incorrect rendering can be mistaken for different values)
Stef
Telerik team
 answered on 30 Sep 2016
1 answer
49 views

Hello Telerik Team, 

I want to group the axis datetime type label as shown in image attached.

Thanks!

Vivek

Katia
Telerik team
 answered on 30 Sep 2016
2 answers
60 views

Hello Telerik team,

I want to create a area type series with vertical shading, i have also tried Monochromatic, gradient, but failed. Can you please help me in this? related images are attached.

Thanks!

Vivek

Katia
Telerik team
 answered on 30 Sep 2016
2 answers
65 views

Hi,

I am using radchart view control in winforms. I have problem is that i used a drill down event on that and define a Case 0 , Case 1 and Case 2 it means three level but when i was in third level and then click on chart it calls the drill down event and there is no any Case 3 is define so report populate blank.

I need to handle that when i am in third level and click on chart report should not populate blank and needs go back to third level.

How can do this in winforms using VB.Net.

Your help will be appreciable. 

Jake
Top achievements
Rank 1
 answered on 30 Sep 2016
8 answers
703 views
Hi,
 
I'm running VS 2015 in W10 (x64) with Telerik Reporting Q1 2015 SP1.
I'm developing a WPF application.
I'm getting the following XAML parse exception when attempting to show a Window containing a ReportViewer.
 
System.Windows.Markup.XamlParseException
 
Message: {"'Provide value on 'System.Windows.Markup.StaticResourceHolder' threw an exception. Line number '55' and line position '12'."}
BaseUri: {pack://application:,,,/Assets/Themes/Windows8/Telerik.ReportViewer.Wpf.xaml}
 
InnerException:
Message: {"Cannot find resource named 'Telerik.Windows.Controls.RadProgressBar'. Resource names are case sensitive."}
StackTrace:
 
   at System.Windows.StaticResourceExtension.ProvideValueInternal(IServiceProvider serviceProvider, Boolean allowDeferredReference)
   at System.Windows.StaticResourceExtension.ProvideValue(IServiceProvider serviceProvider)
   at MS.Internal.Xaml.Runtime.ClrObjectRuntime.CallProvideValue(MarkupExtension me, IServiceProvider serviceProvider)
 
The Click event handler for my "Generate Report" button is throwing the exception:
 
private void OnGenerateReportClick(object sender, RoutedEventArgs e)
{
    EnhListReportViewerWindow elrvw = new EnhListReportViewerWindow()
    elrvw.Show();
}
 
The exception is thrown on "elrvw.Show();".
 
My <Application.Resources> in App.xaml looks like this:
 
01.<runtime>
02.  <assemblyBinding>
03.    <dependentAssembly>
04.      <assemblyIdentity name="Telerik.Windows.Controls" publicKeyToken="5803cfa389c90ce7"/>
05.      <bindingRedirect oldVersion="0.0.0.0-2015.1.401.45" newVersion="2015.1.401.45"/>
06.    </dependentAssembly>
07.    <dependentAssembly>
08.      <assemblyIdentity name="Telerik.Windows.Controls.Input" publicKeyToken="5803cfa389c90ce7"/>
09.      <bindingRedirect oldVersion="0.0.0.0-2015.1.401.45" newVersion="2015.1.401.45"/>
10.    </dependentAssembly>
11.    <dependentAssembly>
12.      <assemblyIdentity name="Telerik.Windows.Controls.Navigation" publicKeyToken="5803cfa389c90ce7" />
13.      <bindingRedirect oldVersion="0.0.0.0-2015.1.401.45" newVersion="2015.1.401.45" />
14.    </dependentAssembly>
15.    <dependentAssembly>
16.      <assemblyIdentity name="Telerik.Windows.Data" publicKeyToken="5803cfa389c90ce7"/>
17.      <bindingRedirect oldVersion="0.0.0.0-2015.1.401.45" newVersion="2015.1.401.45"/>
18.    </dependentAssembly>
19.  </assemblyBinding>
20.</runtime>

 

The "Assets" folder is at the root of my project.
 
I have these Telerik assemblies (v4.0.30319) in my WPF project:
 
Telerik.Reporting                    (Q1 2015 SP1, 9.0.15.324)
Telerik.Reporting.XpsRendering       (Q1 2015 SP1, 9.0.15.324)
Telerik.ReportViewer.Wpf             (Q1 2015 SP1, 9.0.15.324)
Telerik.Windows.Controls             (2015.1.401.45)
Telerik.Windows.Controls.Docking     (2015.1.401.45)
Telerik.Windows.Controls.Input       (2015.1.401.45)
Telerik.Windows.Controls.Navigation  (2015.1.401.45)
Telerik.Windows.Data                 (2015.1.401.45)
 
My report library project is called "ConsoleReportLibrary".  It has one report at the root: "EnhancementList.cs".  ConsoleReportLibrary references Telerik.Reporting (9.0.15.324).
 
In the WPF project, my ReportViewer is declared in a Window like so:
 
<tr:ReportViewer
    Name="ReportViewer1">
    <tr:ReportViewer.ReportSource>
        <telerikReporting:TypeReportSource TypeName="ConsoleReportLibrary.EnhancementList, ConsoleReportLibrary"/>
    </tr:ReportViewer.ReportSource>
</tr:ReportViewer>
 
I have assembly redirects set up in App.config like so:
 
01.<runtime>
02.  <assemblyBinding>
03.    <dependentAssembly>
04.      <assemblyIdentity name="Telerik.Windows.Controls" publicKeyToken="5803cfa389c90ce7"/>
05.      <bindingRedirect oldVersion="0.0.0.0-2015.1.401.45" newVersion="2015.1.401.45"/>
06.    </dependentAssembly>
07.    <dependentAssembly>
08.      <assemblyIdentity name="Telerik.Windows.Controls.Input" publicKeyToken="5803cfa389c90ce7"/>
09.      <bindingRedirect oldVersion="0.0.0.0-2015.1.401.45" newVersion="2015.1.401.45"/>
10.    </dependentAssembly>
11.    <dependentAssembly>
12.      <assemblyIdentity name="Telerik.Windows.Controls.Navigation" publicKeyToken="5803cfa389c90ce7" />
13.      <bindingRedirect oldVersion="0.0.0.0-2015.1.401.45" newVersion="2015.1.401.45" />
14.    </dependentAssembly>
15.    <dependentAssembly>
16.      <assemblyIdentity name="Telerik.Windows.Data" publicKeyToken="5803cfa389c90ce7"/>
17.      <bindingRedirect oldVersion="0.0.0.0-2015.1.401.45" newVersion="2015.1.401.45"/>
18.    </dependentAssembly>
19.  </assemblyBinding>
20.</runtime>
 
The ReportViewer shows up in the designer with the Windows 8 theme, but something is going wrong at runtime.  Guidance?
 
Thanks,
ADJ
 
 
 
 
Kelly
Top achievements
Rank 1
 answered on 29 Sep 2016
2 answers
171 views

I've been tasked with creating a requisition form for lab orders that are sent to a third party. Using the Stand-alone Report Designer, the form itself I had no trouble with creating, but the third party has specified criteria that must be met on this form. The main item is a required PDF417 barcode. I cannot figure out the syntax required to build this barcode. I'm completely guessing at every step since there doesn't appear to be any documentation on this.
I have a blank report with the PDF417 Barcode Report Item added.

The Third Party requires the barcode have a structure like the following:
H||||^^||
P|||||||||^^|||||||||||^^|||||||||^^|||||||^|||||||||^|||||||||^^^^^^^^^^^^^^|^^^^^^^|||||||||||||||||^^|^^|^^|^^||||^||||||^^|^^^^|||^||
C|||||||||||||||||||^||||||||
A|||||||||||||||||||||^^|^|^||||||^^|^^^^^|||
M||||||
T|||||||||||||||||||||||||||||||||||||||||
S|^^^^^^|
D|||
L||
E||

Between the Pipe or Caret characters I'll need to populate my fixed values or data fields like the following 'P' segment:
P|Fields.P1_PtChartno||||||Fields.P7_Account_clientNo|Fields.P8_RequisitionNo|Fields.P9_PtNameLast^Fields.P9_PtNameFirst^Fields.P9_PtNameMiddle|Fields.P10_PtDOB

So in the Expression I put in this.
='P|'Fields.P1_PtChartno   + '||||||' + Fields.P7_Account_clientNo + '|' + Fields.P8_RequisitionNo + '|' + Fields.P9_PtNameLast + '^' + Fields.P9_PtNameFirst + '^' + Fields.P9_PtNameMiddle + '|' + Fields.P10_PtDOB

This didn't work, but it didn't error. Just no results when scanned. I found a post on the forum stating that if any field returns a NULL nothing will be displayed. So, I tried the suggested fix.
='P|'+isnull(fields.p1_ptchartno,"")+'||||||'+isnull(fields.p7_account_clientno,"")+'|'+isnull(fields.p57_externalsystemaccessionno,"")+'|'+isnull(fields.p9_ptnamelast,"")+'^'+isnull(fields.p9_ptnamefirst,"")+'^'+isnull(fields.p9_ptnamemiddle,"")+'|'+isnull(fields.p10_ptdob,"")+'|'

Progress! Although not entirely correct data, I got results:
P|44555|||||||JBF|JONES^JOHNNY^|CAAAAIAE|

Issue here is the value ‘JBF’ should be ‘915’ and ‘CAAAAIAE’ should ‘20000804’

If I add another segment the issue shifts fields:
='H|EDIFECS|'+ IsNull(Fields.H2_reqdate,"")+'|'+IsNull(Fields.H3_ediident,"")+'|^^||'
+'P|'+isnull(fields.p1_ptchartno,"")+'||||||'+isnull(fields.p7_account_clientno,"")+'|'+isnull(fields.p57_externalsystemaccessionno,"")+'|'+isnull(fields.p9_ptnamelast,"")+'^'+isnull(fields.p9_ptnamefirst,"")+'^'+isnull(fields.p9_ptnamemiddle,"")+'|'+isnull(fields.p10_ptdobconvert,"")+'|'

Returns,
H|EDIFECS|20160927|e|^^||
#|EEFFF|||||||915|9:,4$Y9:7,,^Y|20000804|
P returns as #, 44555 as EEFFF, and JONES^JOHNNY^ as 9:,4$Y9:7,,^Y

I know I’m doing it wrong, but I can’t find the correct way to format the expression.

Anthony
Top achievements
Rank 1
 answered on 28 Sep 2016
1 answer
350 views

Hi,

I am working in .NET (MVC5). 

My problem is with cross-origin resource sharing. When I am trying to get telerikReportViewerTemplate-html in Chrome (IE and Edge are working OK) I am getting this error: 

"XMLHttpRequest cannot load http://localhost:56878/api/reports/resources/templates/telerikReportViewerTemplate-html. No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'http://localhost:58343' is therefore not allowed access."

This is my code in JS calling report viewer:

            $('#reportViewer').telerik_ReportViewer({
                "serviceUrl": "http://localhost:56878/api/reports/",
                "scale": 1.0,
                "persistSession": false,
                "parametersAreaVisible": true,
                "documentMapVisible": true,
                "viewMode": "INTERACTIVE",
                "scaleMode": "SPECIFIC",
                "printMode": "AUTO_SELECT",
                "renderingBegin": "",
                "renderingEnd": "",
                "printBegin": "",
                "printEnd": "",
                "exportBegin": "",
                "exportEnd": "",
                "updateUi": "",
                "error": "",
                "pageReady": "",
                "ready": "",
                "parameterEditors": []
            });

 

How can I put a permissions in request header?

 

Stef
Telerik team
 answered on 28 Sep 2016
11 answers
893 views
Hi,
I'm getting the "classic" error message: Report is unavailable or session has expired.
I have read your faq:
http://www.telerik.com/support/kb/reporting/report-viewers/report-is-unavailable-or-session-has-expired-error-message.aspx
where you list "Problem" and "Solution".
First:
I don't agree that you list the solution, you just describes three possible causes, not how to solve them! :)

Second:
I'm curious, why the need of sessions? Why keep, as you say in the faq, resources as images and html pages in sessions?
How often do you load the same report twice so you need to locally store the information?

Third (the real question :) ):
We have a website on one domain and from there links to another domain (on a different server) where the reports are generated.
So the problem is obvious, I surf on the website and maybe generates a report. Then I surf a little more on the website and after a while I want to generate another report. What happens? The report domain has of course timed out.

How can I solve this problem?

(We load the reports in a RadWindow if that could be something the causes the error)

Regards,
Mattias




Stef
Telerik team
 answered on 28 Sep 2016
8 answers
410 views

Hi admin,

I'm using telerik reporting 2015 Q2 on a WPF project. A textbox in the report may contains tab characters for formatting a remarks field. On the print preview the tab characters are there and you will see the value of remarks field formatted by tab characters. But when producing print output, the tab characters are not there anymore. This also happens when I try to export the print preview to any format (PDF, Excel, Word, etc.)

 

Help is much appreciated. 

Thank you!

Stef
Telerik team
 answered on 27 Sep 2016
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?