how can i generate reports from my visual basic design?

[ryeolivier]

please help me, i dunno how can i generate reports from my visual basic application. by the way, im using an ms-access database.

 

[elibb]

You can use a datareport, in the menu project. You must spcify the datasource property (it can be a recordset, or an adodc control) and then put the textboxes spcifying the datafiled according to your database.


Eli

 

[ryeolivier]

how can i do this? please help. only these reports are missing in my apps.

 

[elibb]

in the project menu, where you can add a new form to your application, there is an option to add a data report, if its not there you can add it from the components list, once youve add it, you start to design it just like access:

datareport1.datasource="Select * from table1"
datareport1.datamember=""

all you have to do is add textboxes to the report, and specify the datafield.

i hope this helps.

Eli

 

[ryeolivier]

but, how can i pass the parameter value from the main form?
thanks in advance.

 

[elibb]

for example:


datareport1.datasource= "Select * from table1 where id= " & text1.text


Datareport1.DataMember=""
datareport1.show

i hope it helps.

Eli

 

[ryeolivier]

but there is an error prompt that says: runtime error 91:
object variable or with block variable not set.

what can i do.. sorry if i kept on bugging you.

happy new year

 

[elibb]

mmm... are you putting textboxes in the datareport the way you want them? and their datafield property to the field of the database you want??
please send me your code if you can, and ill try to help you

heppy new year

elibb

 

[ryeolivier]

ive created a temporary solution in this problem, that is by
creating reports from crystal reports.. but that doesnt solve the problem, coz i really wanted to integrate my reports into my running apps.