Telerik Forums
Reporting Forum
2 answers
176 views
Hello all,
I have a reportviewer on aspx page to which i m getting a login report. 
On the report i have a graph named graph_LoginByDate. I have a dataset coming from a stored procedure.
DataSet ds_LoginsCount = Sql.GetDataset("[SP_LoginsByDate]");
graph_LoginByDate_ImpactsByDate.DataSource = ds_LoginsCount ; This dataset has just two columns "Date" and the "count". Can some one explain how i an assign date to the X-axis and Count to the Y-axis. 
I have tried this: (there is not category. All i am trying to to just plot the date vs logins count)
var countDateGroup = new Telerik.Reporting.GraphGroup();
countDateGroup .Name = "seriesGroup1";
countDateGroup.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.Date"));
countDateGroup.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.Date", Telerik.Reporting.SortDirection.Asc));
graph_LoginByDate.SeriesGroups.Add(countDateGroup );


var graphAxisNumericScale = new Telerik.Reporting.GraphAxis();
graphAxisNumericScale.Name = "GraphAxis2";                    
graphAxisNumericScale.Scale = new Telerik.Reporting.NumericalScale();

var cartesianCoordinateSystem1 = new Telerik.Reporting.CartesianCoordinateSystem();
cartesianCoordinateSystem1.Name = "cartesianCoordinateSystem1";
cartesianCoordinateSystem1.XAxis = graphAxisNumericScale;
cartesianCoordinateSystem1.YAxis = graphAxisNumericScale;
graph_LoginByDate.CoordinateSystems.Add(cartesianCoordinateSystem1);

var lineSeries1 = new Telerik.Reporting.LineSeries();

lineSeries1.CoordinateSystem = cartesianCoordinateSystem1;
lineSeries1.LegendItem.Value = "= Fields.Date";
lineSeries1.SeriesGroup = countDateGroup;
lineSeries1.Y = "=Fields.Count";
graph_LoginByDate.Series.Add(lineSeries1);
I cant do this through properties. It has to be done programatically. Please let me know where i m doing the mistake.
Thank you,
Nasko
Telerik team
 answered on 26 Sep 2016
1 answer
296 views

Our application uses Telerik reportviewer to priview  Reports  before export reports to pdf or print it. After update from privious version telerik our Applicatoin crashes during Creating ReportViewer with

System.TypeInitializationException

The type initializer for 'Telerik.Reporting.Processing.RenderingExtensionManager' threw an exception.

here is an Stacktrace:

  at Telerik.Reporting.Processing.RenderingExtensionManager.get_RenderingExtensions()
   at Telerik.ReportViewer.Wpf.ReportViewerModel.GetRenderingExtensions()
   at Telerik.ReportViewer.Wpf.ReportViewerModel..ctor(Size pageViewportSize, Dispatcher dispatcher)
   at Telerik.ReportViewer.Wpf.ReportViewer.CreateModel()
   at Telerik.ReportViewer.Wpf.ReportViewer.Initialize()
   at System.Windows.FrameworkElement.ApplyTemplate()
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at System.Windows.Controls.Grid.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at MS.Internal.Helper.MeasureElementWithSingleChild(UIElement element, Size constraint)
   at System.Windows.Controls.ContentPresenter.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at System.Windows.Controls.Border.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at System.Windows.Controls.Control.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at System.Windows.Controls.Grid.MeasureCell(Int32 cell, Boolean forceInfinityV)
   at System.Windows.Controls.Grid.MeasureCellsGroup(Int32 cellsHead, Size referenceSize, Boolean ignoreDesiredSizeU, Boolean forceInfinityV, Boolean& hasDesiredSizeUChanged)
   at System.Windows.Controls.Grid.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at MS.Internal.Helper.MeasureElementWithSingleChild(UIElement element, Size constraint)
   at System.Windows.Controls.ContentPresenter.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at System.Windows.Controls.Border.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at System.Windows.Controls.Control.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at MS.Internal.Helper.MeasureElementWithSingleChild(UIElement element, Size constraint)
   at System.Windows.Controls.ContentPresenter.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at System.Windows.ContextLayoutManager.UpdateLayout()
   at System.Windows.Controls.TabItem.OnPreviewGotKeyboardFocus(KeyboardFocusChangedEventArgs e)
   at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
   at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)

