Telerik Forums
Reporting Forum
3 answers
386 views
When building expressions in the designer and there is a null string the resulting string is null

type = null
size = "5x5x1/2"
length = "5 feet"

expression
=Fields.type + " " + Fields.size + " " + Fields.grade

resulting value is null in report textbox

It sure would be nice to Directly support string.Format(string, params object[] items) in expressions.
My guess is the params is not easily translated. from an expression.
Steve
Telerik team
 answered on 24 Feb 2011
0 answers
87 views
Good morning all.  I guess this is what I get for staying up until 1 am working on reports!  I came into work this morning and was "cleaning up" my old reports, and deleted this file!  Now NOT ONE of my reports work!  Am I foo-barred?  Please say no?  When I open a report I can see my DataSource name, but it won't run.  I get this error: ClassLibrary.DataSetTableAdapters.DataSetTableAdapter' is not defined.

Any help is greatly appreciated!
Terri
Terri-Lynn
Top achievements
Rank 1
 asked on 24 Feb 2011
1 answer
92 views
Hi

I have a problem with my Silverlight application.
I'm using reporting telerik Q3 2010 and silverlight 4.
My solution is composed by:
  A project for the dll of the reports.
  A project for the Silverlight application, which has the report viewer.
  And the website that hosts the silverlight application.

When I deploy the web project on a web server , the reports don't display the charts

thanks in advance
Steve
Telerik team
 answered on 24 Feb 2011
1 answer
104 views
Unfortunately when exporting to XLS the accurate report layout is not guaranteed. For example row and column spacing can be inconsistent with what you see in the report viewer.

The problem was already reported and Telerik accepted it but nothing could do to address the issue.

Our application handles this problem by running the VBScript for resizing the spreadsheet rows after the exporting. This works reasonable fine if exporting is done programatically (after RenderReport returns):
ReportProcessor reportProcessor = new ReportProcessor();
RenderingResult result = reportProcessor.RenderReport(type, (IReportDocument)report, null);
    
But how to detect export completion and the exported file name if the report was exported by clicking the export button on the ReportViewer toolbar. I cannot find any appropriate event in ReportViewer for this.

Any suggestion would be appreciated.
Steve
Telerik team
 answered on 24 Feb 2011
1 answer
97 views
I had telerik installed (Telerik_Reporting_Q3_2010_v4_2_10_1221_dev) and generating reports just fine until i upgraded it with the latest telerik internal build (01059Telerik_Reporting_4_2_11_204_DEV). The new version had some designer issues so I un-installed it completely and installed the default mentioned version(which was working just fine for me till now).

 Now whenever i generate a report i get a following error message in the report viewer. I re-installed the telerik several times but no luck.

Error message
An exception occurred during the operation, making the result invalid.  Check InnerException for exception details.

What can i do to fix this?

Please let me know. Thanks.



Steve
Telerik team
 answered on 24 Feb 2011
3 answers
142 views
Hi,

I have a lot of reports which use many parameters, most of which are multiselect and allow null, where null means 'select all'.  Is there a way to customise the parameter area in the WPF reporting control so that rather than displaying the word NULL with a checkbox beside the dropdown, it can display the word ALL?

Thanks
Steve
Telerik team
 answered on 24 Feb 2011
1 answer
365 views
Hi,

I would like to use an expression like that in a report :
=IIF(Fields.ItemType <> "Value", Format("{0:P1}", Fields.Value1), Format("{0:## ### ###,}",Fields.Value1))

This expression is in the property 'value' of a textbox. The textbox is inside a 'Table'

Inside the report, I have a message which is : "an error occured while"

'ItemType' is a property of an object which is bound. It's also an enumeration which can contains 'None, Value or Pourcent'

So, if my object's properties contain pourcents, I would like to format my values in a certain way and if my object's properties contain values, I would like to format my values in another way.

Is it possible to do it when an enumeration is evaluate ?
What is wrong inside my expression ?

Thanks for your help.

Regards.

Fred
Cantenot Frederic
Top achievements
Rank 1
 answered on 24 Feb 2011
1 answer
144 views
I have a report parameter that is built off of a Role Table.  The Primary key of this table is RoleId(int).  The display value is RoleDisplay(varchar(50)).  It also contains ApplicationId which is a FK back to an Application table.
Example data would be as follows:
RoleId ApplicationId RoleDisplay
1 1 Administrator
2 2 Administrator
3 1 Viewer
4 1 Salesperson

This parameter is sourced from a Dataset that contains the Role Table.  The DisplayMember is set as RoleDisplay and the ValueMember is set as RoleId.  It is set as a MultiValue = True.

So, when I run the page this is on it loads all those roles into the parameter.  So, it displays:
Administrator
Administrator
Viewer
Salesperson

I then select all the roles.

In my code I am looping through the report parameter values and creating a string to send to a Stored Procedure.  When I loop through the values for the ReportParameter it returns 2,2,3,4.  It should return 1,2,3,4.  It is like it is really keying off of the display value.

I went in and changed the data in my table to:
RoleId ApplicationId RoleDisplay
1 1 Administrator
2 2 Administrator 2
3 1 Viewer
4 1 Salesperson

My code then returned the following role id's when all roles are selected.  1,2,3,4.

I am running Telerik Reporting Q3 2010 SP1 (4.2.10.1221)

I searched the forums and could not find this issue.

Thanks.

Private Function BuildParamList(ByVal paramType As String) As String
        Dim list As String = ""
        Dim count As Integer = 0
        For Each val As Integer In CType(Me.ReportParameters(paramType).Value(), Array)
            If count = 0 Then
                list = val.ToString
            Else
                list = list + "," + val.ToString()
            End If
            count = count + 1
        Next
 
        Return list
    End Function
 
    Private Sub AppDetailByRole_NeedDataSource(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.NeedDataSource
        'retrieve the data into the dataset
        Try
            Me.UsP_AppDetailByRoleContextTableAdapter1.Fill(Me.DataSet21.USP_AppDetailByRoleContext, _
                                                            BuildParamList("Application"), _
                                                            BuildParamList("Environment"), _
                                                            BuildParamList("Role"))
            TryCast(sender, Telerik.Reporting.Processing.Report).DataSource = Me.DataSet21.USP_AppDetailByRoleContext
        Catch ex As System.Exception
            'An error has occurred while filling the data set. Please check the exception for more information.
            System.Diagnostics.Debug.WriteLine(ex.Message)
        End Try
    End Sub



Peter
Telerik team
 answered on 24 Feb 2011
5 answers
117 views
Is it possible that a future release will contain the possibility to save a report-design to file?

We want to be able to load a report-design in runtime.
Steve
Telerik team
 answered on 24 Feb 2011
5 answers
201 views
Hi,


I have added the telerik report viwer to a custom web conrol so we can add a custom filter panel above the report viewer. everything seems to be working ok (reports run and report viewer renders) but when running a report it no longer displats the Generating report animation. any idea how i can fix this?

Thanks
Steve
Telerik team
 answered on 24 Feb 2011
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
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?