Hi,

i need to run the following query in order to be able to create a dataset and bind it to my parameter which
is supposed to be a drop down.

what i am trying to do is creating a temp table to create a dataset for Month and Year drop downs

my problem is that , the query builder does not support 'Declare' so i am basically not able to use my query.

What can i do to create a drop down param and bind it to a dataset which is not actually running on an existin table in my database.

Thanks very much
Zahra

 

declare

 

@months table(

 

 

 

 

monthName

varchar (50),

 

 

 

 

monthValue

int)

 

 

 

 

insert

 

into @months(monthName,monthValue)

 

 

 

 

select

 

'January',1 union

 

select

 

'Feburay',2 union

 

select

 

'March',3 union

 

select

 

'April',4 union

 

select

 

'May',5 union

 

select

 

'June',6 union

 

select

 

'July',7 union

 

select

 

'August',8 union

 

select

 

'September',9 union

 

select

 

'October',10 union

 

select

 

'November',11 union

 

select

 

'December',12

 

 

 

 

select

 

monthName, monthValue from @months order by monthvalue asc

 

hi,

is it safe to use my sql query command when i am using the telerik reporting wizard?
as far as i know, using stored procedures is much safer but then i won't be able to use the telerik reporting wizard.
what do you recommend?

Thanks,
Zahra

I'm using the DocumentName to set the default file name for exporting to PDF, but I can't seem to find a way to set the default export folder.  I've tried the code below, but no luck.  Any suggestions?

Does anyone have a link to a sample or know how to print striaght to PDF without opening the report in the report viewer?

R

hi,

please help me to change the color of this part of chart!

http://h.imagehost.org/0419/changecolor.jpg

Hello..

I have a charts created by code,  i need to export that to Excel and Print,


