Telerik Forums
Reporting Forum
9 answers
374 views
how can I make a report using a sqldatasoure? I have to pass a parameter with the Id I want to use to get the data I need. How can I do that.

thanks
Brandon
Top achievements
Rank 1
 answered on 09 Aug 2011
1 answer
254 views
I'm not sure what's going wrong, but when I set my query programatically, it's not seeing @myParameter is passed into the DataSource.

On the datasource on my designer, I'm making the parameter as a string and hardcoding it for debugging.  But when I my query runs, the @myParameter passed in is blank.

I'm using a binding on the report on the DataSource and send it to:

 

 

public static SqlDataSource ChangeConnectionString(object reportItem, int zoneNo)

 

{


dataSource.SelectCommand = ...the query with my parameter



I set the connection and the query string.  The query string works fine, if I take away the @myParameter.

I have another report where I do the same thing and it's working fine.  Everything looks the same, but one sets the parameter in the query and the other doesn't.  Anything I should do to debug?  It's really hard because I can't put breakpoints in the code behind.
danparker276
Top achievements
Rank 2
 answered on 09 Aug 2011
1 answer
85 views
Hello,
hi have  a pie chart in my repor. I have changed some PlotArea Properties and some chart controlo properties.
All changes  are visible at design time but :

1) if i compile and execute the program  (webForm) i see the starting layout of the pie chart. That is all changes i edited are gone.
2) if i close the solutione and then i re.open it  alle changes are gone too. (i saved before to close)

BTW, in the tool box  i see the list of telerik controls, but it is  repeated several times. Lik e if the controlslist was appended to itsself several times (it seems to be alist for every time i have installed telerik )

My IDE si VS2010 c#

thanks
Peter
Telerik team
 answered on 09 Aug 2011
2 answers
145 views

Hi,

I'm wondering whether nullable types are supported? I'm trying to make a binding using a nullable field and the desinger correclty displays the subcategories "HasValue" and "Value" of the field.
However I'm not able to make a binding against the HasValue instead what I have had to do is use the Is Null on the field itself, likewise I get an error if I try to display Field.Value in a report.

Tomas

Peter
Telerik team
 answered on 09 Aug 2011
3 answers
147 views
on the web form, the parameter holds, but on the reporting library, it does not. what am i dont wrong here?

CampRegistration.vb

   Public Sub New()
        InitializeComponent()

        'Me.ReportParameters("campdateid").Value = 7 'default here

        Me._campdateid = Me.ReportParameters("campdateid").Value

        'Me.TextBox1.Value = Me.ReportParameters("campdateid").Value.ToString


        Me.cdbll.connectionString = bo.Constants.ConnectionString
        Me.rbll.connectionString = bo.Constants.ConnectionString
        
    End Sub

    Private _campdateid As Integer = 0

    Private _contactlist As System.Data.DataTable = Nothing

    Private cdbll As New dal.CampDate()
    Private rbll As New dal.Registration

    Private _registrations As DataTable = Nothing



    

    'Private Sub SubReport1_NeedDataSource(ByVal sender As Object, ByVal e As System.EventArgs) Handles SubReport1.NeedDataSource
    '    Dim subReportItem As Telerik.Reporting.Processing.SubReport = TryCast(sender, Telerik.Reporting.Processing.SubReport)


    '    subReportItem.InnerReport.DataSource = Me._contactlist
    'End Sub

 
    Private Sub CampRegistration_NeedDataSource(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.NeedDataSource

        ' Exit Sub

        '---initial title of report
        Dim cd As acmilan.bo.CampDate = cdbll.getCamp(Me._campdateid)

       

        If cd IsNot Nothing Then
            Me.TextBox1.Value = cd.name & " @ " & cd.city & ", " & cd.state
            Me.TextBox3.Value = cd.start.ToLongDateString & " to " & cd.end.ToLongDateString
        End If
        
        Try

            '---get registrations for campdate
            Me._registrations = Me.rbll.getAllForCampDate(Me._campdateid)
            TryCast(sender, Telerik.Reporting.Processing.Report).DataSource = Me._registrations


             
        Catch ex As Exception
            'Me.TextBox1.Value = ex.StackTrace & ex.Message
        End Try


    End Sub


Report.aspx.vb
  Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not IsPostBack Then
            Dim repReport As New thunder.apps.acmilan.reports.CampRegistration
            Dim cdbll As New bll.CampDate(thunder.framework.dal.sql.DataAccess.rMethod.ObjectList)


            Dim id As Integer = Convert.ToInt32(Request.QueryString("campdateid"))
            Dim cd As bo.CampDate = cdbll.getCampdate(id)

            If cd IsNot Nothing Then
                Me.HyperLink1.NavigateUrl = "campprofile.aspx?campid=" & cd.campid.ToString
                repReport.DocumentName = cd.name & "Camp_Registration_Report_" & id.ToString
                repReport.ReportParameters("campdateid").Value = id

                Me.ReportViewer1.Resources.ProcessingReportMessage = "Generating Camp Registration ID" & repReport.ReportParameters("campdateid").Value.ToString

                Me.ReportViewer1.Report = repReport
                Me.ReportViewer1.DataBind()
                Me.ReportViewer1.RefreshReport()



            Else

            End If

        End If
    End Sub


Steve
Telerik team
 answered on 09 Aug 2011
1 answer
143 views
Hello

Any idea as to when the product road map will be made available?  What are you long term goals for this product.  In particular, when do expect to release a End User report designer,

Thanks,

Dan
Vassil Petev
Telerik team
 answered on 09 Aug 2011
3 answers
141 views
Hi
i need to disable a report parameter at runtime, that depends on another reportparameter.
i've basically need to simulate a selectedindexchanged the aspx for reportparameter with multivalue properties.
is it possible?

thanks in advance
Steve
Telerik team
 answered on 09 Aug 2011
2 answers
157 views
Hi,

I have created a horizontal stacked bar chart programmatically.  I would like to move the actual chart-section to the right because my labels are getting squeezed but I can't seem to figure out how to do this.

Please see the attached jpg.
Roman
Top achievements
Rank 1
 answered on 09 Aug 2011
2 answers
159 views
I'm on VS 2010, windows XP and when I run the upgrade wizard, it only goes to Q1 2011.
I guess I'll do a manual upgrade listed in the docs, but shouldn't the auto-upgrade work?
Steve
Telerik team
 answered on 09 Aug 2011
1 answer
183 views
Hi, 

We have a requirement where you need to export some of the columns displayed in the report. I wanted to confirm whether Telerik has some way to achieve this ? 

For eg : 

Suppose my report displays 3 columns C1,C2,C3. While exporting the data of report I want to have only two columns C1 and C2.

Please let me know if it is possible in Telerik reporting.

Thanks and Regards,
Nikunj 
Steve
Telerik team
 answered on 09 Aug 2011
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?