with inner Exception: System.Configuration.ConfigurationErrorException

An error occurred creating the configuration section handler for Telerik.Reporting: Could not load file or assembly 'Telerik.Reporting, Version=10.2.16.614, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

   at System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord(String configKey, Boolean& isRootDeclaredHere)
   at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
   at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)
   at System.Configuration.ConfigurationManager.GetSection(String sectionName)
   at Telerik.Reporting.Configuration.ReportingConfiguration.get_Current()
   at Telerik.Reporting.Processing.RenderingExtensionManager..cctor()

 

I checked the assembys lying in Application order. the versions seem to be as it written in App section

<section name="Telerik.Reporting" type="Telerik.Reporting.Configuration.ReportingConfigurationSection, Telerik.Reporting, Version=10.2.16.614, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" allowLocation="true" allowDefinition="Everywhere" />

<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Telerik.Windows.Controls" publicKeyToken="5803cfa389c90ce7" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-2016.2.613.40" newVersion="2016.3.914.45" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="DocumentFormat.OpenXml" publicKeyToken="31bf3856ad364e35" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-2.5.5631.0" newVersion="2.5.5631.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Telerik.Windows.Controls" culture="neutral" publicKeyToken="5803cfa389c90ce7" />
        <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="2016.3.914.45" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Telerik.Windows.Controls.Input" culture="neutral" publicKeyToken="5803cfa389c90ce7" />
        <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="2016.3.914.45" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Telerik.Windows.Controls.Navigation" culture="neutral" publicKeyToken="5803cfa389c90ce7" />
        <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="2016.3.914.45" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Telerik.Windows.Data" culture="neutral" publicKeyToken="5803cfa389c90ce7" />
        <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="2016.3.914.45" />
      </dependentAssembly>
    </assemblyBinding>

 

We using some our intern assembly in trdp files . They are added in style

 <add name="intern.assembly" version="1.0.0.0" culture="neutral" publicKeyToken="null" />

Have any one Idea what assembly are missing? Or ways to solve the problem.

Alexander
Top achievements
Rank 1
Iron
 answered on 26 Sep 2016
1 answer
88 views

Hello,

we're having a problem with external stylesheets that don't seem to apply on the headers and footers. We have recreated the problem with the following simple scenario:

- create a blank report with 3 textboxes, one in each section(header, footer and detail)

- create an external style sheet with a textbox selector

- add the style sheet to the report after InitializeComponent() in the constructor of the report.

- preview the report

On the preview, the styles defined in the style sheet don't apply to only header and footer but to the detail section. If you press again on the preview, the styles are then set for the header and footer. There also seem to be the same issue with dynamically setting text and images in the header and footer.

Katia
Telerik team
 answered on 26 Sep 2016
9 answers
615 views
Hi,

I have HTML Textbox inside table column . But the text not showing properly. 

I made cangrow=true and canshrink=false. But event then no luck.

Find attachment and please help me
dushyanth
Top achievements
Rank 1
 answered on 23 Sep 2016
2 answers
65 views

Hi Team,

 

We have purchased and using telerikReportViewer-8.2.14.1204.

The issue is when we have more days of data the x-axis labels are unreadable and getting cluttered. (Even zoomIn is not helping to see the X-axis labels)

I am using following settings:

