Telerik Forums
Reporting Forum
0 answers
52 views
Using the silverlight reportviewer and opening a report and looking at the parameter section, if it's a multiselect list when i click the dropdown I see the DisplayMember values (let's say Red, Blue, Green) and I can select the ones I want, but when the dropdown goes back up it shows a list of the ValueMembers ( 1,2 instead of Red, Blue -- when I selected Red, Blue)

Is there a setting I am missing in Silverlight or in the report to fix this?

(v 4.1.10.921 )
Michael
Top achievements
Rank 1
 asked on 17 Nov 2010
2 answers
169 views
2010 Q3 Reporting, using the Web Report Viewer:

Is there any way within an event for the Report object, or within an event for the Web Report Viewer control to detect that a report is being rendered to CSV and programmaticly modify the report layout (in order to hide any textboxes that have aggregate functions).

I have many reports with several groups and group "total" rows. This layout is desired for online/print/excel, but it's making the CSV export completely useless since there are so many "total" columns exported along with the actual data columns.

Alternatively, if this can't be handled via code on the Report object or the page that houses the Web Report Viewer control - then can I extend or replace the actual CSV rendering module easily?
theksmith
Top achievements
Rank 1
 answered on 17 Nov 2010
2 answers
77 views
I am trying to sort a group in descending order. On the edit sorting dialog box I set the expression and then change the sort order to DESC. When I click OK I get an error dialog "DataGridView Default Error Dialog" The field that I am using is not the field I am grouping on.

Group Field is: EquipmentID
Sort Field is: ExtendedCost

See the attached file for the Error Dialog

Reporting version Q3 2010

Thanks
Scott
Scott
Top achievements
Rank 2
 answered on 17 Nov 2010
6 answers
130 views
RESOLVED: We have come up with a solution to use XML config file for report definitions that reference reports in a newly deployed class.
 
============

Our company would like to be able to distribute a set of reports and update them or add new reports without compiling or using a "Report Server" of any kind.

Does Telerik have any plans to support this anytime soon?

Thanks!
Paul Patterson
Top achievements
Rank 1
 answered on 17 Nov 2010
4 answers
540 views
When a report is exported to Excel, it generally works fine. However, here is one problem that I am encountering. In some textbox field, I have CanGrow set as True. Therefore, it the data is longer than the allowed field, it will print to next line which is fine. The problem comes when this is exported to Excel.  If the field is exported Excel, the textbox occupies more than one row(merged row) instead of the whole text should be in one row with longer field.  This prevent the user from sorting properly form Excel.

For example, if it should print, "Hello world, this is me", In textbox it will print as follow.
|Hello World|
|This is me  |

In Excel, it will print,
ROW A  |Hello World|
ROW B  |This is me  |

I would like it to print
ROW A  |Hello World|
              |This is me  |
ROW B

How can this be fixed?
Steve
Telerik team
 answered on 17 Nov 2010
3 answers
428 views
Good morning,
I am having an issue with reporting and getting the selected value of a databound combobox. The value only returns the selectedItem.Text of the combobox and I wish to get the selectedValue instead.
Could you let me know what the code would be to achieve this please?

The Lists are defined as:

 
 
    Public Shared Function ReturnTypes() As ForecastTypeCollection 
        Dim pTypeCol As New ForecastTypeCollection 
        For i As Integer = 0 To 2 
            Dim pType As New ForecastType 
            Select Case i 
                Case 0 
                    With pType 
                        .ValueMember = "Both" 
                        .DataMember = "" 
                    End With 
                Case 1 
                    With pType 
                        .ValueMember = "UK" 
                        .DataMember = "UK" 
                    End With 
                Case 2 
                    With pType 
                        .ValueMember = "International" 
                        .DataMember = "EX" 
                    End With 
            End Select 
            pTypeCol.Add(pType) 
        Next 
        Return pTypeCol 
    End Function 
 
    Public Shared Function ReturnPeriods() As PeriodCollection 
        Dim p As New PeriodCollection 
        For i As Integer = 1 To 12 
            Dim pPeriod As New Period 
            With pPeriod 
                .DataMember = i 
                .ValueMember = i 
            End With 
            p.Add(pPeriod) 
        Next 
        Return p 
    End Function 

