Questions on Reporting Forum

3 answers

285 views

Natural Sort

Hi,

I was wondering if there is some way to do a "natural sort" on my data in the report. The bulk of my columns are text strings that should also be numerically sorted.

ie.

Item 1
Item 10
Item 2

should be

Item 1
Item 2
Item 10

Any recommendations how I can accomplish what I need to do? I should also point out that I also have nested sorts so have the data pre-sorted doesn't work.

Ideally it would be great if there was some way to hook onto a callback or pass in an IComparer which does the sorting logic. This would be true of the grid control too.

Cheers,
Clint

General Discussions

answered on 23 Aug 2011

1 answer

93 views

Centering columns BarWidthPercent reduced when using BarOverlapPercent at 100%

I have a bar chart that has items overlapping - how do I center these overlapped bars
The code below aligns all the items to the left.

Overlapping is 100% but the additional stacked bars have had their widths reduced to half the width of the main series column. Please view the attached chart to see what I am attempting to achieve.

Dim oTargetSeries As New ChartSeries("Target")
Dim oAchievementSeries As New ChartSeries("Target Achievement")
Dim oVarianceAccSeries As New ChartSeries("Variance - Accessories")
Dim oVariancePartsSeries As New ChartSeries("Variance - Parts")

With oTargetSeries

.Clear()

.Appearance.FillStyle.FillType = FillType.Solid

.Appearance.FillStyle.MainColor = Color.Black

.Type = ChartSeriesType.Line

.YAxisType = ChartYAxisType.Primary

.Appearance.LabelAppearance.Visible = False

End With

With oAchievementSeries

.Clear()

.Appearance.FillStyle.FillType = FillType.Solid

.Appearance.FillStyle.MainColor = Color.Green

.Type = ChartSeriesType.Bar

.YAxisType = ChartYAxisType.Primary

.Appearance.LabelAppearance.Visible = False

End With

With oVarianceAccSeries

.Clear()

.Appearance.FillStyle.FillType = FillType.Solid

.Appearance.FillStyle.MainColor = Color.Yellow

.Type = ChartSeriesType.StackedBar

.YAxisType = ChartYAxisType.Secondary

.Appearance.BarWidthPercent = 50

End With

With oVariancePartsSeries

.Clear()

.Appearance.FillStyle.FillType = FillType.Solid

.Appearance.FillStyle.MainColor = Color.Blue

.Type = ChartSeriesType.StackedBar

.YAxisType = ChartYAxisType.Secondary

.Appearance.BarWidthPercent = 50

End With

oChart.Appearance.BarOverlapPercent = 100

With oChart

.PlotArea.Appearance.FillStyle.FillType = FillType.Solid

.PlotArea.Appearance.FillStyle.MainColor = Color.White

.IntelligentLabelsEnabled = False

.PlotArea.XAxis.AutoScale = False

.PlotArea.XAxis.IsZeroBased = False

.PlotArea.XAxis.Visible = False

.PlotArea.XAxis.AxisLabel.Visible = True

.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = 320

.PlotArea.XAxis.Appearance.Width = 3

.PlotArea.XAxis.LayoutMode = ChartAxisLayoutMode.Between

.PlotArea.YAxis.AutoScale = False

.PlotArea.YAxis2.AutoScale = False

.PlotArea.YAxis.Appearance.Width = 3

.PlotArea.YAxis.MaxValue = 200

.PlotArea.YAxis.MinValue = 0

.PlotArea.YAxis.Step = 20

.PlotArea.YAxis2.Appearance.Width = 3

.PlotArea.YAxis2.MaxValue = 200

.PlotArea.YAxis2.MinValue = -200

.PlotArea.YAxis2.Step = 50

.PlotArea.XAxis.Clear()

For Each oItem As clsRptPerformanceVsTarget In oRptPerformanceVsTargetList

Dim oChartAxisItem As New ChartAxisItem

oChartAxisItem.TextBlock.Text = oItem.CICode

.PlotArea.XAxis.Items.Add(oChartAxisItem)

For Each oItem As clsRptPerformanceVsTarget In oRptPerformanceVsTargetList

Dim oTargetItem As New ChartSeriesItem()

Dim oAchievementItem As New ChartSeriesItem()

Dim oVarianceAccItem As New ChartSeriesItem()

Dim oVariancePartsItem As New ChartSeriesItem()

With oTargetItem

.YValue = oItem.Target

End With

With oAchievementItem

.YValue = oItem.TargetAchievement

'.Name = oItem.CICode

End With

With oVarianceAccItem

.YValue = oItem.VarianceAccessories

End With

With oVariancePartsItem

