Questions on Reporting Forum

4 answers

546 views

Hi,

Need help in converting the currency to words for different language cultures like "us" and "ru".

What I have is the total of the currency value, say 285630. Now I have to convert it to words for english-US it should be "two hundred eighty-five thousand six hundred thirty" and similarly it should convert accordingly if the language culture is Russian-RU.

Please suggest.

General Discussions

answered on 22 Jul 2015

2 answers

337 views

UI Issue : Report grid lines not showing properly on Report Viewer

Hi,

I am facing an issue of UI format with report viewer control. My report displays perfectly when I export it to PDF but it is not displaying so when it is on ReportViewer control.

I have used textboxes in detail section within subreport and these text boxes appears in form of table in final report. But on the UI(on ReportViewer control on Window Forms) it is not showing textbox borders properly. But suprisingly the borders are perfectly there if I export the report to PDF.

Any suggestion ?

General Discussions

answered on 22 Jul 2015

1 answer

279 views

Error generating report containing subreport with UriReportSource

Hi everybody,

I've just created a .trdx report containing a subreport using Telerik Report Designer. I would like to export a pdf file based on this report so I've created a web page having this method server side:

void ExportToPDF()

{

var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();

var deviceInfo = new System.Collections.Hashtable();

UriReportSource NetCatalogPDF = new UriReportSource();

NetCatalogPDF.Uri = Server.MapPath("~/Report/Standard/CatalogPDF.trdx");

NetCatalogPDF.Parameters.Add(new Telerik.Reporting.Parameter("CompanyCode", CompanyCode));

NetCatalogPDF.Parameters.Add(new Telerik.Reporting.Parameter("LanguageCode", PageLanguage));

NetCatalogPDF.Parameters.Add(new Telerik.Reporting.Parameter("FamilyId", (ddlFamily.SelectedValue != "-1") ? ddlFamily.SelectedValue : null));

NetCatalogPDF.Parameters.Add(new Telerik.Reporting.Parameter("IncludePrices", chkIncludePrices.Checked));

if (chkIncludePrices.Checked)

{

NetCatalogPDF.Parameters.Add(new Telerik.Reporting.Parameter("PriceListCode", ddlPriceList.SelectedValue));

NetCatalogPDF.Parameters.Add(new Telerik.Reporting.Parameter("CustomerCode", txtCustomerCode.Text));

}

else

{

NetCatalogPDF.Parameters.Add(new Telerik.Reporting.Parameter("PriceListCode", null));

NetCatalogPDF.Parameters.Add(new Telerik.Reporting.Parameter("CustomerCode", null));

}

NetCatalogPDF.Parameters.Add(new Telerik.Reporting.Parameter("ImagesPath", Server.MapPath("/Catalog/public/images/catalog/products/zoom")));

var connectionStringHandler = new ReportConnectionStringManager(ConnectionString);

try

{

var reportSource = connectionStringHandler.UpdateReportSource(NetCatalogPDF);

var result = reportProcessor.RenderReport("PDF", reportSource, deviceInfo);

this.Response.Clear();

this.Response.ContentType = result.MimeType;

this.Response.Cache.SetCacheability(HttpCacheability.Private);

this.Response.Expires = -1;

this.Response.Buffer = true;

// Uncomment to handle the file as attachment

//Response.AddHeader("Content-Disposition",

// string.Format("{0};FileName=\"{1}\"",

// "attachment",

// "Report.pdf"));

this.Response.BinaryWrite(result.DocumentBytes);

this.Response.End();

}

catch (Exception ex)

{

ErrMess = ex.Message;

}

Anyway the line

var result = reportProcessor.RenderReport("PDF", reportSource, deviceInfo);

throw an exception:

Cannot find the file 'c:\windows\system32\inetsrv\CatalogPDF_Sub.trdx'. "CatalogPDF_Sub.trdx" is subreport file name. Obviously the path is wrong because that file is located in the same main report folder ("~/Report/Standard/").

How can I solve this problem?

Thank you in advance for your replies.

General Discussions

answered on 21 Jul 2015

1 answer

48 views

Where there is an example Download about Telerik Reporting with EF

Where there is an complete example Download about Telerik Reporting with EF.

Please tell me. Thank you!

General Discussions

answered on 21 Jul 2015

1 answer

27 views

Creating The SofiaCarRental Model is error

Creating The SofiaCarRental Model

http://docs.telerik.com/data-access/quick-start-scenarios/quickstart-sample-model#creating-the-sofiacarrental-model

It was error! Please help me. Thack you very much!

Please check the attachment！

General Discussions

answered on 21 Jul 2015

2 answers

217 views

Date Filter

Within this report I want to view all hires within a date range, but rather than just seeing hires that start or end on a particular date, i want to view all live hires.

So for example, if a hire starts on 05/01/15 and ends on 25/01/15, i'm not able to see it if i search the start date as 10/01/15. Is there any way I can view live hires rather than hires that have started and finished within a certain date range?

General Discussions

answered on 21 Jul 2015

1 answer

355 views

trdx file in report viewer with user function

Hi,

I've created trdx file with standalone report designer to user function "GetMonth(now.month)" in textbox

I've added report viewer like below code into codebehind onload;

Telerik.Reporting.UriReportSource uriReportSource = new Telerik.Reporting.UriReportSource();
uriReportSource.Uri = "Report1.trdx";
ReportViewer1.ReportSource = uriReportSource;

and i've added custom function

public static object GetMonth(int value)
{
return System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(value);
}

But it gives below error:

An error has occurred while processing TextBox 'textBox21': The expression contains undefined function call GetMonth().

Please help me, how can i call user custom function from trdx file on report viewer?

General Discussions

answered on 20 Jul 2015

3 answers

263 views

Zoom To Page Width/Whole Page Issue

Hi,

I recently upgraded to Q1 2012 Telerik Reporting as well as Telerik RadControls for WPF, using the upgrade wizards provided. Once I got my application (previously built on Q3 2011) to compile, I was able to run the application. I'm using the WPF ReportViewer to load a report. The report managed to load correctly. However when I tried to set the Zoom Mode to Page Width or Whole Page, I encountered a problem of System.InvalidOperationException.

The additional information given by the exception is :

"Layout.measurement override of element 'Telerik.Windows.Controls.Primitives.LayoutTransformControl' should not return NaN values as its DesiredSize."

All the other zoom levels seemed ok... Previously with Q3 2011, the zoom was working fine.

Hope you can help me on this issue. Thank you very much for your time.

General Discussions

answered on 20 Jul 2015

3 answers

383 views

Internal Server Error Access to value.dat is denied

Telerik Q3 2014
Visual Studio Ultimate 2013
MVC 5 Report Viewer

Report works locally fine, deploy to IIS 7.5 and get below error.
Internal Server Error
An error has occurred.
Access to th epath 'C\Windows\TEMP\ReportService\...\LastCheckTime
value.dat is denied.

I go to the server and delete the TEMP data then the report works again.

Why is this erorr occuring and what is the resolution. We cannot have random Telerik failures in production.

General Discussions

answered on 20 Jul 2015

4 answers

418 views

Error registering Reports Controller routes

I am receiving a System.NotSupportedException of "Adding or removing items from a 'HttpRouteCollection' is not supported. Please use a key when adding and removing items." when my application hits the ReportsControllerConfiguration.RegisterRoutes() method.

Thank you for assistance in advance.

General Discussions

answered on 20 Jul 2015