data report in vb

[ishikha]

hi friends,

i am having one problem in data report.
i want to show the data of two tables in one data report .how can i do it.
the two tables are having no relation.
i am using data environment as a data source and doing coding through adodb

my two tables are having fields:

first table "software"
cdno,name,date,recdate

second table "computer
machineno,name,date,recdate

now i want the query
select cdno,name,date from software where recdate is NULL

similar query on second table

and want to show the result of both query in one data report

i am using datareport in vb6

can u help me

regards
ishikha

 

[chadt]

Use Crystal Reports instead of the data reports designer in VB. Even in VB.NET Crystal is the prefered way...even according to MS.
Chad

 

[CasperTFG]

p.s. Crystal reports is also free. You ahve to do some searching but somewhere hidden on those Visual Studio CD's is a folder where you can run an EXE to install Crystal reports. The one it installs is 3 years old, but it's still miles ahead of datareport. Craig, mailto:sander@cogeco.ca

"Procrastination is the art of keeping up with yesterday."

I hope my post was helpful!!!