ADOration39
Nov 5th, 2004, 04:43 PM
Hello Everybody,
We are having dufficulties printing CReports the we want to, I explain:
I have a big database, wich a lot of data about machines.
The user can select a number of items and a certain time-frame.
These criteria is then used to make a SQL, wich filters a big table.
Problem:
I know how to use this query in Creports, and all this data is printing fine.
BUT:
How can I get the criteria out a form, so that besides the filtered data,
also the criteria is put into the Creports.
(Just like having 2 seperate datasources)
I don't know, if something like this is possible: (?)
-----------------------------------------------------------------------------------------------------
IN FORM:
dim par1 as string
...
...
dimpar12 as string
par1=me.lblCriteriaMachineNumber
...
...
par12=me.lblCriteriaMachineDescription
Passing these parameters into CReports:
frmCRPreview(byval Par1 as string,...........byval Par12 as sting).show
Is something like this possible??????????
HOW>>?????????
Thanks,
Reinier Domsdorf
We are having dufficulties printing CReports the we want to, I explain:
I have a big database, wich a lot of data about machines.
The user can select a number of items and a certain time-frame.
These criteria is then used to make a SQL, wich filters a big table.
Problem:
I know how to use this query in Creports, and all this data is printing fine.
BUT:
How can I get the criteria out a form, so that besides the filtered data,
also the criteria is put into the Creports.
(Just like having 2 seperate datasources)
I don't know, if something like this is possible: (?)
-----------------------------------------------------------------------------------------------------
IN FORM:
dim par1 as string
...
...
dimpar12 as string
par1=me.lblCriteriaMachineNumber
...
...
par12=me.lblCriteriaMachineDescription
Passing these parameters into CReports:
frmCRPreview(byval Par1 as string,...........byval Par12 as sting).show
Is something like this possible??????????
HOW>>?????????
Thanks,
Reinier Domsdorf