Click to See Complete Forum and Search --> : Dsiplay Data directly from a VB form to Report


ronbora
May 2nd, 2004, 10:37 AM
I want to take the data from a TextBox or from a Grid directly to a Report...Such that a VB Form has a TextBox called txtDoctorsName another TextBox called txtAmount...Now if I put some data in both the textbox the data for the Doctor's Name and Amount should be displayed in my Report...I mean to say these two data are not coming from the database...

malleyo
May 3rd, 2004, 06:05 PM
You can use CDO to pass the data to Crystal without a call to a database. CDO is Crystal's version of a recordset.

Basically what you do is populate an array with your data, then stuff the array into the CDO rowset and pass the rowset to Crystal like you would pass a recordset.

See my reply to this post for a detailed explanation (including code):
http://www.codeguru.com/forum/showthread.php?s=&threadid=281658&highlight=cdo

If you need additional help, just reply back to this post...

sabinamaniar
August 1st, 2006, 05:35 AM
hi..

i m sabina..
i have same proble so ,i ask my question by this post thread..

now,

i m using vb 6,CR 9 and M.Access...
As u Suggest us CDO recordset in ur VB

but when i go project->references and in hat no Crystal Data object library..simply i Cant give the reference...

so what can i do...i m so nervous....i m on deadline of my project..

plz give me reply urgent...

if u have any code idea than also send me....

Thanx in Adavance..
God Bless u ..............


Regards,

Sabina Maniar
U.A.E

ShahzadJutt
August 3rd, 2006, 06:43 AM
@Sabina Maniar

“Crystal Report Engine” and “Crystal Data Objects” references to the project

i think "Crystal Report Engine" refernce is installed by CR 8/8.5.
in CR9 there will be "Crystal Query Engine".