Telerik Forums
Reporting Forum
7 answers
123 views
Hi
I upgraded my reports to new version Q3 2010 and after upgrading my reports return error "Some internel error occur" 
Problem occur when i add group field in report. I did grouping on Fields.ReceivedDate
My query is
string strQuery = @"Select TS.*, Convert(varchar(10), DATEADD(hh,4, TS.ReceivedTime), 101) as ReceivedDate, 
                  DATEADD(hh,4, TS.ReceivedTime) as ReceivedTime 
                  From TrackStatus TS  
                 ORDER BY TS.ReceivedTime ";

i have defined this query in Need_DataSource event

In Q1 2010 version my report was running well but after upgrading it returns error when we preview report
However if i create database function for above query and use function then reports work well
Please help me what is wrong

Massimiliano Bassili
Top achievements
Rank 1
 answered on 31 Jan 2011
6 answers
79 views
Hi,

I would like to create a report from a Telerik.Reporting.ObjectDataSource.
I need to generate a report from the top to the bottom and not from left to right which seems to be the default behavior.

I didn't find a simple way to do it.

Is it possible to do it simply ?
if yes, how can I do it ?

Thanks for your answer.

Regards.

Fred
Cantenot Frederic
Top achievements
Rank 1
 answered on 31 Jan 2011
0 answers
111 views
Hi Team,

In Silverlight application I'm using WCF RIA Services on the basis of LINQ2SQL datamodel. In the DomainService class on the server side the datacontext returns collection of entities as IEnumerable. How to use this as datasource for the report? How to design the report, when the IEnumareble is available only at runtime?

As I read, You have an entitity datasource, does You plan to create a LINQ2SQL datasource too, or do you have any workaround to use LINQ2SQL directly in reporting from SL app?

Thanks in advance

Gabor
Gabor
Top achievements
Rank 1
 asked on 31 Jan 2011
1 answer
139 views
Hi! I set up a link in the main report where I have my list of say customers and next to each customer i have a View Report link, now I tried to make that point to a report book (no designer, just the report.cs) where i am programmatically adding some reports to it.So the action of the link does not like passing to it a report book...It's saying the instance can not be created. It works it i set the Navigate To a regular report, but I would like a way to just navigate to the report book.  How do i do this?  Thankx for the help.
ethan
Top achievements
Rank 1
 answered on 29 Jan 2011
2 answers
139 views
I have Windows 7 64 bit. I have already installed Telerik Reporting Q2 2010. Now I want to install Telerik_Reporting_Q3_2010_SP1_TRIAL.msi.
It is throwing an error as "Need .Net 2.0 or Higher". It is exiting the installer. I have attached the screen shots.

Thanks,
Deba

Debajyoti
Top achievements
Rank 1
 answered on 28 Jan 2011
1 answer
100 views

Hi,
My silverlight app works fine on my dev machine, but after deploying on IIS7 I have error at report viewer.
Exception details:
System.NullReferenceException: Object reference not set to an instance of an object.
   at Telerik.ReportViewer.Silverlight.ReportViewerModel.UpdateUI()
   at Telerik.ReportViewer.Silverlight.ReportViewerModel.set_PageRoot(FrameworkElement value)
   at Telerik.ReportViewer.Silverlight.ReportViewerModel.SetError(String message)
   at Telerik.ReportViewer.Silverlight.ReportViewerModel.SetError(Exception ex)
   at Telerik.ReportViewer.Silverlight.ReportViewerModel.OnListRenderingExtensionsCompleted(Object sender, ListRenderingExtensionsEventArgs e)
   at Telerik.Reporting.Service.SilverlightClient.ReportServiceClient.OnListRenderingExtensionsCompleted(Object state)

The bin folder contains the following assemblies:

  • Telerik.Reporting.dll
  • Telerik.Reporting.Service.dll
  • Telerik.Reporting.XamlRendering.dll

Could somebody help me?

Steve
Telerik team
 answered on 28 Jan 2011
0 answers
96 views
Hi,

I am facing some issue with the sqldatasource it works with 64 bit SqlLite driver but with a 32 bit sqlLite driver it gives cannot create connection to the database error.. Is there any solution or workaround to this problem... any help would be appreciated..

Regards,
Rohan Henry


 
rohan
Top achievements
Rank 1
 asked on 28 Jan 2011
1 answer
88 views
I am using dotnetnuke to show my report but I don't know why I am getting this exception.



This is my telerik report project code and I have added this reference in my website.

