Telerik Forums
Reporting Forum
1 answer
139 views
Hi all,
I see a lot of excel export threads but none that covers my dilemma.
I am using Reporting Q1 2013 and when exporting a report into excel the result is jumbled. Columns are hidden and I am unable to sort the resulting excel file.
This happens to all reports that I try and export. 


Thanks for any help,
Andy
IvanY
Telerik team
 answered on 31 May 2013
17 answers
627 views
Hello,

Am very new to Telerik software and so I need your help please. I have a project to create different reports using telerik reporting but all I am given is the MsSql stored procedure codes from an existing database. When I look read the telerik reporting tutorial, it shows steps on how to populate and assign datasource and to drag and drop the fields from a table into the detail section of the designer (middle section) of the tab. But when using stored procedure codes, there are no actual table to drag and drop just codes to carry out a command when data is put on the front-end (website). How can this code be added to the report? Thanks!
Stef
Telerik team
 answered on 31 May 2013
2 answers
257 views
I have configured my Telerik Reporting to use cache provider = File and everything is working just fine.
I notice that that the report files is generated in a sub folder with a name that looks something like a guid, but I can't find anything in the documentation that verifies this assumption.

Since I run several customer on the same web-server, using the same web.config, and there for the came cache directory, I'm a little bit nervous that a customer possible could get another customers data.

Can someone verify that the generated name for the sub folder created is a guid?

Regards
 - Peter
Peter
Top achievements
Rank 1
 answered on 31 May 2013
12 answers
672 views
I am considering giving some users the stand alone designer so they can make some of their own reports.  I know one question that will be asked, "if we make a report we like, how do we get it in our web site?"  In other words, they prototype reports and play around with them.  When they get one they like a lot, they would want me to put it in the VS project so they can view it in the main web site.

So, the report designer saves to a .trdx file.  But the project files are code (vb or cs).  So how to do the import?  I would have expected an "Import trdx file" in the VS Telerik Reporting menu.  Am I missing something? 

Thanks.
Stef
Telerik team
 answered on 31 May 2013
1 answer
669 views
Hi Telerik,

Is it possible to have a single textbox display formatted values for multiple data fields? Specifically my issue is I want to display a date interval in the same textbox where the start and end dates are in two individual datafields of type DateTime, like so:

"01/01/2001 - 07/01/2001"

I want to utilize the localization and formatting capabilities of having the dates as DateTime types and therefore combining them in codebehind as a string is not an option for me, then I would rather have two separate textboxes - BUT having two separate textbox then present me with the problem of proper displaying in the report if the formatting changes (longer or shorter datetime string).

I was trying to do something like this:

=Format("{0:d}, {1:d}", Fields.FirstDistributionDate, Fields.LastDistributionDate)

Thanks in advance,

Best regards,
Kasper Schou
Peter
Telerik team
 answered on 31 May 2013
10 answers
170 views
Just wondering is there any example of the wcf self hosting, running windows system serivce

cheers
Stef
Telerik team
 answered on 31 May 2013
0 answers
323 views
Hi,

I'm using Telerik Reporting Q1 2013 and I have a report which contains a subreport which I have been able to export to HTML, PDF, CSV, etc., etc., programmatically, but it throws an exception when attempting to export to Excel (XLS/XLSX).  I can export a different report that I have (which contains no subreport) to all formats (including Excel) without any exceptions.  As far as I can tell, the only real difference between the two is the subreport.

I get a Null Reference Exception when calling the RenderReport method of the ReportProcessor class.  Here's the stack trace:

{"Message":"An error has occurred.","ExceptionMessage":"Object reference not set to an instance of an object.","ExceptionType":"System.NullReferenceException","StackTrace":" at Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.Table.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.Section.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.Group.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.Report.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.Report.Render(IWorkbook workbook)\r\n at Telerik.Reporting.ExcelRendering.Excel97.ExcelReport.Telerik.Reporting.Processing.IRenderingExtension.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback)\r\n at Telerik.Reporting.Processing.ReportProcessor.RenderCore(ExtensionInfo extensionInfo, IList`1 reports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)\r\n at Telerik.Reporting.Processing.ReportProcessor.ProcessAndRender(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)\r\n at Telerik.Reporting.Processing.ReportProcessor.ProcessAndRenderStateless(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)\r\n at Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, ReportSource reportSource, Hashtable deviceInfo)\r\n at CPSReporting.TelerikCPSReportProcessor.RenderExcelReport(CPSReportDefinition reportDefinition) in c:\\Code\\CPS_SVN_REPO\\CPSReporting\\trunk\\TelerikCPSReportProcessor.cs:line 78\r\n at CreditPoint.Web.Controllers.WebAPI.ReportController.PrepResponse(HttpRequest request) in c:\\Code\\CPS_SVN_REPO\\Web\\branches\\RB-4.6\\Controllers\\WebAPI\\ReportController.cs:line 69\r\n at CreditPoint.Web.Controllers.WebAPI.ReportController.Post() in c:\\Code\\CPS_SVN_REPO\\Web\\branches\\RB-4.6\\Controllers\\WebAPI\\ReportController.cs:line 27\r\n at lambda_method(Closure , Object , Object[] )\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass13.b__c(Object instance, Object[] methodParameters)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.<>c__DisplayClass5.b__4()\r\n at System.Threading.Tasks.TaskHelpers.RunSynchronously[TResult](Func`1 func, CancellationToken cancellationToken)"}