.YValue = oItem.VarianceParts

End With

oTargetSeries.Items.Add(oTargetItem)

oAchievementSeries.Items.Add(oAchievementItem)

oVarianceAccSeries.Items.Add(oVarianceAccItem)

oVariancePartsSeries.Items.Add(oVariancePartsItem)

.Series.Add(oTargetSeries)

.Series.Add(oAchievementSeries)

.Series.Add(oVarianceAccSeries)

.Series.Add(oVariancePartsSeries)

End With

General Discussions

answered on 23 Aug 2011

6 answers

276 views

Silverlight Report Viewer refresh

Hello,

I'm using silverlight report viewer, I need to refresh the report by programming. I'm using RenderBegin and setting the report parameters there.
Any Suggestions on how to call the "Refresh" button on the report viewer by programming?

Thanks

General Discussions

answered on 22 Aug 2011

1 answer

245 views

Telerik reporting out of memory

Hi,

I build a proforma report with telerik and when i run the report in visual studio, the memory goes up to the max pc memory and i get the message "out of memory".
Their is any solution for this problem? or i do somthing wrong.
I attached the print screen of my computer.

Please i need help with this project because we bought this product for the reporting tool.

Tomer.

General Discussions

answered on 22 Aug 2011

5 answers

341 views

Change text color of multi select parameter

My first report with a parameter worked just fine. When I changed the parameter to be multivalue the dropdown box in the parameter area changed to have white text (in the single select case the text is black). Unfortunately, the background has stayed white and so I have white text on a white background.
How do I control the color of the font used in a multi-select dropdown list in the parameter area?

General Discussions

answered on 22 Aug 2011

1 answer

211 views

Format Phone Number generate Blank Pages

Hi everybody,

I'm new with Telerik Reporting and i follow this link http://www.bronsblog.com/post/2011/07/12/Telerik-Reports-Format-a-phone-number.aspx to format a Phone Number field.

The approach is to format the Phone Number field through a function in codebehind and change the field value to FunctionName(Fields.PhoneNumber).

It works great, except that since i changed the field value to FunctionName(Fields.PhoneNumber), the report generates blank pages after each page. If i remove the funciton name from the field value, letting just Fields.PhoneNumber, everything backs to normal.

I'm completely lost. Any iddeas will be appreciated. Even another ways of doing the Phone Number format.

Thanks in advance,

Eduardo

General Discussions

answered on 22 Aug 2011

4 answers

468 views

[Solved] Report / Parameters / Area

Hello Telereilk-Team,

1.
I have a report with parameters and one of this parameter have the UI.Visible property as true.
So if I open the report through the report viewer the report is shown with the parameter area as visible and the image button on the report viewer is marked/selected.

Everything is nice but I want to hide the parametes area as default and if the user click on the image button "Parameters" the parameters area will be shown first.

Is this possible to set as the deault behavior?

2.
Whats about the plans to make the parametes area customizable?
I want to change the ASP:Button to an ASP:LinkButton.
Is this possible, too?

Best wihses
Christian

General Discussions

answered on 19 Aug 2011

2 answers

148 views

Chart x Axis labels are exporting in reverse order to pdf and rtf

Hi,

Chart X axis labels are exported in reverse order to pdf and rtf even though those are displaying properly in report viewer. Please find attached screen shot. All the charts have same problem.

Please help me.

General Discussions

answered on 19 Aug 2011

4 answers

336 views

Create Excel report base on Excel Template - Taking data from an objectdatasource

Hi,

Before asking my company to buy a telerik product, I was wondering if Telerik has a tool allowing to generate an Excel report base on a template file using an ObjectDataSource. Let say we have Template.xls file. I want to be able to export data into some specific cells in the Template.xls file and than save this in a temporay folder with the name ReportYYYYMMDD.xls send the file to the client side for the users to save it in his local machine.

I will need to use something like
- workbook.sheet1.cell(i,j)= xyz;
- workbook.sheet1.cell(i+1,j)= zzz

If it's possible, could you please point me that tool and show a complete code to use?

Thanks

General Discussions

answered on 19 Aug 2011

1 answer

127 views

Error Give when Host in ISS

Hi...

I Have a solution with 4 web site in it (same solution). every web project use reporting. I'm try to host it on IIS 7 . i create site on iis and give path of my first web project. then other web project add as web application to that site in iis. problem is wen I run the site its give me this error in web config files of each projects which i add them as web applications (error screen is attached).

I try to host them separately in IIS then its work. but the problem come when i try to host all to gather as one site.

Can anyone give a help.....

Thanks

General Discussions

answered on 19 Aug 2011