Telerik Forums
Reporting Forum
0 answers
36 views
Deare All,

i want to know how to concatinate more fields in one textbox seperated by "/" in expression of text box
Mahmoud
Top achievements
Rank 1
 asked on 08 Sep 2011
2 answers
213 views
Hello.

I want to save a report as an pdf-document. Herefore I use following code:


try
{
    ReportProcessor reportProcessor = new ReportProcessor();
    RenderingResult result = reportProcessor.RenderReport("PDF", report, null);
 
    using (FileStream fs = new FileStream(fileName, FileMode.Create))
    {
        fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
    }
}
catch (Exception ex)
{
    return false;
}

This actually works on the working machine debugged with VS2010. But when I want to use this as published version on the server the following error occurs (on rendering the report):

MESSAGE:
ExtensionParameter Unit on extension type Telerik.Reporting.ExcelRendering.Excel97.ExcelReport, Telerik.Reporting, Version=5.1.11.713, Culture=neutral, PublicKeyToken=a9d7983dfcc261be can not assign the specified value. -
 Stacktrace:    bei V10Portal.Core.ScheduledJobs.SendReportJob.saveReportOnHarddisk(Report report, String fileName) in F:\V10Portal\V10Portal.Core\ScheduledJobs\SendReportJob.cs:Zeile 408.
   bei V10Portal.Core.ScheduledJobs.SendReportJob.logSaveReports(String& logErrorIn, String reportsPath, List`1 reportsToSend) in F:\V10Portal\V10Portal.Core\ScheduledJobs\SendReportJob.cs:Zeile 701.
   bei V10Portal.Core.ScheduledJobs.SendReportJob.Run() in F:\V10Portal\V10Portal.Core\ScheduledJobs\SendReportJob.cs:Zeile 186.
 
STACKTRACE:
bei Telerik.Reporting.Interfaces.Attributes.ExtensionParameterAttribute.Apply(ExtensionInfo extInfo)
   bei Telerik.Reporting.Processing.ExtensionInfo.Create(Type extensionType, String extensionName)
   bei Telerik.Reporting.Processing.ExtensionManagerBase.CreateExtensionInfo(String typeName, String extensionName)
   bei Telerik.Reporting.Processing.ExtensionManagerBase.Load(ExtensionInfoCollection extensions, IEnumerable`1 extensionTypeNames)
   bei Telerik.Reporting.Processing.ExtensionManagerBase..ctor(IEnumerable`1 extensionTypeNames, ReportingConfigurationSection section)
   bei Telerik.Reporting.Processing.ExtensionManager.get_Instance()
   bei Telerik.Reporting.Processing.ExtensionManager.ListExtensions(Type extensionType)
   bei Telerik.Reporting.Processing.ReportProcessor.GetRenderer(String name)
   bei Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, IReportDocument reportDocument, Hashtable deviceInfo, Hashtable renderingContext, CreateStream createStreamCallback)
   bei Telerik.Reporting.Processing.ReportProcessor.RenderReportStateless(String format, IReportDocument reportDocument, Hashtable deviceInfo, Hashtable renderingContext, CreateStream createStreamCallback)
   bei Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, IReportDocument reportDocument, Hashtable deviceInfo)
   bei V10Portal.Core.ScheduledJobs.SendReportJob.saveReportOnHarddisk(Report report, String fileName) in F:\V10Portal\V10Portal.Core\ScheduledJobs\SendReportJob.cs:Zeile 404. -
 Stacktrace:    bei V10Portal.Core.ScheduledJobs.SendReportJob.saveReportOnHarddisk(Report report, String fileName) in F:\V10Portal\V10Portal.Core\ScheduledJobs\SendReportJob.cs:Zeile 408.
   bei V10Portal.Core.ScheduledJobs.SendReportJob.logSaveReports(String& logErrorIn, String reportsPath, List`1 reportsToSend) in F:\V10Portal\V10Portal.Core\ScheduledJobs\SendReportJob.cs:Zeile 702.
   bei V10Portal.Core.ScheduledJobs.SendReportJob.Run() in F:\V10Portal\V10Portal.Core\ScheduledJobs\SendReportJob.cs:Zeile 186.

May you have a solution or some hints for me what errors could have this exception in consequence?

Thanks.


Best regards

David
Marc
Top achievements
Rank 1
 answered on 08 Sep 2011
1 answer
121 views
Hello!

I have a telerik Report with various Date fields, 2 of them are the report parameters and the other is from my database.

I set the date format for my 2 textbox that shows the Selected date on the DateTimePicker to 01/01/2011
and to my date column i set a format like this: 01/01/2011 08:00 (with time)

My problem is, on development machine all works perfect, but when i deploy my application, the fields show the dates in a differente way,
all of them use this format 1/1/2011 (without the "0").

I tried everything untill now and had no success, my question is, there's something that i need to change to get this format on my date times in the server or something?

I attach a image taht shows the problem.

Thank you!
Steve
Telerik team
 answered on 08 Sep 2011
3 answers
98 views
when i use report in my project (winform) telerik report (Q1 2010 )will use dotnet 4.0 . i need to use only dotnet 2.0. how do i fix it.
thank you
Steve
Telerik team
 answered on 08 Sep 2011
