Telerik Forums
Reporting Forum
2 answers
111 views

I have a basic crosstab on a report.  Everything works fine and appears as desired when all is collapsed.

When a group is expanded (based on Action = ToggleVisibility ), it works as expected, but everything blends together visually, with no visual distinction between the expanded cells and the cells that were visible before expanding.

What I'd like to do is style the expanded cells with a different background so they'll easily stand out.

This crosstab is similar to this demo: http://demos.telerik.com/reporting/product-sales 

In that demo, when one of the Years is expanded, the newly visible cells are the same in appearance as those before expanding.  e.g. If you expand 2002, the quarter values are visible and appear the same as the year values that were already present... The Q1 value of 4.9 appears the same as the 2001 value of 20.2 - is there a way to style the 4.9 cell differently?

Attached is picture of my crosstab and the desired results.

Thanks much!

 

B
Top achievements
Rank 1
 answered on 03 Oct 2016
1 answer
74 views
IDE : Visual Studio 2015
Reporting Version : Q2 2016 (10.1.16.615)
Host: IISExpress

I create DummyMain report that must be call DummySubreport with programmatically.
When i run the report on first time after start solution, the TextBox with expression Fields.Id has error "object reference not set for subreport" on the first page but other page has not error.

Please, see the error image and report in the attachment file. 

link:https://drive.google.com/file/d/0B9yIfZcD3RmJX2dGR3RoOHo2ajg/view?usp=sharing 

Let me know what needs to be fix?  Thanks.
Katia
Telerik team
 answered on 03 Oct 2016
5 answers
1.5K+ 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
118 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
76 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
79 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
88 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
808 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
231 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
368 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
Top users last month
Cynthia
Top achievements
Rank 1
Iron
Toby
Top achievements
Rank 3
Iron
Iron
Iron
Danielle
Top achievements
Rank 1
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Iron
yw
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?