and then they are assigned to the parameters as below:



    Public Sub New() 
        InitializeComponent() 
 
        Report.ReportParameters()(0).UI.AvailableValues.DataSource = ReturnTypes() 
        Report.ReportParameters()(0).UI.AvailableValues.DataMember = "DataMember" 
        Report.ReportParameters()(0).UI.AvailableValues.ValueMember = "ValueMember" 
 
        Report.ReportParameters()(1).UI.AvailableValues.DataSource = ReturnPeriods() 
        Report.ReportParameters()(1).UI.AvailableValues.DataMember = "DataMember" 
        Report.ReportParameters()(1).UI.AvailableValues.ValueMember = "ValueMember" 
    End Sub 

Then I bind the report as follows:

    Private Sub ForecastNextPeriod_NeedDataSource(ByVal sender As System.ObjectByVal e As System.EventArgs) Handles MyBase.NeedDataSource 
        Try 
            Dim pCalendar As Calendar = ReturnCurrentYearAndPeriod() 
            Dim pType As String = ReportParameters("Type").Value 
            Dim pPeriodCount As Integer = Me.ReportParameters("PeriodCount").Value 
 
            DirectCast(sender, Telerik.Reporting.Processing.Report).DataSource = ReturnForecastReport(pPeriodCount, pCalendar.Period, pCalendar.Year, pType) 
        Catch ex As Exception 
            MsgBox(ex.ToString) 
        End Try 
    End Sub 

pType and pPeriodCount only grab the selected item. I have tried searching the forums and reading documentation but I can not find anything that explains how to get the selected value.
Any help would be appreciated.

cheers,
Jaymie
Steve
Telerik team
 answered on 17 Nov 2010
1 answer
105 views
I   want  to  display   Date   on  x-axis of  my chart.
I my database  My date is in the format of DateTime. The column Name is Date..
I  had written the code as    
chart1.PloatArea.XAxis.DataLabelsColumn="Date";

But  it  is giving  
an error message  saying  that  unable to cast System.DateTime   to System.String
Provide me solution  for that
Steve
Telerik team
 answered on 17 Nov 2010
5 answers
236 views
I have an issue where I have a series of lists or panels that might or might not contain data. If they don't contain data I want them to shrink down to their minimum height.

is this possible?

I attached screenshots I hope help illustrate what I am trying to accomplish.


**Update - Continuing to look at the documentation, it looks like perhaps docking or anchoring would accomplish this... but I am not positive how to go about it. I will continue playing... I welcome any assistance though.
Steve
Telerik team
 answered on 17 Nov 2010
1 answer
178 views
Hi,

Is there any way that I can customize the report while exporting it to PDF? I want to reset the font and spacing between two columns in Multi-Column Report.

Please advise!
-Krunal
Peter
Telerik team
 answered on 17 Nov 2010
1 answer
77 views
Hi,

I downloaded the trial version of the Reporting module. I try to change one of the report examples -  Report Catalog.cs. This example has already one filter condtion set:

=Fields.IsVisible = =True.

I try to add additional filter and this time I want to use "like" operator as shown below:

And =Fields.Description Like ...

After choosing operator "like" and trying to move to Value column I get an error: "System.ArgumentOutOfRangeException: Index was out of range."

How can I add a "like" condition to filter selection?

I use the following OS:
  • XP SP3.
  • Regional and language settings: pl-PL.
  • Telerik Reporting version: Telerik_Reporting_Q3_2010_v4_2_10_1110_trial. 
  • Alicja

    Steve
    Telerik team
     answered on 17 Nov 2010
    Top users last month
    Rob
    Top achievements
    Rank 3
    Iron
    Iron
    Iron
    Atul
    Top achievements
    Rank 1
    Iron
    Iron
    Iron
    Alexander
    Top achievements
    Rank 1
    Veteran
    Iron
    Serkan
    Top achievements
    Rank 1
    Iron
    Shawn
    Top achievements
    Rank 1
    Iron
    Iron
    Want to show your ninja superpower to fellow developers?
    Want to show your ninja superpower to fellow developers?