Questions on Reporting Forum

1 answer

121 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?

General Discussions

answered on 28 Jan 2010

4 answers

1.4K+ views

Suppress repeated detail report values

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

General Discussions

answered on 28 Jan 2010

4 answers

161 views

User Function Error

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.

General Discussions

answered on 27 Jan 2010

12 answers

520 views

Report lose formatting after Export in Excel

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

General Discussions

answered on 26 Jan 2010

1 answer

182 views

ReportViewer & Auto Save ?

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", null, out 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

General Discussions

answered on 26 Jan 2010

4 answers

137 views

Data Appearing in Accurately In Stack Bar Chart in Report

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.Object, ByVal 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

General Discussions

answered on 26 Jan 2010

0 answers

67 views

Can Reporting READ a PDF?

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?

General Discussions

asked on 26 Jan 2010

1 answer

195 views

Multiple Values

Hi,
i have a 1 page report with shows users information via ssn.I built a parameter for user names and surnames its gives the report of this user via ssn value of the parameter.I want to ask that when i give this param multiple value property true and give the report filter IN operator when i select two users it does not shows 2 different users in 2 different pages and report runs very slowly.Sometimes gives not responding error.

General Discussions

answered on 25 Jan 2010

2 answers

138 views

DevExpress Charts in Telerik Report

Hi All,

Yeah I know, sacrilige etc, but can a chart from another vendor be used in a Telerik Report (apart from generating as an image saving to disk and then pulling back into the report)?

Regards,

Jon

General Discussions