Thanks for the reply, but I must not have been clear. For a few reports in my application, I need the DATA SOURCE for the report to point somewhere other than the database location. In code, I generate a temporary database table in the temp directory and wish change the reports data source to the temp directory location instead of using the standard database location. How can I tell the report to utilize the temporary directory for the data source? Thank you.
Yep I completely missunderstood . ReportBuilder is set up to support complete separation between the template data and the report data (i.e. data shown on the actual report). This is just a matter of placing another datapipeline on your form and connecting it to the proper datasource, then being sure that the report is linked to that datapipeline once the template is loaded. Note: This can also be accomplished in DADE as long as the proper DADE plugin is included in your project.
There are examples of using each individual DADE plugin located in the \RBuilder\Demos\4. EndUser Databases\... directory. For instance, if you are connecting to an Access table via ADO, you would place an ADOConnection object on your form and set it up to connect to your database. Then all you would need to do is add "daADO" to your uses clause and when you run your app, in the data tab of the designer you will be able to connect to the ADOConnection using the Data Settings option from the file menu. Now you can create tables using this data as you wish.
Last question...promise! I have done this with DBISAM. Now, is there a way programatically to change what location the query on the "DATA" tab looks for the data (ie: C:\TEMP, F:\DATA...etc)? As always, thank you.
DADE simply communicates with your TDBISAMDatabase object to determin where the tables are located. If you want to change the location where DADE can access these tables, you will need to change the Directory property of the database object on your form.
Comments
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Thanks for the reply, but I must not have been clear. For a few reports in
my application, I need the DATA SOURCE for the report to point somewhere
other than the database location. In code, I generate a temporary database
table in the temp directory and wish change the reports data source to the
temp directory location instead of using the standard database location.
How can I tell the report to utilize the temporary directory for the data
source? Thank you.
Brian Kennedy
RB 7.04
Yep I completely missunderstood
complete separation between the template data and the report data (i.e. data
shown on the actual report). This is just a matter of placing another
datapipeline on your form and connecting it to the proper datasource, then
being sure that the report is linked to that datapipeline once the template
is loaded. Note: This can also be accomplished in DADE as long as the
proper DADE plugin is included in your project.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Thank you. Now we're on the right track. Is there an example of using a
DADE plugin somewhere? I am not familiar with that method. Thank you.
Brian Kennedy
There are examples of using each individual DADE plugin located in the
\RBuilder\Demos\4. EndUser Databases\... directory. For instance, if you
are connecting to an Access table via ADO, you would place an ADOConnection
object on your form and set it up to connect to your database. Then all you
would need to do is add "daADO" to your uses clause and when you run your
app, in the data tab of the designer you will be able to connect to the
ADOConnection using the Data Settings option from the file menu. Now you
can create tables using this data as you wish.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Last question...promise!
way programatically to change what location the query on the "DATA" tab
looks for the data (ie: C:\TEMP, F:\DATA...etc)? As always, thank you.
Brian Kennedy
DADE simply communicates with your TDBISAMDatabase object to determin where
the tables are located. If you want to change the location where DADE can
access these tables, you will need to change the Directory property of the
database object on your form.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com