Telerik Forums
Reporting Forum
2 answers
174 views

Hi,  I need your help please, do you have any idea how can I make this kind of report.

in each page, let say i have 10 rows and i set 3 data per page. The report will show the max row number  ("show 3 of 10 result." in the 1st page and for next page will show "show 6 of 10" )

is it possible? thank you

 

thank you

Neli
Telerik team
 answered on 08 Jun 2021
1 answer
1.1K+ views

I am trying to get the month returned in a string in a report parameter. I currently have

Now().Month

But I suspect it is returning the number of the month because the field is blank when I run the report, which is strange because the other report parameter is

Now().Year
and that works just fine. I tried formatting as a string, but that did not work either. What am I doing wrong?
Plamen Mitrev
Telerik team
 answered on 08 Jun 2021
1 answer
756 views

Hello Team, 

 I am trying to generate a new report in .net core using Telereik Reporting Tool with Object data source. I tried many sample code, by didnt work. Can you please help me how to create a report using object database. It would be greate i f you can provide me a working sample code

 

Thanks

 

Eric R | Senior Technical Support Engineer
Telerik team
 answered on 03 Jun 2021
1 answer
516 views
Im saving a PDF in a Blob Storage, I can get the PDF but I need convert it to Telerik.Reporting.Report for using it like a SubReport inside a Report
Todor
Telerik team
 answered on 03 Jun 2021
8 answers
1.5K+ views
 System.OutOfMemoryException: Out of memory.
   at System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
   at Telerik.ReportViewer.WinForms.DrawablePage.Draw(Graphics graphics, Rectangle rectangle) in c:\temp\reporting\@RBuild-2334\Reporting_Build\Source\Code\Telerik.ReportViewer.WinForms\DrawablePage.cs:line 47
   at Telerik.ReportViewer.WinForms.InteractivePageLayout.LayoutItem.DrawContent(Graphics graphics) in c:\temp\reporting\@RBuild-2334\Reporting_Build\Source\Code\Telerik.ReportViewer.WinForms\InteractivePageLayout.cs:line 334
   at Telerik.ReportViewer.WinForms.InteractivePageLayout.DrawPages(Graphics graphics, Rectangle rectangle, Int32 pageNo) in c:\temp\reporting\@RBuild-2334\Reporting_Build\Source\Code\Telerik.ReportViewer.WinForms\InteractivePageLayout.cs:line 98
   at Telerik.ReportViewer.WinForms.WinViewer.OnPaint(PaintEventArgs eventArgs) in c:\temp\reporting\@RBuild-2334\Reporting_Build\Source\Code\Telerik.ReportViewer.WinForms\WinViewer.cs:line 869
   at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)
   at System.Windows.Forms.Control.WmPaint(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Now previously in our 2012 we were getting something similar to this when a control with the embedded control was displaying a report built inside Visual Studio.  We upgraded to Q3 2013's release, removed the older reports, added a class that builds the XML version (trdx files) and the error went away.  Now a different Out of Memory exception error (listed above) recently started occurring.  Originally the image we used was streamed from the database (for logos) but now they are local to the application (I cannot point to the post, but on your ASP forums, someone suggested doing that with other Telerik controls that used images).  Our app is a desktop app (non-wpf) that uses Telerik Reporting.  The above error only seems to occur in certain situations, so not every time.  it occurs on reports that vary in pages (1-75).  Our reports that go into the reportbook do not have this problem (avg 136 reports totaling ~900 pages).  We have 2 report viewers (2 separate user controls on same form) that display the reports.  One displays a single report while the other display the report book when all the single reports are loaded.

In 2012 release we were getting (using code behind version) about 80% of the clients were getting this error:
​ System.OutOfMemoryException: Out of memory.
   at System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
   at System.Drawing.Image.FromStream(Stream stream)
   at Telerik.ReportViewer.WinForms.DrawablePage.Draw(Graphics graphics, Rectangle rectangle)
   at Telerik.ReportViewer.WinForms.InteractivePageLayout.LayoutItem.DrawContent(Graphics graphics)
   at Telerik.ReportViewer.WinForms.InteractivePageLayout.DrawPages(Graphics graphics, Rectangle rectangle, Int32 pageNo)
   at Telerik.ReportViewer.WinForms.WinViewer.OnPaint(PaintEventArgs eventArgs)
   at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)
   at System.Windows.Forms.Control.WmPaint(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.UserControl.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Now this could just be me, but I'm starting to think it's not the loading of our logo onto the report, but drawing the report itself since the logo is no longer read from the database but read from file.  In my case, we discovered that working with trdx files are easier to create a dynamic tables than the code behind version.

Here is a sample of how the report is built.

/// <summary>
/// Returns a Telerik Report for use in the Telerik ReportViewer
/// </summary>
/// <param name="reportInfo"> of the report to generate, see ReportInfo class</param>
/// <returns></returns>
public Telerik.Reporting.Report GetReport(ReportInfo reportInfo)
{
#region hallway monitors
if (reportInfo == null)
throw new NullReferenceException("ReportInfo is missing or null.");

if (reportInfo.Name == null)
throw new NullReferenceException("Report Name is missing or null.");

#endregion

XDocument doc = CreateXDocument(reportInfo); //the trdx file

// open the report
BufferedStream stream = new BufferedStream(new MemoryStream());
stream.Write(Encoding.ASCII.GetBytes(doc.ToString()), 0, doc.ToString().Length);
stream.Seek(0, SeekOrigin.Begin);
StreamReader sr = new StreamReader(stream);

System.Xml.XmlReaderSettings settings = new System.Xml.XmlReaderSettings();
settings.IgnoreWhitespace = true;

XmlDocument xmlDoc = GetXmlDocument(doc);
Telerik.Reporting.Report report;

using (System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create(sr, settings))
{
Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();

report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);
}

Telerik.Reporting.TextBox tbHeader = (Telerik.Reporting.TextBox)report.Items["pageHeaderSection1"].Items["textBoxHeader"];
tbHeader.Value = reportInfo.Title;

if (reportInfo.CompanyLogo != "" && reportInfo.CompanyLogo != null)
{
Telerik.Reporting.PictureBox pictureBoxCompanyLogo = (Telerik.Reporting.PictureBox)report.Items["pageHeaderSection1"].Items["pictureboxCompanyLogo"];
pictureBoxCompanyLogo.MimeType = reportInfo.CompanyLogoExt != "" ? "Image/" + reportInfo.CompanyLogoExt.ToUpper() : "";
pictureBoxCompanyLogo.Value = Image.FromFile(reportInfo.CompanyLogo);
}

foreach (TableInfo tableinfo in reportInfo.Tables)
{
Telerik.Reporting.Table table = (Telerik.Reporting.Table)report.Items["detailSection1"].Items[tableinfo.ReportTableName];
table.DataSource = tableinfo.DataSource;
}

return report;

}

