PDA

Click to See Complete Forum and Search --> : More than one datasource=possible?


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