Telerik Forums
Reporting Forum
1 answer
456 views

Hello,

I am working on a report that should contains multiple tables with four columns. Each table is bound to a collection of the following data:
Class{
    public string item1 {get; set;}
    public string item2 {get; set;}
    public string Description1 {get; set;}
    public string Description2 {get; set;}

The cells of the first and second column should be merged when Item2 is an empty string. The same for the Description columns. I tried to adjust the TexBox sizes using the ItemDataBound events but this does not work. The column is rendered as wide as the largest text box.

The output should look like this:
Item1   Item2   Description1   Description2
Item11111111   Description11111111111111
Item1   Item2   Description1   Description2
Item1   Item2   Description1   Description2
Item11111111   Description11111111111111

Any help would be appreciated.
Regards,
Bert 

Katia
Telerik team
 answered on 04 Oct 2016
2 answers
138 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
90 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.6K+ 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
142 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
93 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
94 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
103 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
874 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
271 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
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?