digitalmetaphors
Comments
-
You'll need to create dataviews on the fly- CreateDataModViaCode.zip. Here
is this example along with a couple of dynamic report creation tips. You'll
have to create and ADO query datqaview. Look in daADO.pas for the class
name fo … -
Make sure that the printer driver installed is the latest and working on
that problematic machine. Send me a simple example which doesn't work on
that machine. Send it to support@digital-metaphors.com What printer are
you using? I w… -
A patch is available to fix this.
Cheers,
Jim Bennett
Digital Metaphors
-
You can use edited SQL text in dataviews and link them at runtime. Here is a
simple example of performing the linking after a report is loaded.
http://… -
I'll make feature request for a new EditSQLAsTextLinking boolean property.
I can see this as being useful if any the dataviews have their SQL edited
and then you want to link them. As long as the SQL is ordered in the
details to matc… -
You can add and remove criteria objects on the TdaSQL object. This is how
you can control the generated WHERE clause. If you are adding the SQL text
when you create the dataview, then you must edit the SQL text at runtime.
Set EditSQL… -
Sure, here is an example which lets you modify the TdaSQL object at runtime,
such as search criteria to build the where clause. The reason for
manipulating the TdaSQL object using its methods and properties, other than
setting the SQ… -
You'll have to dynamically create the dataviews. Here is an example of doing
that. Then you can base the dynamic ones off of the ones on the form by
checking the field objects on the dataset and the SQL or table name on the
data acces… -
Use our data dictionary component and set the UseTableOwnerNames property to
false.
Cheers,
Jim Bennett
Digital Metaphors
-
Haven't tried ODBC to test this. The database itself should control the
date format that it expects. The database ocnnectivity should simply pass
through to the database. From MSDN:
SQL Server recognizes date and time data enclosed… -
Is it not working for you? It works for us here when we connect to SQL
Server using ADO and the BDE.
You can change the source to change how the formatting is done, but it does
this because SQL Server expects this format and so… -
TdaSQL is a descendent of TPersistent. You can use Delphi streaming to save
down the object just as we do in our report template. Take a look in
ppTmplat.pas to see where we stream the report objects down to a file or
database. Sta… -
You could create the report entirely on the fly based on the dataset it is
connected to.
http://www.digital-metaphors.com/tips/CreateReportFro… -
We will look into installing MySQL. Last time we tried we couldn't get it
installed, but this was quite some time ago, perhaps their installation
procedure is better than in the past.
Cheers,
Jim Bennett
Di… -
We have not tested this conviguration. We have tested DBExpress with
Interbase. When using MySQL, the key problem you might experience is that
the autoincrement fields on the database table may not come back after a
post. You'll wan… -
We've never installed and tested a MySQL database. Therefore we have not
tested any DADE plugins for this database. If you search the web, there are
components available as a DADE plugin, but again, we've never tested them.
You… -
Please see the previous post with the same question.
Cheers,
Jim Bennett
Digital Metaphors
-
This is a visual way to set the datapipeline's SkipWhenNoRecords property.
When you have multiple details, two in this case, and SkipWhenNoRecords is
set to true, then the master should print when there is at least one record
in eithe… -
There is one additional step. You need to create a descendent of your query
dataview class, such a TdaBDEQueryDataview if you are using the BDE. The
method you need to override is
class function DataDesignerClass: TClass; overr… -
I do ask tough questions. The reason for this is because questions about the
source mean one of two things. 1. You know exactly why you need to know
about undocumented properties in the source, or 2. You haven't examined all
solutions… -
DADE has a lot of internal implementation details to support the many
features in DADE. What are you trying to do?
If you are trying to realias the available tables to the end user, then use
our DataDictionary component.
<… -
We are very excited about a future .NET and ReportBuilder combination.
Hopefully, Delphi will release Delphi for .NET. When this happens, we will
be there to build a version of ReportBuilder that is .NET compatible.
In the mean… -
Send an email to support@digital-metaphors.com We'll reply with it attached.
We modified this DADE plugin late last week in order to support RB 7.
Cheers,
Jim Bennett
Digital Metaphors
-
Works correctly here. I used RB 7, D6.02, and DBISAM 3.17 in this test. I
created a new table with a SmallInt field. Added some data and it all worked
using the datadictionary and the runtime query tools.
I do remember a proble… -
RB 7 has a DBArchiveReader which would make this easy to accomplish.
As a test, try creating a query to get the desired single archive record
instead of relying on the grid to point at the correct record in the
dataset. See if y… -
The problem is that you need to set this criteria value earlier. If you are
loading templates, then use the public Report.Template.OnLoadEnd event to
extract the SQL object and modify the dataview's criteria object's value.
Then you … -
Sounds like a connection problem. Can you connect a TADOQuery ->
TDatasourec -> TDBGrid on the form as a test of the data connectivity?
Cheers,
Jim Bennett
Digital Metaphors
-
See the autosearch demos in the main demo directory for an example of
configuring the end user's autosearch criteria value.
Cheers,
Jim Bennett
Digital Metaphors
-
The DADE plugin is responsible for getting the table names. You'll have to
modify your DADE plugin for SQL Server. I'll assume you are using ADO.
Open up daADO.pas in your RBuilder\Source directory and find the
GetTableNames method.… -
Aren't you in control of the lsCustomerList string variable? Where is that
value coming from? I was thinking something similiar to what is shown below
would work if you made 'Bill,' 'Jones' into 'Bill, Jones'?
{get SQL objec…