Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_vb thread: Report Designer


Message #1 by John Walborn <JWalborn@m...> on Mon, 9 Apr 2001 09:56:30 -0600
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0C279.C611CAA0
Content-Type: text/plain

Here is an example of how to use a Data Report without the Data Environment.
"DataReport1" must already exist in the project.
  
	Dim rs As ADODB.Recordset
      Dim dr As DataReport1
	Dim i as Integer

    (...code to fill recordset here...)
	
    Set dr = New DataReport1
    Set dr.DataSource = rs
    
    With dr
    	(you can do stuff with elements on the data report)
    	With .Sections("PageHeader")
        	For i = 0 To .Controls.Count
            	.Controls(i).Visible = true
        	Next
    	End With
    	(assume your recordset has the same number of fields as the number
of textboxes on the report)
      (the report textboxes do not have an index property, I do not believe
it is possible to create them)
      (dynamically by adding to an array)
    	With .Sections("Details")
        	For i = 0 To .Controls.Count
            	.Controls(i).DataField = rs.Fields(i).Name    
        	Next
    	End With
    .Show
    End With

P.S.  Does anyone know how I can prevent all of the HTML brackets and other
junk from being attached to my emails to this discussion list?  I use
Outlook; I've set my Format to "Plain Text", and Encoding to "US ASCII"

Tom Regan
senior application developer

pmh caramanning inc.
34705 W. 12 Mile Rd.
Farmington Hills, MI 48331-3261
xxx-xxx-xxxx
fax:  xxx-xxx-xxxx
email: tregan@p... <mailto:tregan@p...> 
www.pmh.com

-----Original Message-----
From: professional vb digest [mailto:pro_vb@p...]
Sent: Tuesday, April 10, 2001 7:02 PM
To: pro_vb digest recipients
Subject: pro_vb digest: April 10, 2001


Subject: Re: Report Designer
From: shahid713@y...
Date: Tue, 10 Apr 2001 06:09:43
X-Message-Number: 1

Hi John!

I was also in search of binding report without the data environment but in 
vain. But now i leaned much about DE. It is not a very hard job. If you 
wish to learn more mail me.
I will reply you.

SHAHID

Rana713@y...
----------------------------------------------------------------------


  Return to Index