Telerik Forums
Reporting Forum
1 answer
145 views

Dear Support,

I have a report that works with 3 different Cultures. With cultures in English and Spanish all seems to be working fine, but when we generate the report in Japan Culture, and we send it to print the print preview is not complete and if we send it to the printer it is also incomplete.
The report is also using a Japanese Font:
"MS Pゴシック"
We were trying to watch what causes these problem and we got these results.

  • If we generate the report with the Japan Culture and we choose a default font, the report is correct.
  • If we generate the report with the English Culture or Spanish Culture with the Japanese Font: "MS Pゴシック" with the default font, the report is correct.
  • If we generate the report with the Japan Culture and with de Japanese Font: "MS Pゴシック", the report is incorrect.


We cannot say that is a problem with the font because with English and Spanish Culture it generates correct.
We cannot say that is a problem with de Japan Culture because when we change the font to a default font or another Font (Tahoma, Arial) it generates correct.

It seems to be a problem when we use the Japan Culture with the Japanese Font.

Images: 1-ok.jpg, 2-ok.jpg, 3-ok.jpg Show that we generate a report with the Japanese Font but we changed by code the culture to English even we select Japan Culture to Generate.

Images: 1-wrong.jpg, 2-wrong.jpg, 3-wrong.jpg Show that we generate a report with the Japanese Font and Japan Culture and the report is not complete.

Thanks for your Help


 

Steve
Telerik team
 answered on 08 Oct 2010
0 answers
87 views
Hi,

I have a very simple report. Chart control is placed in detail section of the report. Chart is populated using generic list objects. The problem is that when the report is viewed in the browser, chart contains extra x-axis columns. It looks to me the x-axis items are repeated again and again.

Please see the attachment for detail.

Following method is called only once from the page where reportViewer is embedded.
like 

MyReport rpt = new MyReport();
rpt.PlotChart(2,null,null);
rptViewer.Report = rpt;


public void PlotChart(int processID, DateTime? fromInvoiceDate, DateTime? toInvoiceDate)
        {
            try
            {
                myChart.Series.RemoveSeries();
                myChart.ChartTitle.TextBlock.Text = "Days to Payment";
                myChart.DefaultType = ChartSeriesType.Pie;
                IDashboardRepository dashRep = new DashboardRepository();
                List<MockUpChart> chartData = dashRep.GetMockUpChartData(processID, fromInvoiceDate, toInvoiceDate);

                ChartSeries chartSeries = new ChartSeries();
                chartSeries.Name = "Days to Payment";
                chartSeries.Type = ChartSeriesType.Bar;

                foreach (MockUpChart cDatum in chartData)
                {
                    chartSeries.AddItem(cDatum.TotalNoInvoices, cDatum.DaysToPayment.ToString());
                }

                myChart.PlotArea.XAxis.AxisLabel.Visible = false;
                myChart.PlotArea.XAxis.AxisLabel.TextBlock.Text = "Days to Payment";
                //myChart.PlotArea.XAxis.AxisLabel.TextBlock.Appearance.TextProperties.Color = System.Drawing.Color.Red;

                myChart.PlotArea.YAxis.AxisLabel.Visible = false;
                myChart.PlotArea.YAxis.AxisLabel.TextBlock.Text = "Number of Invoices";
                //myChart.PlotArea.YAxis.AxisLabel.TextBlock.Appearance.TextProperties.Color = System.Drawing.Color.Red;
                
                myChart.Series.Add(chartSeries);
                for (int i = 0; i < myChart.Series.Count; i++)
                {
                    myChart.Series[i].Appearance.LabelAppearance.Visible = false;
                }
            }
            catch (Exception ex)
            {
            }
        }
FISCAL
Top achievements
Rank 1
 asked on 08 Oct 2010
0 answers
89 views
Dear all,

I need to programmatically access the excel file, which was created by exporting a report, from my WPF application. Ideally I would like to catch/overload the export event. I cannot figure out how to do this. Can you help me please?

Thank you

Dominik
Dominik
Top achievements
Rank 1
 asked on 08 Oct 2010
2 answers
241 views
Is there a minimum cell size on the telerik reporting table? 

When creating a report I want to try to fit the entire table on one 8 1/2 x 11 sheet of paper within the report.  There can be up to a max of 24 columns.  I'm trying to adjust the font size and cell size to make it all fit even if its microscopic.  We will force the user to use the Zoom in feature.  After reducing font size and setting the textbox size to a certain size the text box and table cell doesn't seem to go any smaller. 

So I was wondering if by default there was a minimum size a cell could be?

Thanks,
-Scott
Scott
Top achievements
Rank 2
 answered on 08 Oct 2010
4 answers
179 views
I'm having issues when exporting a report with a Crosstab from the web viewer.  The report works as I expected in the web viewer.

For most export types (except web archive), the far right "total" column is just missing.

For Excel exports I get an exception:

Server Error in '/' Application.

