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
Printable View
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?Quote:
Originally Posted by AceFlyer
Quote:
Originally Posted by King_George
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.Quote:
Originally Posted by AceFlyer
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
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