$("#mydiv").telerik_ReportViewer({
        scale: 1,
        scaleMode: "SPECIFIC",  so on   ...

}

 

I verified for API document is there any option available for setting the scale. But I could not find any of those properties

http://docs.telerik.com/reporting/html5-report-viewer-jquery-fn-telerik-reportviewer

 

Is this feature available for the reporting or not ?

Please tell me how to fix this? 

 

Thanks,

Shravan.

Katia
Telerik team
 answered on 22 Sep 2016
4 answers
536 views
I need to add Interactive sorting to my Crosstable report.  Will the new Q2 Interactive functionality allow that to be done?

thanks
-Mike.
Peter
Telerik team
 answered on 22 Sep 2016
1 answer
353 views

We're getting this error in our code. Here's the full stacktrace:

System.ComponentModel.Win32Exception (0x80004005): Your file waiting to be printed was deleted
   at System.Drawing.Printing.StandardPrintController.OnEndPage(PrintDocument document, PrintPageEventArgs e)
   at System.Drawing.Printing.PrintController.PrintLoop(PrintDocument document)
   at System.Drawing.Printing.PrintController.Print(PrintDocument document)
   at System.Drawing.Printing.PrintDocument.Print()
   at Telerik.Reporting.Processing.ReportProcessor.PrintReport(ReportSource reportSource, PrinterSettings printerSettings) in c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing.ReportProcessor\ReportProcessor.PrintReport.cs:line 61
   at ABB.QC.ReportPrinter.Telerik.Printer.PrintReport(ReportType reportType, String scannerAlias) in ... \ReportPrinter\Telerik\Printer.cs:line 80

This error only occurs when the report printer application is called from a windows service. If we call it directly it works, which leads me to believe it's a permissions issue. I don't know where the file waiting to be deleted is, can somebody from Telerik cast some light on this for me?

Peter
Telerik team
 answered on 22 Sep 2016
1 answer
228 views

Hi,

I had generated report using Telerik table wizard control.  But i could not able to introduce pagination in the table wizard. How can it be possible?.  

Katia
Telerik team
 answered on 21 Sep 2016
7 answers
300 views

I'm trying to place html into an HtmlTextBox and I'm getting the error:

"An error has occurred while processing HtmlTextBox 'htmlTextBox1'.
unexpected DTD declaration. Line 1 Position 9."

This message is rendered in the report.

The html being placed is :

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "<A 
xhtml1-transitional.dtd?? DTD xhtml1 TR www.w3.org 
xmlns="<A 
www.w3.org http: xhtml?? 
1999><META'>http://www.w3.org/1999/xhtml"><head><meta</A> 
http-equiv="Content-Type" content="text/html; charset=utf-8" 
/><title>Untitled</title><style 
type="text/css"><BR>.p_778AAEB1 { margin: 0px 0px 10px 0px;text-align: 
left;text-indent: 0pt;padding: 0px 0px 0px 0px; } <BR>.s_E6FD2046 { font-family: 
'Verdana';font-style: Normal;font-weight: normal;font-size: 16px;color: #000000; 
} <BR></style></head><body><p 
class="p_778AAEB1"><span 
class="s_E6FD2046">Some Sample Text</span></p></body></html><BR>

This html was actually generated by the Telerik Silverlight 'MSWordEditor' and then converted as follows:

public string RadDocumentToString(RadDocument doct)
{
    IDocumentFormatProvider htmlProvider = DocumentFormatProvidersManager.GetProviderByExtension(".html");
    byte[] buffer = htmlProvider.Export(doct);
    UTF8Encoding utf8 = new UTF8Encoding();
    string text = utf8.GetString(buffer, 0, buffer.Length);
    return text;
}

Does anyone have an idea of what might be happening?

TIA

Stef
Telerik team
 answered on 21 Sep 2016
3 answers
178 views

I need to include Rad Document( or a PDF or a DOCX) in a Telerik report.  The document is stored as varbinary in a database as a column in the rows.  This document is a table that was originally created in a RadRichTextEditor control.  I need this table to show up in my report as part of the detail section associated with each of those rows.

I keep running into road blocks attempting to work around the fact that there appears to be no means of using the Telerik products to render Telerik content in a Telerik report.  I can find no means of getting this content into the report.

Has anyone else run into this issue?  If so, will you please share your solution to this problem?

Thank you!

Stef
Telerik team
 answered on 20 Sep 2016
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?