Attempting to get range {2,5}{1,1},Merged=False,Parent=Session Scoring[0], that intersects with an already merged range.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Attempting to get range {2,5}{1,1},Merged=False,Parent=Session Scoring[0], that intersects with an already merged range.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Attempting to get range {2,5}{1,1},Merged=False,Parent=Session Scoring[0], that intersects with an already merged range.]
   Telerik.Reporting.Excel97.Worksheet.GetRange(Int32 col, Int32 row, Int32 colSpan, Int32 rowSpan) +207
   Telerik.Reporting.ExcelRendering.Excel97.Worksheet.Telerik.Reporting.ExcelRendering.IWorksheet.GetRange(Int32 col, Int32 row, Int32 colSpan, Int32 rowSpan) +91
   Telerik.Reporting.ExcelRendering.RenderingItem.GetRange(IWorksheet worksheet, TableLayoutInfo layoutInfo) +467
   Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo) +80
   Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo) +170
   Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo) +259
   Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo) +170
   Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo) +259
   Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo) +170
   Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo) +259
   Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo) +170
   Telerik.Reporting.ExcelRendering.Section.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo) +76
   Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo) +259
   Telerik.Reporting.ExcelRendering.Group.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo) +136
   Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo) +259
   Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo) +170
   Telerik.Reporting.ExcelRendering.Report.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo) +837
   Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo) +259
   Telerik.Reporting.ExcelRendering.Report.Render(IWorkbook workbook) +443
   Telerik.Reporting.ExcelRendering.Excel97.ExcelReport.Telerik.Reporting.Processing.IRenderingExtension.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback) +187
   Telerik.Reporting.Processing.ReportProcessor.Render(IList`1 reports, ExtensionInfo extensionInfo, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback) +1349
   Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, IReportDocument reportDocument, Hashtable deviceInfo, Hashtable renderingContext, CreateStream createStreamCallback) +587
   Telerik.ReportViewer.WebForms.ServerReport.Render(HttpResponse response, String format, Int32 pageIndex) +849
   Telerik.ReportViewer.WebForms.ReportExportOperation.PerformOperation(NameValueCollection urlQuery, HttpContext context) +135
   Telerik.ReportViewer.WebForms.HttpHandler.ProcessRequest(HttpContext context) +368
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +867
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +120


Version Information: Microsoft .NET Framework Version:2.0.50727.4952; ASP.NET Version:2.0.50727.4927



This happens with Q2 2010 Internal Build v4.1.10.729 which I'm using because it fixes another issue I was having.
Jim
Top achievements
Rank 1
 answered on 08 Oct 2010
3 answers
174 views
Hi,

we're facing an issue, trying to display a reportviewer in a customized Webpart designed for a Sharepoint Application. I've tried to search in the forum and the KB for a couple of hours about this problem and found nothing.

Of course, we first checked everything mentionned in the "Deploying Web ReportViewer in MOSS" article, and everything is fine.
The reportviewer has a strange behaviour, when the page is loading, its toolbar starts appearing with its coloured and enabled icons, but then suddenly the icons turns gray and the toolbar is entierely disabled, as shown in the screenshot below. The report is empty.

Here are parts of the code we used. We declare the ReportViewer in the CreateChildControls method of the webpart, but we populate the data and generate the report in the RenderControl method.

 

protected Telerik.ReportViewer.WebForms.ReportViewer MyReportViewer;

 


 

protected override void CreateChildControls()

 

{

MyReportViewer =

new ReportViewer();

 

MyReportViewer.ParametersAreaVisible =

false; // Tried this but nothing changed

 

Controls.Add(MyReportViewer);

}

 

protected override void Render(HtmlTextWriter output)

 

{

 

EnsureChildControls();

 

 

var LObjetDataSource = new Telerik.Reporting.ObjectDataSource();

 

LObjetDataSource.DataSource = PopulateDataView(); // Method returning the data in a DataView

Telerik.Reporting.

Report Rapport = new Report();

 

Rapport.DataSource = LObjetDataSource;

Rapport.ReportParameters.Clear();

// Tried this in order to avoid bad parameters issues

 

 

 

MyReportViewer.Report = Rapport;

MyReportViewer.RenderControl(output);

}


Could the issue be relative to a bad databinding, in the lifecycle of the page/webpart ?
If someone can help...

thanks in advance.

Daniel 
Steve
Telerik team
 answered on 08 Oct 2010
4 answers
173 views

Hi All,

 


I have run into a problem with the Telerik Reporting that I have bought (Q10 2010).

 


The problem is following:

 

While I run an Asp.Net application with a Telerik Report under the Windows Server 2008 and an Application pool with integrated managed pipeline mode set – I have an issue (see the Issue.jpg screenshot attached).

 

As soon as I changed from integrated to classic managed pipeline mode the report starts working fine (see the Image4.jpg screenshot attached).

Thanks to all.

Borys
Top achievements
Rank 1
 answered on 08 Oct 2010
0 answers
97 views
i want to make a crosstab like that at the attached file. seperatly, i can grouped by year or by month, but i didn't manage to make like that.
Is there a way to do this ?

"Ocak,şubat..." are the names of months in turkish (:
Bekir
Top achievements
Rank 1
 asked on 08 Oct 2010
15 answers
249 views
Hello:
     When I use report in my silverlight appliction,there is always an error like this :"An exception occurred during the operation, making the result invalid.  Check InnerException for exception details".My report's datasource is objectdatasource,it can be previewed in the report class library,but when i use it in the silverlight application,an exception will be occured as above.However,when my report's datasource is sqldatasource,there is no error or exception and it will return right result.I don't known if i miss some dll or other files in my silverlight application.
My development environment: Windows Server 2008; VS2010; Silverlight 4.0; Reporting Q2 2010

Please write back as soon as possible!



                                                                                                                                                                                                     Thanks!
Steve
Telerik team
 answered on 07 Oct 2010
7 answers
425 views
Hi everyone!

I've created a ReportBook with 3 reports in it (created runtime, not in designer).

In preview (ReportViewer Control, WinForm) everything renders as expected, all 3 reports are displayed.

But when i export this as PDF/Excel ... (it's no difference if i'm doing this from code or with the ReportViewer Export Button) i only get the last of the 3 reports as export result, first and second report are gone to /dev/null ....

I've tried this with different reports, always the same result.

I also checked if the input for the ReportProcessor is correct, 3 Reports are in the reportBook when passed to the RenderReport function.

We are using the latest version 2010.1.423.

So, anyone any idea? =)

Regards,
Michael


Andrea Rapuzzi
Top achievements
Rank 1
 answered on 07 Oct 2010
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?