#Region " _RI_ "

    Private Function Generar_Item_RI( _
                                        ByVal RepInt As Winsoftware.RepresentateInterno, _
                                        ByVal Fecha As String, _
                                        ByVal TipoFecha As Winsoftware.Histograma.TipoFecha _
                                     ) As Telerik.Reporting.Charting.ChartSeriesItem

        Dim Porcentaje_SS As Decimal = 0
        Dim Porcentaje_OT As Decimal = 0
        Dim Porcentaje_Total As Decimal = 0

        Dim sItem As Telerik.Reporting.Charting.ChartSeriesItem
        sItem = New Telerik.Reporting.Charting.ChartSeriesItem

        Dim ListaDias As List(Of Winsoftware.Series)
        ListaDias = Session("ListaDias")

        'DATOS DE SOLICITUD DE SERVICIO
        _DataTable = Winsoftware.Histograma.HgRiSerieObtener_SS(RepInt.RV, Fecha)
        'Winsoftware.Histograma.Alternativa_ss(_DataTable, ListaDias)

        If TipoFecha = Winsoftware.Histograma.TipoFecha.Anterior Then
            ListaDias = Winsoftware.Histograma.valor_serie_dias_anteriores_ss(_DataTable, ListaDias)
        ElseIf TipoFecha = Winsoftware.Histograma.TipoFecha.Actual Then
            ListaDias = Winsoftware.Histograma.valor_serie_dia_actual_ss(_DataTable, ListaDias)
        ElseIf TipoFecha = Winsoftware.Histograma.TipoFecha.Despues Then
            sItem.Appearance.FillStyle.MainColor = Color.DarkBlue
            ListaDias = Winsoftware.Histograma.valor_serie_dias_despues_ss(_DataTable, ListaDias)
        End If

        'DATOS DE ORDENES DE TRABAJO
        _DataTable = Winsoftware.Histograma.HgRiSerieObtener_OT(RepInt.RV, Fecha)
        If TipoFecha = Winsoftware.Histograma.TipoFecha.Anterior Then
            Porcentaje_OT = Winsoftware.Histograma.valor_serie_dias_anteriores_ot(_DataTable)
        ElseIf TipoFecha = Winsoftware.Histograma.TipoFecha.Actual Then
            sItem.Appearance.FillStyle.MainColor = Color.DarkBlue
            Porcentaje_OT = Winsoftware.Histograma.valor_serie_dia_actual_ot(_DataTable)
        ElseIf TipoFecha = Winsoftware.Histograma.TipoFecha.Despues Then
            sItem.Appearance.FillStyle.MainColor = Color.DarkBlue
            Porcentaje_OT = Winsoftware.Histograma.valor_serie_dias_despues_ot(_DataTable)
        End If

        For m As Integer = 0 To ListaDias.Count - 1

            If Format(ListaDias(m).Fecha, "dd/MM/yyyy") = Fecha Then

                Porcentaje_SS = ListaDias(m).Porcetaje
                Porcentaje_Total = Porcentaje_SS + Porcentaje_OT
                sItem.Label.TextBlock.Text = Format(Porcentaje_Total, "0.00").ToString & "%"
                sItem.YValue = Porcentaje_Total
                sItem.ActiveRegion.Url = "javascript:ShowPopUpDialog('DetalleRI.aspx?Fecha=" & Fecha & "&RespintID=" & RepInt.RV & "');" ' MOSTRAR DETALLE
                If sItem.YValue > 100 Then
                    sItem.Appearance.FillStyle.MainColor = Color.Red
                ElseIf (sItem.YValue >= 80) And (sItem.YValue <= 100) Then
                    sItem.Appearance.FillStyle.MainColor = Color.Yellow
                End If

                m = ListaDias.Count + 1
            End If

        Next

        Return sItem
    End Function

    Private Function GenerarSeries_RI(ByVal RepInt As Winsoftware.RepresentateInterno, ByVal RadChart As Telerik.Reporting.Chart, ByVal FechaInicio As DateTime, ByVal FechaFin As DateTime) As Telerik.Reporting.Charting.ChartSeries

        Dim chartSeries As New Telerik.Reporting.Charting.ChartSeries()
        Dim Serie As New Winsoftware.Series
        Dim Fecha As String
        chartSeries.Name = "RESPONSABLE"
        chartSeries.Type = Telerik.Reporting.Charting.ChartSeriesType.Bar

        Dim Diff As Integer = DateDiff(DateInterval.Day, FechaInicio, FechaFin)
        Dim sItem As Telerik.Reporting.Charting.ChartSeriesItem

        Dim ListaDias As List(Of Winsoftware.Series)
        ListaDias = Session("ListaDias")


        For i As Integer = 0 To ListaDias.Count - 1
            Serie = ListaDias(i)
            Fecha = Format(Serie.Fecha, "dd/MM/yyyy")

            ''RadChart.PlotArea.XAxis.AddItem(Format(Fecha, "yyyy/MM/dd"))
            RadChart.PlotArea.XAxis.AddItem(Fecha)

            sItem = Generar_Item_RI(RepInt, Fecha, Winsoftware.Histograma.Definit_tipo_Fecha(Serie.Fecha))
            chartSeries.AddItem(sItem)
        Next

        Return chartSeries
    End Function

    Private Sub GenerarGafica_RI(ByVal RepInt As Winsoftware.RepresentateInterno, ByVal FechaInicio As DateTime, ByVal FechaFin As DateTime, Optional ByVal index As Integer = 0)

        Dim radChart As New Telerik.Reporting.Chart
        'Dim radChart As New RadChart

        radChart.ChartTitle.TextBlock.Text = RepInt.NomRV

        Dim ControlID As String = "RadChart_RI_" & index
        radChart.PlotArea.YAxis.AutoScale = False
        radChart.PlotArea.YAxis.AddRange(0, 200, 10)

        'Color de fondo
        'verda
        Dim zone As New Telerik.Reporting.Charting.ChartMarkedZone
        zone.ValueStartY = 99
        zone.ValueEndY = 101
        zone.Appearance.FillStyle.MainColor = Color.Black
        radChart.PlotArea.MarkedZones.Add(zone)

        'GERENA LOS RANGOS PARA EL EJE Y (LOS PORCENTAJES)
        For j As Integer = 0 To 20
            radChart.PlotArea.YAxis(j).TextBlock.Text = CStr((j * 10)) & "%"
        Next

        'FORMATO PARA EL EJE X
        radChart.PlotArea.XAxis.Clear()
        radChart.PlotArea.XAxis.AutoScale = False
        radChart.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = 300
        radChart.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Color = System.Drawing.Color.Black

        ' CREA LAS SERIES
        Dim chartSeries As New Telerik.Reporting.Charting.ChartSeries()

        Dim ListaDias As List(Of Winsoftware.Series)
        ListaDias = Winsoftware.Series.ListaDias(FechaInicio, FechaFin)
        Session("ListaDias") = ListaDias

        chartSeries = GenerarSeries_RI(RepInt, radChart, FechaInicio, FechaFin)
        ' LIMPIA LAS SERIES QUE HALLA EN LA GRÁFICA
        radChart.Series.Clear()

        ' AGREGA LAS SERIES A LA GRÁFICA
        radChart.Series.Add(chartSeries)


        'radChart.Width = 1010
        'radChart.Height = 600
        'radChart.Skin = "Mac"
        radChart.Name = ControlID
        'radChart.Save("C:\tmp\20080604-ojmc.jpg")

        'ReportViewer1.dat()
        'ReportBookControl1.Reports.Add(radChart)
        'Controls.Add(radChart)
        'Me.Page.Controls.Add(radChart)
        'Dim rep As Telerik.ReportViewer.WebForms.ReportInfo

        'ReportBookControl1.Reports.Add(rep)
        'ReportViewer1.DataBind()




    End Sub

#End Region

Hi,

I placed word content in htmlTextBox. It is showing #ERROR# 'w' is an undeclared namespace line 1 position 1219. Please help me.



Regards,

B.Sridhar

 Hi,
   I am new to telerik reporting.
   I went through the wizard and I get data in my report. But when I try to use a parm I get
"An error has occured while processing TextBox 'eqMemberNoDataTextBox 1':
Index was out of range. Must be non-negative and less than the size of the collection."

Now I dont know if I missed a step or need a step.
Here is where I call my report ...

Here is my iqEquipment_Summary.cs Report


Here is my XSD designer.cs

I guess something is not where it is suppose to be. In other words, there is something I didnt do.

I have this last part already posted out there, but just as an aside for this post .....
As another clue that I must be doing something wrong is because when I add a parm. I get a message about missing a Fill method with 1 parameter. It seems like adding the parm caused the wizard to take the existing Fill method with 1 parm, and just added a parm to that, instead of creating a copy of the 1 parm fill method and adding the new parm this copy of the Fill methoid. 

thanks for any help.  

How can i add a chart previously created in winforms like a print screen for example... with picturebox ?

 

I am currently using Telerik in WSS3.0. I have a main report with 3 sub reports in which the main report will pass the parameters to the sub reports to do the filtering on the respective sub reports.

I have tried testing using the administrator and everything works fine. The problem comes when I test it using a non administrator. The main report is fine but all the sub reports have error 'An error has occured while processing.....'.

Please advise as I have no idea on where to look for in this issue and I need to fix this urgently. Since administrator have no problem with the report.
I am using the version 2.9.8.1209