I believe the stack trace is the same for both XLS and XLSX device formats.  As I said, this is only happening with one of my reports (which happens to contain a subreport).  All other reports work just fine when exporting to Excel.

Here's the code:

InstanceReportSource instanceReportSource = new InstanceReportSource();
XmlReaderSettings xmlReaderSettings = new XmlReaderSettings();
xmlReaderSettings.IgnoreWhitespace = true;
ReportXmlSerializer serializer = new ReportXmlSerializer();
XmlReader primaryReportXmlReader = XmlReader.Create(reportDefinition.PrimaryReport.TemplateLocation, xmlReaderSettings);
Telerik.Reporting.Report primaryReport = (Telerik.Reporting.Report)serializer.Deserialize(primaryReportXmlReader);
primaryReportXmlReader.Close();
this.SetConnectionStrings(ref primaryReport, reportDefinition.ConnectionString);
instanceReportSource.ReportDocument = primaryReport;
if (reportDefinition.PrimaryReport.ReportParameters != null)
{
    foreach (KeyValuePair<string, object> item in reportDefinition.PrimaryReport.ReportParameters)
        instanceReportSource.Parameters.Add(this.CreateParameter(item.Key, item.Value));
}
foreach (CPSReport cpsSubReport in reportDefinition.SubReports)
{
    XmlReader xmlReader = XmlReader.Create(cpsSubReport.TemplateLocation, xmlReaderSettings);
    Telerik.Reporting.Report subReportInstance = (Telerik.Reporting.Report)serializer.Deserialize(xmlReader);
    xmlReader.Close();               
    this.SetConnectionStrings(ref subReportInstance, reportDefinition.ConnectionString);
    Telerik.Reporting.SubReport subReport = primaryReport.Items.Find(cpsSubReport.ReportName, true).FirstOrDefault() as Telerik.Reporting.SubReport;
    ReportSource subReportSource_Type = subReport.ReportSource;
    InstanceReportSource subReportSource_Instance = new InstanceReportSource();
    subReportSource_Instance.ReportDocument = subReportInstance;
    foreach(Telerik.Reporting.Parameter param in subReportSource_Type.Parameters)
        subReportSource_Instance.Parameters.Add(param);
    subReport.ReportSource = subReportSource_Instance;
}
Hashtable settings = new Hashtable() {
    { "UseNativePageHeader", false },
    { "UseNativePageFooter", true },
    { "ShowGridLines", false }
};
//Exception thrown here:
RenderingResult result = _reportProcessor.RenderReport("XLS", instanceReportSource, settings);
return result.DocumentBytes;

Thank you in advance,
An otherwise extremely happy Telerik user  :)
Adam
Top achievements
Rank 1
 asked on 30 May 2013
3 answers
51 views
Hi ,
    I have web application where i am using 2 reports in the same page , when I access the web application from IPAD safari (IOS6) when a telerik report page opens ,  randomly either the first or the second report will be blank and if I click on next button report loads the next page and then I have to click the previous to see the first page which was blank. im using Telerik Q1 20113 build 7.0.13.412(7.0.13.412) and this is an urgent issue to fix.
Stef
Telerik team
 answered on 30 May 2013
7 answers
385 views
Hi there!

We’ve identified that the reporting component returns verbose error messages with a 200 HTTP status code, making our application vulnerable to XSS attacks. 

Please could you contact us privately, as soon as possible for more details.

Thanks, in advance.
Bill
Top achievements
Rank 1
 answered on 30 May 2013
0 answers
37 views
Hello,

1. I need the image filter (ie, it must allow only image files) when i click Select Button in RAD UPLOAD control and not in validation.

2. I change "a.doc" files extension as "a.jpeg" and trying to upload the "a.jpeg" file. How to stop uploading the a.jpeg file as because it's not an image file.
How to do validation using java script?

Regards
Jayanthi
jayanthi
Top achievements
Rank 1
 asked on 30 May 2013
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?