how to use array of controls in a data report ???

[vishwaskothari]

I am to make a data report in which I am going to display the records dynamically from the database.
No. of record depends on the users input.
How can I do this?
I think an array of controls can serve my purpose.
So how to add an array of controls in a data report ?

[hariharanmca]

I m to make a data report in which i m going to display the records dynamically from the database.
No. of record depends on the users input.
How i can do this.
I think array of controls can serve my purpose.
so how to add array of controls in a data report ??

1. You have to connect dataenvironment to the database.
2. Using command you have to place the fields in detail section on report.
3. No need to create control array.

[vishwaskothari]

1. You have to connect dataenvironment to the database.
2. Using command you have to place the fields in detail section on report.
3. No need to create control array.

Thank You Dear

But I am not using the data environment to generate the report.

So how can I proceed now?

[hariharanmca]

Thank You Dear

But I am not using the data environment to generate the report.

So how can I proceed now?

Can not you explain Detail?

can you creat any Database connection without connection provider?

[vishwaskothari]

Can not you explain Detail?

can you creat any Database connection without connection provider?

Here is the source code that i am using for generating the Report




ConnString = "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=D:\feemg mt_oldver.mdb;" & _
"Persist Security Info=False"
Set con = New ADODB.Connectio n
con.ConnectionS tring = ConnString
con.Open ConnString

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open "SELECT * from accounts where std_id= '" & txtSearchRoll.T ext & "';", con, adOpenStatic, adLockOptimisti c



Do While Not rs.EOF

With repSearchId

Set .DataSource = rs
.DataMember = rs.DataMember
.Sections("Sect ion1").Controls ("lblSno").Capt ion = "'" & sno & "'"
.Sections("Sect ion1").Controls ("lblId").Capti on = "'" & rs(0) & "'"
.Sections("Sect ion1").Controls ("lblname").Cap tion = "'" & rs1(1) & "'"
.Sections("Sect ion1").Controls ("lblDate").Cap tion = "'" & rs(1) & "'"

DoEvents
.Show
sno = sno + 1

End With

rs.MoveNext

Loop

now in this report i want to display the records that are present in the recordsource(rs ),
BUT
this source code is displaying only the first record present in the recordsource(rs ),

now what should i do to display all the records that are present in the recordsouce(rs) .

plz help


TIA

[hariharanmca]

Here is the source code that i am using for generating the Report




ConnString = "Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=D:\feemg mt_oldver.mdb;" & _
"Persist Security Info=False"
Set con = New ADODB.Connectio n
con.ConnectionS tring = ConnString
con.Open ConnString

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open "SELECT * from accounts where std_id= '" & txtSearchRoll.T ext & "';", con, adOpenStatic, adLockOptimisti c



Do While Not rs.EOF

With repSearchId

Set .DataSource = rs
.DataMember = rs.DataMember
.Sections("Sect ion1").Controls ("lblSno").Capt ion = "'" & sno & "'"
.Sections("Sect ion1").Controls ("lblId").Capti on = "'" & rs(0) & "'"
.Sections("Sect ion1").Controls ("lblname").Cap tion = "'" & rs1(1) & "'"
.Sections("Sect ion1").Controls ("lblDate").Cap tion = "'" & rs(1) & "'"

DoEvents
.Show
sno = sno + 1

End With

rs.MoveNext

Loop

now in this report i want to display the records that are present in the recordsource(rs ),
BUT
this source code is displaying only the first record present in the recordsource(rs ),

now what should i do to display all the records that are present in the recordsouce(rs) .

plz help


TIA

My suggestion is, why you are making things more complicated?
Just think if they have 10,000 record and 100 fields, will you place 10,000 X 100 controls in a report?

[vishwaskothari]

My suggestion is, why you are making things more complicated?
Just think if they have 10,000 record and 100 fields, will you place 10,000 X 100 controls in a report?

Thanks Mr. Hariharan,

Here in my case it is gauarnteed that no. of records will not be more than 10.

Anyway plz tell me the appropriate way of doing this.
and also plz tell how i can do this using data environment.


Is it possible or not to insert control array on a data report?

TIA

[QVeen72]

Hi,

U may not need control array. Add A Data Environment, A Connection Object, Link to the Database, Add a Command object to Conn Obj, Now change the Command Text to SQL and give " Select * From MyTable:

No Add a Data Report to ur proj, And Place the Fields of Command Object in ur Data Report. In Run Time, Just Change the SQL Query of Command Object according to ur selection and Show teh DataRpeort..

REgards
Veena

[hariharanmca]

Thanks Mr. Hariharan,

Here in my case it is gauarnteed that no. of records will not be more than 10.

Anyway plz tell me the appropriate way of doing this.
and also plz tell how i can do this using data environment.


Is it possible or not to insert control array on a data report?

TIA

Yes we can creat Control Array but, it is not the correct way to do.

1. Add data Environment in Components (OCX Reference) and in Designers TAB
2. Then Right click in your project explorer.
3. You Get ADD > Data Environment (Click and Add Data environment to you project).


In Data Environment
------------------------------
4. in Connection Right click and choose properties in dropdown menu.
5. Select your Connection provider MS Jet 4.0 OLEDB
6. Click Next and choos your Database in file dialog box
7. Click test connection. If success then your connection is over.


Is Your Back-end is MS Access?

[vishwaskothari]

Hi,

U may not need control array. Add A Data Environment, A Connection Object, Link to the Database, Add a Command object to Conn Obj, Now change the Command Text to SQL and give " Select * From MyTable:

No Add a Data Report to ur proj, And Place the Fields of Command Object in ur Data Report. In Run Time, Just Change the SQL Query of Command Object according to ur selection and Show teh DataRpeort..

REgards
Veena

Thanks Veena

plz tell me how to place the fields of command object in Data Report, and
how to change the SQL query of command object at run time