Telerik Forums
Reporting Forum
2 answers
280 views

Hi,

I would like my line chart series to start in the bottom left corner 0,0.  Please see the attached pic.

Thanks in advance.

 

Telerik Reporting 2013 Q2 SP1

 

Stef
Telerik team
 answered on 04 May 2016
1 answer
149 views

Hello,

I need to generate a pdf which will have some static content in two columns however there are some content which need not to be displayed in two columns fashion.

I have tried to achieve the same using ColumnCount property of the Report but it doesn't play nice with content which need to displayed in single column. So if there any way to specify Column Count property for specific content of the report, not the entire report?

I have attached screenshot of a sample pdf which has structure similar to the one I want to generate.

Thanks,

Bhavik

Stef
Telerik team
 answered on 03 May 2016
25 answers
775 views
Since the recent Q2 2013 update I have been having problems with the Report Designer.    Under VS 2012 it seems impossible to add a web based ReportViewer control to a webpage and have the control render correctly in design mode.  It does appear to work at run-time.

I have tried various suggested remedies all which fail to address the problem.  To confirm the problem actually exists, I completely removed all Telerik products including the Control Panel.  After confirming I had no Telerik products installed in my add/remove programs I then rebooted my system.  I removed the "telerik" folder in my c::\program Files (x86) folder.  I rebooted my machine.  I then installed a fresh copy of the control panel and reinstalled a fresh copy of all products.  

I then launched VS 2012 and created a RadControls Web project using the .NET 4.0 framework.  The project is the base template provided by Telerik.  I then dragged the report viewer control onto the default.aspx page.  It failed to render.  I was forced to add the "telerik.reportviewer.axd_*" line to the "system.webserver" section (as noted in the documentation).  While this allowed the project to run it did not resolve the design time issues of the report viewer.

I compiled the project, saved everything, rebooted, and then re-launched VS 2012 and confirmed that design time rendering of the report viewer control still fails.

Given I have a "blank" system, what am I missing?  Is this a known "feature" I have not seen documented somewhere?

Stef
Telerik team
 answered on 03 May 2016
1 answer
133 views

Application Type: ASP.NET

Telerik version: Telerik Report Q1 2014

Dev environment:  Visual Studio 2013

I am trying to create a chart using a stored proc as the data source. I can create a table using the data without a problem however when I create a chart it throws an error referencing a temp table I use in my SP. "An error occured while processing Chart 'Chart1' Invalid Object name '#Temp_StatsTable' "

Any input or direction would be much appreciated!

Thank you

Katia
Telerik team
 answered on 03 May 2016
3 answers
370 views
Hello,

I have an issue with the name of the generated files when exporting a report to PDF or XLS from the report viewer. When a report contains a "special character" (for example "ä") in its name the character in question is not rendered correctly when clicking on the "Export" link. Instead I have a question mark wrapped in a black losange.

I understand this issue is related to URL encoding but I'm not sure how to handle it. Here's my scenario with more details:

Environment information:
- Silverlight 4.0
- IIS 7.0
- IE 8.0
- Telerik Reporting 2012Q1

In our Silverlight 4 application, a user wants to create a report. At first, he is on a page (a FloatableWindow) on the application and clicks on a button. This button sends the user to the ASPX page handling the report generation. The click on the button actually calls HtmlPage.Window.Navigate with the URI of the ASPX page in question and a bunch of parameters we use to generate the appropriate report. Among these parameters, one corresponds to the name the report will be given (also used as the file name which the report will be generated to). When debugging, in the ASPX page, I can see that the name of the report is correctly encoded (ie. the character "ä" is present and displayed correctly in the report name). The report is generated correctly in the report viewer but when clicking on the "Export" link (to PDF or XLS, same behavior), the name of the file does not hold this character anymore but instead the question mark with the black losange. Below are some code extracts that may help on our process.

Code-behind of the ASPX page holding the ReportViewer:

public class ReportManagementPage : Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Report report = new MyReport();
        report.Name = Request.QueryString["reportName"];
        report.DocumentName = Request.QueryString["reportName"];
  
        reportViewer.Report = report;
    }    
}

The above code correctly assigns the report name and document name correctly encoded. Clicking on Export does not use the correct encoding. If I right-click on "Export" and select "Open in new tab", the URL in the URL box of IE looks fine but the title of the page (in the tab and in the browser) uses the wrong encoding. FYI, spaces are correctly rendered and do not use %20, not even in the URL. Is there any way to fix this and tell the "Export" link/button what encoding to use for the file name?

Thanks for your help.
Stef
Telerik team
 answered on 03 May 2016
1 answer
226 views

Hi

 

How do I insert a 600 x 241 rectangle into a report header programmatically?

I've tried:

