how do you acomplish this? 1

[sixtoedsloth]

hi, this is not so much a coding question as a concepts question

the scenario:-

i am designing a reporting system. the idea is that i will have a treeview holding the reports menu.
when a user clicks a report, it will run a seperate vb program, which gets parameters and runs the report.

the problem with this is of course that each report consumes a sqlserver connection.

however, i dont want to add all the reports as forms in the main program, because then small changes (to reports) require a large executable to be transfered to customer sites (which can be over 56k dial up).

so the questions!

is there a way to share the connection between programs?

is there a convienient way to pass parameters between programs (maybe a dll?)

what are your opinions on how to achieve this?


Regards,

Russ

 

[Bastien]

Are the users connecting to a datasource locally or remotely?

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!

 

[CCLINT]

I assume when you say "Reports" you mean the VB DataReports.

Put your reports in an ActiveX Dll(s).
Open and pass the recordset, which is uses the same connection object in the main exe) to the report (do not use the Data Environment), and set the report's datasource to the recordset object.

 

[sixtoedsloth]

Hmm.

bastien: the datasource will be remote, on a server.

CClint: the reports are actually datadynamics activereports
i wanted to keep the report, and its logic seperate from the menu structure. the problem is i will then need the menu program, the report exe, which asks the questions and generates the recordset and an activexdll which runs the report. or should i pass the sql query and connection details to the activex dll?

Russ