Telerik Forums
Reporting Forum
1 answer
102 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
139 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
358 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
143 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
198 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
1 answer
92 views
After upgrading to Reporting Q3 2010 and getting my reports working on development box, I've run into the "ReportViewer is undefined" error after publishing my web site to our test server.  I followed the instructions for putting the Telerik Reporting dll's into the web site bin folder, and these are being propagated out to the server.

In development, do I need to change the references in the web site to the /bin/...dll files rather than having the references to the dll's in the Telerik ProgramFiles area?

Dan
Dan
Top achievements
Rank 2
 answered on 23 Feb 2011
1 answer
323 views
I have a vertical bar chart where I am filling the chart series from the code-behind, and the x-axis values are dates.
I need to draw a line across the chart that represents a "target" value.
I have read the documentation for using the ChartMarkedZone for this purpose, so I tried this code but it does not work.
Telerik.Reporting.Processing.Chart chart = (Telerik.Reporting.Processing.Chart)sender;
Telerik.Reporting.Chart chartDef = (Telerik.Reporting.Chart)chart.ItemDefinition;
Telerik.Reporting.Charting.ChartSeries series = new Telerik.Reporting.Charting.ChartSeries();
 while (dtThisDate <= dtEndDate)
  {
                seriesItem = new Telerik.Reporting.Charting.ChartSeriesItem();
                seriesItem.YValue = (long)barvalue;
                seriesItem.Label.TextBlock.Appearance.TextProperties.Color = Color.Black;
                series.AddItem(seriesItem);
                chartDef.PlotArea.XAxis.Items.Add(new ChartAxisItem(dtThisDate.Month.ToString() + "/" + dtThisDate.Day.ToString() + "/" + dtThisDate.Year.ToString()));
}
if (targetParm != "" && targetParm != "0")
                {
                    Telerik.Reporting.Charting.ChartMarkedZone mzone = new ChartMarkedZone();
                    mzone.ValueStartY = Convert.ToInt32(targetParm);
                    mzone.ValueEndY = Convert.ToInt32(targetParm);
                    mzone.ValueStartX = chartDef.PlotArea.XAxis.MinValue;
                    mzone.ValueEndX = chartDef.PlotArea.XAxis.MaxValue;
                    mzone.Appearance.Border.Color = Color.Red;
                    mzone.Appearance.Border.Width = 3;
                    chartDef.PlotArea.Add(mzone);
                }

The problem is that setting mzone.ValueStartX = chartDef.PlotArea.XAxis.MinValue
does not work.  But what do I set the ValueStartX and ValueEndX values to when my x-axis points are dates?

Thanks for any help.  Dan
Giuseppe
Telerik team
 answered on 23 Feb 2011
1 answer
127 views
Hi,

I am having some issues with printing from the WPF reportviewer.

1.  In most cases only the middle third of the page is being printed.  My page is set to A4 landscape, with 1.5 cm borders all around, and the top third and bottom third of each page are simply not printed - the middle of the table is though.

2.  When clicking print, I am unable to select a page range in the print options, it is greyed out.  I have tried this on several machines with several different printers so am pretty sure it is not an issue with local configuration.

Any help is much appreciated.

Thanks
Rob
Peter
Telerik team
 answered on 23 Feb 2011
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?