Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 23-04-2009
Member
 
Join Date: Mar 2009
Location: Ghana
Posts: 15
Please I will like to create a data report in vb 6.0

I am developing an application in vb 6.0 and i would like to create a report with Data report but i don't want the paper size to be the A4 size as it is. Please can I get help on this.
Reply With Quote
  #2  
Old 23-04-2009
Member
 
Join Date: Aug 2007
Posts: 1,098
Re: Please I will like to create a data report in vb 6.0

try here hope you will get some help http://support.microsoft.com/default...96&Product=vbb
Reply With Quote
  #3  
Old 23-04-2009
Member
 
Join Date: Oct 2005
Posts: 2,389
Re: Please I will like to create a data report in vb 6.0

Please go through the attachment having some codes that changes the paper size to any way you want.
Reply With Quote
  #4  
Old 23-04-2009
Member
 
Join Date: Apr 2008
Posts: 2,001
Re: Please I will like to create a data report in vb 6.0

Data report to be used with dataenvironment. First set the command property of dataenvironment property to esql

dim esql as string, god as string, good as string,Date1 as string
god=chr(39)
good=chr(35)
Date1 = Format(#10/3/2000#, "MM-DD-yy") ' you need to match formats
'or Date1=Format(TxtDate,"MM-DD-YY")

esql="select Trader,Broker from tblOrders where trader=" & god & txtTrader & god & " And Trading_Date=" & good & Date1 & good

set the datareports's datasource to dataenvironment at design time , not runtime.
Reply With Quote
  #5  
Old 23-04-2009
Member
 
Join Date: Apr 2008
Posts: 1,948
Re: Please I will like to create a data report in vb 6.0

Go to Project and choose More ActiveX Designers. Now choose Data Environment. Once opened - right click on Connection1 and choose Properties. Choose Microsoft Jet 4.0 OLE DB. Now, click the button to the right where you see 1. Select or enter a database name. Go to the location where you'd saved your database and double click. Check or Test your connection. If everything is on track you'll see a messagebox with the message "Test Connection Succeeded". Click OK. Right click on connection again but this time choose Add Command. Now right click on Command1 and click Properties. Set the DatabaseObject to Table and then set the ObjectName to Customers. Click Apply and then click OK.
Reply With Quote
  #6  
Old 19-08-2009
greenblue
 
Posts: n/a
Re: Please I will like to create a data report in vb 6.0

You can use RAQ Report. RAQ Report is a free reporting tool. Design interface of RAQ Report is similar to EXCEL as shown below:


Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags:



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Please I will like to create a data report in vb 6.0"
Thread Thread Starter Forum Replies Last Post
Which is best, Data report or Crystal report? Smita.bendal Software Development 5 11-03-2010 02:42 AM
How to create reports using Crystal Report 10? Chandraa Windows Software 4 07-01-2010 08:14 PM
The wizard is unable to create your report Jerin m Windows Software 3 02-09-2009 07:47 PM
Create Crystal Report from Excel Harshini Software Development 3 04-05-2009 02:09 PM
How to create a Pivot Table report Computer_Freak Tips & Tweaks 1 14-03-2009 06:53 PM


All times are GMT +5.5. The time now is 04:34 PM.