4 answers
225 views
I recently upgraded to 2010 and am having issues with the new SQLDatasource. When I try to use a reportviewer in my web project, I get the error below. Previously in 2009 when I referenced the DLL, it brought across the data connections. With the new SQLDatasource, it does not seem to bring the conncetion string with it.

How do I seet the data connection in the 2010 version?


Unable to connect to database. Please verify that your connection string is valid; in case you use a connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application.

at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateConnection()
at Telerik.Reporting.Processing.Data.SqlDataEnumerable.SqlDataEnumerator.CreateReader()
at Telerik.Reporting.Processing.Data.SqlDataEnumerable.SqlDataEnumerator.MoveNext()
at Telerik.Reporting.Processing.Data.ResultSet.SeedData(IEnumerable`1 rawData)
at Telerik.Reporting.Processing.Data.ResultSet.Fill(IEnumerable`1 data)
at Telerik.Reporting.Processing.Data.SqlQueryProvider.Execute(MultidimensionalQuery query)
at Telerik.Reporting.Processing.ParametersManager`1.CalculateAvailableValues(T parameter, ReportParameterAvailableValues definition, Object& data)
at Telerik.Reporting.Processing.ParametersManager`1.Calculate(T parameter, IDictionary`2 parameterValues)
at Telerik.Reporting.Processing.ParametersManager`1.GetParameters(IDictionary`2 parameterValues)
at Telerik.ReportViewer.WebForms.ParametersPage.OnPreLoad(EventArgs e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Emmanuel
Top achievements
Rank 1
 answered on 07 Sep 2011
0 answers
174 views
My developers have a base report that is used as a class for all other reports. The base report has a datasource for some config information, which is used to populate a few text boxes. The textboxes were created in the designer, but the declarations were moved to the class. However, when a report uses this base as its parent, the textboxes show the message "An error has occurred while processing Textbox '[object name]'; the expression contains object [fieldname] that is not defined in the current context".

Data in the derived report is appearing properly, it's just the data in the parent report that is not appearing.

Any suggestions?
Derek
Top achievements
Rank 1
 asked on 07 Sep 2011
2 answers
161 views
Hello,

Testing on iOS 4.3.3 on an iPod, there are no scroll bars appearing for a report.

You can see this on the telerik demos at:

I've been told this is also an issue when viewing on iPhone 4 and iPad (original, we haven't tested iPad2)

Is this a known issue and if so are there any magic settings?

Thanks,
Dyana
Dyana
Top achievements
Rank 1
 answered on 07 Sep 2011
1 answer
305 views
Hi,

I am trying to evaluate the product and build a reporting solution using postgres DB.
In my case I need to build the report based on the result returned by a stored procedure(function in postgress) but I could not find any examples on postgress.
Can somebody help me and provide a sample or at least a link to some tutorials? 

While I was trying to integrate with postgres, I have found the following error(which was caused by a missing connection string parameter):
An error has occurred while processing Report 'Report2':
Exception has been thrown by the target of an invocation.
------------- InnerException -------------
ERROR: 42P01: relation "voa_keygen" does not exist Telerik.OpenAccess.RT.sql.SQLException: ERROR: 42P01: relation "voa_keygen" does not exist
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeQuery(String sql)
at OpenAccessRuntime.Relational.sql.HighLowRelationalKeyGenerator.IsCached(Connection con, RelationalKeyGeneratorInfoCache infoCache, String tab, String kCol, String vCol, String key, Boolean& ret)
at OpenAccessRuntime.Relational.sql.HighLowRelationalKeyGenerator.init(String className, RelationalTable theClassTable, Connection con, RelationalKeyGeneratorInfoCache relationalKeyGeneratorInfoCache)
at OpenAccessRuntime.Relational.RelationalStorageManagerFactory.init(Boolean full)
------------- InnerException -------------
ERROR: 42P01: relation "voa_keygen" does not exist

for everyone who had this issues with postgres, just specify, Protocol = 3 in Connection String and everything should work after.

Kind Regards,
Georgina.

Alexander
Telerik team
 answered on 07 Sep 2011
5 answers
546 views
how to  rotate the labels to  some angle  say 30 degree or 50 degree  so that  they must be tilted to some angles on the bars
Steve
Telerik team
 answered on 07 Sep 2011
1 answer
410 views
First off, let me start by saying that I'm not asking this question to strike a competency debate between Microsoft and Telerik versions of the Report Viewer functionality; but moreso to solicit candid opinions and facts so I can make an well-informed decision.

I know that there are a lot of similarities when it comes to the type of content that may be rendered and the methodologies used to acquire the rendered reports, what I am interested in are the most basic differences.

From what I can tell, one of the most obvious reason for choosing Telerik reporting over Microsoft would be the absense of a license to have access to the SSRS development environment in order to create Microsofts proprietary RDL schema based reports to support their ReportViewer control. Presenting the benefit that you can create and implement Telerik reports solely using the Telerik Reporting API in contrast to having need to purchase a Microsoft license.

Adversely, if someone had the requirement to develop a portal based on the existence of an SSRS Report Server where users created and uploaded their on reports then obviously the Telerik Report Viewer would not likely be the way to go under that set of circumstances.

Could anyone provide any other immediate benefits that I may have missed or are there any? I believe the Telerik reporting control is an excellent tool and it looks extremely similar to the MS ReportViewer control, I just need to get the raw basics on where the 2 differ.

Thanks!
Steve
Telerik team
 answered on 07 Sep 2011
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
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?