var myReport = new Report();
var header = new ReportHeaderSection();
header.Items.Add(new Shape
{
    ShapeType = new PolygonShape(4, 45, 0) { Bounds = RectangleF.FromLTRB(0, 225, 600, 466) },
    Size = new SizeU(Unit.Pixel(600), Unit.Pixel(241)),
    Location = new PointU(Unit.Pixel(0), Unit.Pixel(225)),
    Style = { Color = Color.DarkGray, LineWidth = Unit.Pixel(1) }
});
myReport.Items.Add(header);

But all I get is a square. Why isn't it expanding to a rectangle?

I've also tried using an ellipse (and got a circle funnily enough). The output doesn't change if I leave out the Bounds either.

Jeremy
Top achievements
Rank 1
 answered on 28 Apr 2016
1 answer
390 views

Hi,

I've been trying to set a specific parameters visible property based on another parameters value.

I have a boolean parameter that allows the displaying of more data in the report.

I have a 2nd boolean parameter that is hidden. If set to false the 1st bool parameters visible property to should then be set to false.

At the point of construction of the report, I check both 

 this.Report.ReportParameters["IsParamVisible"];

 this.ReportParameters["IsParamVisible"];

but the values are never set at that point so they do nothing.

How do I do this?

I'm using Telerik Reporting Q2 2015

 

Cheers

Katia
Telerik team
 answered on 27 Apr 2016
1 answer
372 views

Hello,

I have created a simple report using the standalone report designer and saved it as a .trdx file.
Here is my code to generate a pdf file:

Reporting.Report report = new Reporting.Report();
Reporting.XmlReportSource xmlReportSource = new Reporting.XmlReportSource();

// simple text box (Test2) in a report header

xmlReportSource.Xml = @"<?xml version='1.0' encoding='utf-8'?>
<Report Width='6.5in' Name='Report2' xmlns='http://schemas.telerik.com/reporting/2012/3.7'>
  <Items>
    <PageHeaderSection Height='0.200039307276408in' Name='pageHeaderSection1' />
    <DetailSection Height='0.299960772196452in' Name='detailSection1' />
    <PageFooterSection Height='1in' Name='pageFooterSection1' />
    <ReportHeaderSection Height='1in' Name='reportHeaderSection1'>
      <Items>
        <TextBox Width='1.20000016689301in' Height='0.19999997317791in' Left='2.64583333333333in' Top='0.395833333333333in' Value='Test2' Name='textBox1' />
      </Items>
    </ReportHeaderSection>
  </Items>
  <StyleSheet>
    <StyleRule>
      <Style>
        <Padding Left='2pt' Right='2pt' />
      </Style>
      <Selectors>
        <TypeSelector Type='TextItemBase' />
        <TypeSelector Type='HtmlTextBox' />
      </Selectors>
    </StyleRule>
  </StyleSheet>
  <PageSettings>
    <PageSettings PaperKind='Letter' Landscape='False' ColumnCount='1' ColumnSpacing='0in'>
      <Margins>
        <MarginsU Left='1in' Right='1in' Top='1in' Bottom='1in' />
      </Margins>
    </PageSettings>
  </PageSettings>
</Report>";
report.DataSource = xmlReportSource;
Processing.ReportProcessor reportProcessor = new Processing.ReportProcessor();
Reporting.InstanceReportSource instanceReportSource = new Reporting.InstanceReportSource();
instanceReportSource.ReportDocument = report;
File.WriteAllBytes(fileName, reportProcessor.RenderReport("PDF", instanceReportSource, null).DocumentBytes);

File created successfully, but it's empty, althogh report designer previews report properly.
What am I doing wrong?
I use Telerik.Reporting, Version=8.2.14.1222
Thanks in advance
Michael

Katia
Telerik team
 answered on 27 Apr 2016
1 answer
372 views

Hi,

I'm using Telerik 2013 Q2 (for .NET Windows).

I'm trying to generate a Dynamic Report, where the Columns are getting generated at run time.

When I use the code mentioned in the below link for grouping, the report shows only the first row of each group!!!

http://docs.telerik.com/reporting/data-items-how-to-add-groups-to-table-item-and-crosstab-item


Telerik.Reporting.TableGroup group1 = new Telerik.Reporting.TableGroup();

group1.Name = "Col1";
group1.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.Col1"));


Why it is not showing all the rows of each group???

Kindly let me know.

with regards,
Krish TS

Stef
Telerik team
 answered on 27 Apr 2016
7 answers
630 views

Hi,

I recently started working with Telerik Reports and looks good.

Currently I'm working on Windows .NET application and need to create a fully dynamic simple report.

The report query varies based on the user selection on the windows application (report name, database table name, db columns, db condition, db grouping columns).

Based on the above selection, the query gets built dynamically (kind of a query builder tool).

This query result should be dynamically populated in the Telerik Report.

How can I acheive the Telerik report to handle these kind of dynamic queries?

I came across multiple forums asking for similar kind of question but I'm getting lost with multiple replies.

Kindly help on what is the clear way for doing this (with db column grouping too)? with any sample attachment please.

with regards,

Krish TS

Stef
Telerik team
 answered on 27 Apr 2016
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?