Telerik Forums
Reporting Forum
2 answers
96 views
Hi,

I came across few posts of past where it has been said that Passing the DataSource of the report from Silverlight to the ReportingService is not possible.
As its been talk of more than a year back, I am wondering if it is possible now? If yes then how ?

Thanks,
Jono
Jonathan
Top achievements
Rank 1
 answered on 17 Nov 2010
2 answers
194 views
Hi,
    I just installed Trial version of Telerik Reporting Q3 2010 with VS2008 & VS2010 Support. But when I create report, I get above error. I have attached screen shot here. How to get pass this error? I am using Windows 7.

Thank you

Nick
Top achievements
Rank 1
 answered on 17 Nov 2010
0 answers
55 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
180 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
87 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
141 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
584 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
442 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
114 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
279 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
Top users last month
Top achievements
Rank 1
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ivory
Top achievements
Rank 1
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
YF
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?