Telerik Forums
Reporting Forum
1 answer
161 views

I am converting some Crystal Reports to telerik reporting.  We use XML that is stored in a database as the datasource and already use the readxml method to load a dataset.  That works fine.  I am using the following code to instantiate the report viewer, I got this from the samples included with the trial download.  It works and I get the report on screen.  My problem is that I don't find a 'DataSource' property suggested in option 2 of a previous thread on any of the objects below in which to assign my dataset.  I'm sure that I'm missing something simple, but have looked for several hours and haven't found it.  Can you help?

Dim reportName As String = Server.UrlDecode(sReportName.ToString)   
 
If Not String.IsNullOrEmpty(reportName) Then   
 
    Dim reportType As TypeType = Type.[GetType](reportName)   
    Dim report As IReportDocument = DirectCast(Activator.CreateInstance(reportType), IReportDocument)   
 
    Me.ReportViewer1.Report = report   
 
    Me.Page.Title = "Reports - " + ReportTitle.ToString   
   
End If  
 
 

 


 

Steve
Telerik team
 answered on 28 Jan 2010
1 answer
229 views
Hi,

I have a problem while exporting report in Excel format, it shows all the data correctly but page footer is missing in exported excel sheet. Would you please guide me if there is any setting needed for this?

Thanks,
Dev Motiramani 
Steve
Telerik team
 answered on 28 Jan 2010
0 answers
92 views
Hi

I want to show some dynamic values in telerik report,So i need to add Columns corresponding to the each value at runtime,
Please help me to create dynamic columns in telerik report.
Jini A B
Top achievements
Rank 1
 asked on 28 Jan 2010
0 answers
123 views
Hi

I want to show some dynamic values in telerik report,So i need to add Columns corresponding to the each value at runtime,
Please help me to create dynamic columns in telerik report.
Jini A B
Top achievements
Rank 1
 asked on 28 Jan 2010
1 answer
137 views
I have 10 fields in the dataset which drives my report. 

On-screen I display fields 1-8 and 10.  I need to export fields 1-9 to a CSV file.

Is that possible?


Steve
Telerik team
 answered on 28 Jan 2010
4 answers
1.4K+ views
Hi,

I have a simple reporting requirement that must have been solved many times but I'm not able to find any information from the forum postings.  Any suggestions would be appreciated; requirement as follows:

1.  A simple report with only detail section, e.g. member #, name, and dues paid:

        1234     John Alan              2008    $100.00
        1234     John Alan              2009    $100.00
        1763     Peter Brown           2009      $80.00
        2286     Jane Jones            2008   $100.00
        2286     Jane Jones            2009    $100.00

2.  What I would like to do is to suppress the member # and name values that are repeats from the previous rows:
    
        1234     John Alan             2008    $100.00
                                                2009    $100.00
        1763     Peter Brown          2009     $80.00
        2286     Jane Jones           2008   $100.00
                                                2009    $100.00

I'm not able to figure out how to compare the values from the current row with values from the previous rows in code.  Can anyone help?

Thanks,

Barry
Steve
Telerik team
 answered on 28 Jan 2010
4 answers
172 views
Hello Everyone,

I am getting below error while calling User defined function in Telerik Report.
I didn't find anything wrong with this code.

"The error has occured while processing TextBox 'textBox1':
This expression contains undefined function call DateLeft().


Please See below code

this

 

.textBox1.Value = "= DateLeft(Fields.DateReleased,EndofMonths(Fields.Month))";

DataType of Fields.DateReleased is System.DateTime
DateType of Fields.Month is System.Int32.  

 

 

 

 

Public static string DateLeft(DateTime ReleasedDate, DateTime EndofMonth)  

{

  string strReturn = "";  

  if ((ReleasedDate == null || ReleasedDate == DateTime.MinValue) ||  (EndofMonth !=  null && EndofMonth != DateTime.MinValue && ReleasedDate > EndofMonth.AddDays(1)))  

         strReturn = "IN JAIL";    

else  

       strReturn = ReleasedDate.ToString("MM/dd/yyyy hh:mm");     

return strReturn;  

 }