​ private XmlDocument GetXmlDocument(XDocument document)
{
using (XmlReader xmlReader = document.CreateReader())
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(xmlReader);
if (document.Declaration != null)
{
XmlDeclaration dec = xmlDoc.CreateXmlDeclaration(document.Declaration.Version,
document.Declaration.Encoding, document.Declaration.Standalone);
xmlDoc.InsertBefore(dec, xmlDoc.FirstChild);
}
return xmlDoc;
}
}

private XDocument CreateXDocument(ReportInfo reportInfo)
{
XDocument doc = new XDocument();

_isLandscape = reportInfo.Layout == ReportProperties.Layout.LANDSCAPE ? true : false;

doc.Add(new XElement(XML_NAME_SPACE + "Report"
, new XAttribute("Width", reportInfo.Layout.Width.ToString() + "in")
, new XAttribute("Name", reportInfo.Name)));

XElement rootItems = new XElement(XML_NAME_SPACE + "Items");
rootItems.Add(PageHeaderSection());
rootItems.Add(DetailSection(reportInfo));
rootItems.Add(PageFooterSection());

doc.Root.Add(rootItems);
doc.Root.Add(StyleSheets());
doc.Root.Add(PageSettings());

return doc;
}
n/a
Top achievements
Rank 1
Iron
 answered on 02 Jun 2021
6 answers
1.4K+ views

Hello, I'd like to, using the Standalone Report Designer, Import an existing Visual Studio Report (.cs) and save it as a trdx.

I have seen the following links:

http://docs.telerik.com/reporting/import-report-wizard

and

http://docs.telerik.com/reporting/standalone-report-designer-import-clr-reports

 

They indicate it possible but the second link seems for a different interface than mine. (There is no " In the Open dialog window, select .NET Report Library from the file type combobox. ")

and following the first link leads to an Import Report Wizard but in the "available converters" there is only Crystal Reports. Also the file filter gives no option for extensions other than *.rpt.

 

Do I have to install/ download a .NET converter?

 

I have Report Designer Q3 2015.

 

Thanks,

-Jeff

Chris
Top achievements
Rank 1
Veteran
Iron
Iron
 answered on 01 Jun 2021
0 answers
2.0K+ views

Hi,

I upgraded my Telerik reporting version to the latest version.

I view reports using the Properties dialogue of a ReportViewerall worked fine.

but after some reports, suddenly I get this error:

Invalid report type Exception has been thrown by the target of an invocation.

and I do not can see any reports. (all the reports , others too).

Yesterday I get this error all time. Today the reports worked fine' and suddenly I get this error again.

Can anyone shed any light as to the possible reasons why this might be happening?

Thanks

Chani


 

Chana
Top achievements
Rank 1
 asked on 29 May 2021
0 answers
120 views

Hello there,

I am using C# .net Winforms Report. 
I have a data set like this

{Code, $dollar}
{0, 100} {0.1 , 125}, {0.2, 127},
{1.2, 250},{1.4,210},
{2.0,250},{2.3,210},
{5.2 , 300}


I tried to make a simplest scatter plot with every dots connect by line. I do not want the category group because if I do, then I will be missing  4, and 6 in x axis. it will have 0, 0.1, 0.2, 1.2, 1.4, 2.0, 2.3, and 5.2 only which is categorized.
I want x's range to be fixed from 0 to 6 with equal space.
scatter plot cannot have series group but line graph requires series group. 

I tried so many different ways but couldn't figure it out.
Can you show me some examples? 

Song
Top achievements
Rank 1
 asked on 26 May 2021
1 answer
730 views
I need to change the column name of the report based on the Day of Week.
I could not find this function on the docs.
Kaloyan
Telerik team
 answered on 26 May 2021
1 answer
413 views

net core 5, angular 9, telerik REST service, working fine on local when debug in VS

but after deploy, it  showing loading, then showing No page to display, no error.

tested api/reports/formats working, report calling backend api working, just not showing report.

any help pls

 

Plamen Mitrev
Telerik team
 answered on 26 May 2021
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?