Telerik Forums
Reporting Forum
1 answer
239 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
104 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
130 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
160 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.5K+ 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
198 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
581 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
224 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
163 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
0 answers
87 views
Am I able to read\parse a PDF to display\rasterize it's data into my own report then feed that back out to the user?
sitefinitysteve
Top achievements
Rank 2
Iron
Iron
Veteran
 asked on 26 Jan 2010
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?