Partial Public Class jobReport
    Inherits Telerik.Reporting.Report
    Public Sub New()
        InitializeComponent()
        Me.datasource = Nothing
    End Sub


    Private Sub jobReport_NeedDataSource(ByVal sender As Object, ByVal e As System.EventArgs)
        ' Take the Telerik.Reporting.Processing.Report instance
        Dim report As Telerik.Reporting.Processing.Report = DirectCast(sender, Telerik.Reporting.Processing.Report)


        ' Transfer the processing Parameter value to the parameter of the select command         
        Me.SqlDataAdapter1.SelectCommand.Parameters("@p_JobID").Value = report.Parameters("ID").Value


        ' and set the adapter as it's DataSource         
        report.DataSource = Me.SqlDataAdapter1
    End Sub


End Class This is my website code and i am adding one parameter here and passing a value from query string.  Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load


        If Not IsPostBack Then


            Dim nJobID As Integer
            nJobID = Request.QueryString("JobID")
            If nJobID <> 0 Then
                Dim rptJobList As New jobReport
                Dim reportParameter1 As New Telerik.Reporting.ReportParameter()
                reportParameter1.Name = "ID"
                reportParameter1.Text = "Enter Value for Parameter1"
                reportParameter1.Type = Telerik.Reporting.ReportParameterType.Integer
                reportParameter1.AllowBlank = False
                reportParameter1.AllowNull = False
                reportParameter1.Value = nJobID
                reportParameter1.Visible = True
                rptJobList.ReportParameters.Add(reportParameter1)
                rptJobList.ReportParameters("ID").Value = nJobID
                reportViewer.Report = rptJobList
            End If


        End If
    End Sub An error occurred loading a configuration file: Failed to map the path '/'.   at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)
   at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)
   at System.Configuration.Configuration..ctor(String locationSubPath, Type typeConfigHost, Object[] hostInitConfigurationParams)
   at System.Configuration.Internal.InternalConfigConfigurationFactory.System.Configuration.Internal.IInternalConfigConfigurationFactory.Create(Type typeConfigHost, Object[] hostInitConfigurationParams)
   at System.Web.Configuration.WebConfigurationHost.OpenConfiguration(WebLevel webLevel, ConfigurationFileMap fileMap, VirtualPath path, String site, String locationSubPath, String server, String userName, String password, IntPtr tokenHandle)
   at System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(String path)
   at Telerik.ReportViewer.WebForms.ReportViewer.CheckHandlerConfiguration()
   at Telerik.ReportViewer.WebForms.ReportViewer.CheckHttpHandlerRegistrations()
   at Telerik.ReportViewer.WebForms.ReportViewer.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Control.AddedControl(Control control, Int32 index)
   at System.Web.UI.ControlCollection.Add(Control child)
   at phdcc.CodeModule.View.Page_Load(Object sender, EventArgs e) in C:\inetpub\wwwroot\DNN\DesktopModules\phdcc.CodeModule\View.ascx.vb:line 92
Peter
Telerik team
 answered on 28 Jan 2011
6 answers
162 views
Hello,
I've got a report that contains 5 subreport...sometimes I get a object not set to an istance of an object excetpion in a subreport when generating the report using

       res = reportProcessor.RenderReport("PDF", report, null);

checking for res.Error returns me string.Empty always... I've debugged and if I put the Error event handler in the nested report I got the exception.... since I generate the report in parallel (almost 18.000 reports) I need to know which report failed in order to regenerate it later....

Is there a way of generating the report and the subreport in an sync way? I think that the report generate in an async way calling the subreport's report for increasing performance but in my case I can wait and have it to be generated slower but safer...

Thanks
Steve
Telerik team
 answered on 28 Jan 2011
2 answers
72 views
I started a trial and I am creating a report using a static class that its on the same report for data retrieval purpose by means of example here is the code of the static class

using System;
 
namespace ExampleReport
{
    public static class bringData
    {
        public static string data1 { get; set; }
        public static string data2 { get; set; }
        public static string data3 { get; set; }
        public static string data4 { get; set; }
   public static string data5 { getset; }
    }
}

and the report class includes this custom methods that retrieves information from the bringData Class

public static string test1() { return bringData.data1; }
public static string test2() { return bringData.data2; }
public static string test3()  {   return bringData.data3;    }
public static string test4()    {   return bringData.data4; }
public static string test5()    {   return bringData.data5; }

then on 5 diferent telerik textboxes on the report header section using the expression context menu I select custom function and Bind each custom function to each textbox i.e   = data1()

but if I use more than 3 custom functions/functions I get a blank report, and if I use 3 or less custom functions/functions i get the expected behaivor of bringing the contents of the source class

is this a known bug issue?? suggestions?
Steve
Telerik team
 answered on 28 Jan 2011
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?