Click to See Complete Forum and Search --> : Crystal Report Help
AceFlyer
Jul 7th, 2006, 08:14 PM
Can anyone tell me how to use crystal reports without a database? I need to create a report based on public variables.
I appreciate your help.
Ace
King_George
Jul 10th, 2006, 07:58 AM
Can anyone tell me how to use crystal reports without a database? I need to create a report based on public variables.
I appreciate your help.
Ace
Where are the variables coming from? A VB program?
AceFlyer
Jul 10th, 2006, 11:23 AM
Where are the variables coming from? A VB program?
Yes, the data is coming from a vb6 program through its public variables.
Ace
King_George
Jul 10th, 2006, 12:27 PM
Yes, the data is coming from a vb6 program through its public variables.
Ace
Then in that case the only way I can see it possible is by using parameters on the report. Put the same number of parameters on the report as there are public variables and then assign the values in the VB app before calling the report.
Of course, this will only work if there is only one variable per parameter and a known number of variables.
A better way, but more involved is using a ttx file. You simply create an unconnected recordset, fill it with the variables and then send the recordset to the report via ttx. This will work if there are lots of variables because you can add rows onto the recordset as needed.
HTH
Utpal Mehta
Aug 2nd, 2006, 07:25 AM
You can create the blank report. After that you put the
data_place_holders like say text box. Suppose the name
of the textbox is crTxtBox1. From your VB program, you can
set the value of this text box (NameOfCrystalReport.crTxtBox1.settext "Text
to be set")
Utpal Mehta
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.