Questions on Reporting Forum

3 answers

54 views

Upgraded to 5.1 and Some Reports Fail on Reload

Hi,

I recently upgraded our reporting tool from Q1 2010 to Q2 2011, and some reports work fine, but others generate an error when re-run. The first time they are run, they work correctly. They also work consistently from testing within the report assembly / dll. I'm using the following:

VS.NET 2010 / ASP & VB.NET
SQL Server (2005)
Telerik Reporting 5.1 (5.1.11.713)
Telerik RadControls 11.2.712.0

I've tried everything I can think of, and I haven't figured out what the difference is with the reports that are failing, except they are all in the same assembly.

Thanks in advance,
Ed N.

General Discussions

answered on 24 Aug 2011

0 answers

86 views

Stylesheet property missing

Hello,

I've just installed the latest (5.1 trial) version of the Telerik Reporting tool and am facing a problem. I can't find the stylesheet property in the properties window. All I can see are Style and StyleName.

Has this something to do with the trial version or has it been changed lately...

Best regards,
Ivan

edit:found out what the problem was... I haven't selected the whole report but rather just one single element...that's why I didn't get the stylesheet option...

General Discussions

asked on 23 Aug 2011

3 answers

120 views

Report table datasource challenge

I have created a RadGridView in my application to use as an employee attendance calendar. The datasource is a SQL Server table with 1 column for the name of the month and 31 columns for the days of the month. In the database only the MonthName column has data in it; one record for each month. The columns for the days of the month are empty in the database. Basically this is just a template.

The day-of-the-month columns in the RadGridView are populated using a SQLDataReader. Like this;

Private Sub FillCalendar()

Dim newFont = New Font("Calibri", 7.0F, FontStyle.Bold)

Dim EE As Integer

Dim vbYear As Integer

Dim Incident As String

Dim ColIndex As Integer 'Day of the month, also the name of the column

Dim RowIndex As Integer ' Month of the year, also row index + 1

EE = CInt(RadTextBoxElement10.Text) ' Employee id #

vbYear = CInt(RadDropDownListElement1.SelectedIndex + 2007) 'Year for calendar

'connection string and mysqlconnect

Dim connstring As String = ("Data Source=MyServer\SQLINSTANCE;Initial Catalog=DATABASENAME;Persist Security Info=True;User ID=MYUSER;Password=MYPASS")

Dim conn As New SqlConnection(connstring)

Dim selectSQL As String

'create selection query

selectSQL = ("Select aDay, aMonth, Incidents From View_AttCombined Where (GPID like '" & EE & "') and (aYear like '" & vbYear & "')")

'create selection command

Dim cmd As New SqlCommand(selectSQL, conn)

'set cmd property

cmd.CommandType = CommandType.Text

'open database

conn.Open()

'create and execute the reader

Dim myreader As SqlDataReader = cmd.ExecuteReader

While myreader.Read

ColIndex = myreader.GetInt32(0)

RowIndex = myreader.GetInt32(1) - 1

Incident = myreader.GetString(2)

Me.RadGridView1.Rows(RowIndex).IsCurrent = True

Me.RadGridView1.Columns(ColIndex).IsCurrent = True

Me.RadGridView1.CurrentCell.Value = Incident

If Len(Me.RadGridView1.CurrentCell.Value) > 3 Then

Me.RadGridView1.CurrentCell.Font = newFont

Else

End If

End While

conn.Close()

Me.AttendanceTableAdapter.Fill(Me.AttendanceDataSet.Attendance, CInt(RadTextBoxElement10.Text), CInt(RadDropDownListElement1.SelectedIndex + 2007))

Me.AttCalCommentsTableAdapter.Fill(Me.CalCommentDataSet.AttCalComments, CInt(RadTextBoxElement10.Text), CInt(RadDropDownListElement1.SelectedIndex + 2007))

Me.RadGridView1.CurrentRow = Me.RadGridView1.Rows(0)

Me.RadGridView1.CurrentColumn = Me.RadGridView1.Columns(1)

End Sub

Is it possible to use a similar approach to populate the Cells/TextBox's in a report table?
If not, is it possible to use a RadGridView as the datasource for a report table?

I am open to other suggestions.

General Discussions

answered on 23 Aug 2011

2 answers

82 views

RadAjaxLoadingPanel with Telerik Report to PDF

Is there any way to get the RadAjaxLoadingPanel to work with a Telerik report that is output as a PDF file? The report takes a long time to generate so I'd like to show a loading screen or have some way to indicate that the pdf file is generating. If I try to use the RadAjaxLoadingPanel, I'm getting a Sys.WebForms.PageRequestManagerParserErrorException because the code to programatically create a PDF from a Telerik report uses Response.BinaryWrite.

So is there any way to either...

show progress when a pdf file is being programmatically created from a Telerik report

OR

create a pdf file programmatically created from a Telerik report without using Response.BinaryWrite (in which case I could use the RadAjaxLoadingPanel to show progress)

General Discussions

answered on 23 Aug 2011

1 answer

113 views

ReportViewer problem with Form authentication

The report viewer works fine on the test site that doesn't use any kind of authentication. once i add form authentication the report viewer stops functioning properly.
From the following thread I understand that form authentication interferes with the report viewer http handler streaming.
I tried adding the <location> solution mentioned on that thread to no avail.

How can overcome this issue, and prevent the form authentication from interfering with the report viewer?

Thank you,
Ghayth

General Discussions

answered on 23 Aug 2011

3 answers

108 views

Specifying PreDefined printer for a specific report

Hi,
I am evaluting the teleric reporting control for a browser based application - where large # of reports are involved. There would be few specific reports which might need the custom paper size and to be printed on specific printer. Custom paper size is possible to set in report designer as well as during run time. Now I am wondering - whether a specific printer name be set during run time - so that user does not have to select it when ever he prints the report.

Thanks
Ketan Patel

General Discussions

answered on 23 Aug 2011

3 answers

247 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

81 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

241 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

207 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