EndofMonth is another User defined function that passes as argument of above user defined function 

public static DateTime EndofMonths(int parMonth)  

 { 

   if (parMonth == 12)  

        return new DateTime(DateTime.Now.Year, 1, 1);   

else   

        return new DateTime(DateTime.Now.Year, parMonth + 1, 1); 

}  

 



I don't know but this error occurs only when Report first time open after user logged in application. After user second time open this report then this error don't occurs,
please review above code and give me reply what is the problem in above code.
I am waiting your reply. Please give me reply as soon as possible.

Thanks in advance.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Steve
Telerik team
 answered on 27 Jan 2010
12 answers
544 views
Hello,

I have a textbox on my report with value 0.083333333. I formatted this Textbox with the format {0:#.000}. In the preview the value is formatted with 3 decimal places.

When I export this preview to Excel, the report lose this formatting.

Someone can help me?

Thx
Bruno
Vanessa Saraiva
Top achievements
Rank 1
 answered on 26 Jan 2010
1 answer
195 views
hello,

I find something to save the document directely avec the generation... But it's not working with the relerik reportviewer

            Warning[] warnings; 
            string[] streamids; 
            string mimeType; 
            string encoding; 
            string extension; 
 
            byte[] bytes = reportViewer1.LocalReport.Render( 
               "PDF"nullout mimeType, out encoding, out extension, 
               out streamids, out warnings); 
 
            FileStream fs = new FileStream(@"c:\output.pdf", FileMode.Create); 
            fs.Write(bytes, 0, bytes.Length); 
            fs.Close();  


Do you have any solution to save directely the file on the serveur ?
thank you
Steve
Telerik team
 answered on 26 Jan 2010
4 answers
147 views

I am working on a report , where i have to display  a stackbar chart .  But chart does not display accurate data .
please find attachement for report pdf and code file . please help me Asap.




  Private Sub Chart1_NeedDataSource(ByVal sender As System.ObjectByVal e As System.EventArgs) Handles chart1.NeedDataSource  
        Try 
            Dim StrSqlConnection As String = ConnectionString  
            If Trim(StrSqlConnection) <> "" Then 
                If Not ObjSqlCon Is Nothing Then 
                    ObjSqlCon = Nothing 
                End If 
                ObjSqlCon = New SqlConnection(StrSqlConnection)  
                ObjSqlCon.Open()  
                If ObjSqlCon.State = ConnectionState.Open Then                      
                    Dim chart1 As Telerik.Reporting.Processing.Chart = CType(sender, Telerik.Reporting.Processing.Chart)  
                    Dim defChart As Telerik.Reporting.Chart = DirectCast(Chart1.ItemDefinition, Telerik.Reporting.Chart)  
                    Dim ProjectRpt As New ProjectTrendDstTableAdapters.ReportProjectTrendAnalysisTableAdapter  
                    ProjectRpt.Connection = ObjSqlCon  
                    Dim ProjectDst As New ProjectTrendDst.ReportProjectTrendAnalysisDataTable  
                    ProjectDst = ProjectRpt.GetData  
                    SalesPersonQChart.DataSource = ProjectDst  
                    defChart.DataGroupColumn = "Status"                      
                    defChart.PlotArea.XAxis.DataLabelsColumn = "Territory" 
                    defChart.Legend.Appearance.GroupNameFormat = "#VALUE" 
                End If 
            End If 
        Catch ex As Exception  
 
        Finally 
            If ObjSqlCon IsNot Nothing Then 
                ObjSqlCon = Nothing 
            End If 
        End Try 
 
    End Sub 
Thanks and Regards,
Naginder Singh
Naginder Singh
Top achievements
Rank 1
 answered on 26 Jan 2010
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
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?