Codejock Developer Community : Report Control DataSource http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 13 May 2026 16:15:54 +0000 Mon, 01 Aug 2011 15:37:33 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=18700 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Report Control DataSource : I still have an issue, I tried...]]> http://forum.codejock.com/forum_posts.asp?TID=18700&PID=65630&title=report-control-datasource#65630 Author: white6174
Subject: 18700
Posted: 01 August 2011 at 3:37pm

I still have an issue, I tried using the supplied examples,

I'm using VB.net 2010,
the newest demo of the codejock controls,


this is what I have so far, it loads columns but no data  

any ideas?
  Try
            Dim cn As New ADODB.Connection()
            Dim rs As New ADODB.Recordset()
            Dim cnStr As String
            Dim cmd As New ADODB.Command()
            
            cnStr = "Provider=SQLOLEDB;Initial Catalog=DB_Test1;Data Source=DELL_LAP;" & _
   "User ID=SysApp;Password=password;"

            cn.Open(cnStr)
            rs = cn.Execute("SELECT     dbo.ArCustomer.* FROM         dbo.ArCustomer")

            With Me.AxReportControl1
                With .DataManager
                    .DataSource = rs
                    .DataBind()
                End With
            End With

            rs.Close()
            cn.Close()

        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try
]]> Mon, 01 Aug 2011 15:37:33 +0000 http://forum.codejock.com/forum_posts.asp?TID=18700&PID=65630&title=report-control-datasource#65630 <![CDATA[Report Control DataSource : in vb6Set wndReport.DataManager.DataSource...]]> http://forum.codejock.com/forum_posts.asp?TID=18700&PID=65534&title=report-control-datasource#65534 Author: younicke
Subject: 18700
Posted: 28 July 2011 at 12:40am

in vb6

Set wndReport.DataManager.DataSource = rs
wndReport.DataManager.DataBind

where rs is your recordset object

]]> Thu, 28 Jul 2011 00:40:34 +0000 http://forum.codejock.com/forum_posts.asp?TID=18700&PID=65534&title=report-control-datasource#65534 <![CDATA[Report Control DataSource : Hi, Maybe this will help: h...]]> http://forum.codejock.com/forum_posts.asp?TID=18700&PID=65533&title=report-control-datasource#65533 Author: Aaron
Subject: 18700
Posted: 28 July 2011 at 12:14am

Hi,
 
Maybe this will help: http://forum.codejock.com/forum_posts.asp?TID=14721&KW=SQL&PID=50863&title=report-control-databind-for-sql-lite#50863
 
 
 
 
]]> Thu, 28 Jul 2011 00:14:59 +0000 http://forum.codejock.com/forum_posts.asp?TID=18700&PID=65533&title=report-control-datasource#65533 <![CDATA[Report Control DataSource : Maybe I&#039;ll simplify my question,Can...]]> http://forum.codejock.com/forum_posts.asp?TID=18700&PID=65528&title=report-control-datasource#65528 Author: white6174
Subject: 18700
Posted: 27 July 2011 at 2:38pm

Maybe I'll simplify my question,

Can someone show an example of how to use SQL as a datasource for the report control.
(I must be doing it wrong)
]]> Wed, 27 Jul 2011 14:38:28 +0000 http://forum.codejock.com/forum_posts.asp?TID=18700&PID=65528&title=report-control-datasource#65528 <![CDATA[Report Control DataSource : I&#039;m trying something...]]> http://forum.codejock.com/forum_posts.asp?TID=18700&PID=65392&title=report-control-datasource#65392 Author: white6174
Subject: 18700
Posted: 21 July 2011 at 11:25am

I'm trying something that I think should be very simple,
I loaded a SQL table into a strongly typed dataset,
now I want to assign it to the report control,

I tried to do it the same way you would with a datagridview, but it gives me an error

"Specified cast not valid"

Any ideas, I cant seem to find any samples showing how to attach to a SQL data source or datatable.

thanks for any help you may be able to provide 
steve



//code
 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Me.InvMasterTableAdapter.Fill(Me.DataSet1.InvMaster)
        AxReportControl1.DataManager.DataSource = Me.DataSet1.InvMaster
        DGV1.DataSource = Me.DataSet1.InvMaster
    End Sub
]]> Thu, 21 Jul 2011 11:25:52 +0000 http://forum.codejock.com/forum_posts.asp?TID=18700&PID=65392&title=report-control-datasource#65392