nardmoseley
Comments
-
This example shows how to programmatically create the datapipline links.
Note that the datapipeline traversal logic requires the detail data to be
sorted on the linking fields.
in Set Search Criteria Comment by nardmoseley April 2004 -
This is not a known issue nor can I reproduce it here. Please provide
specific steps to reproduce the error or create a simple example project
using standard Delphi components, ReportBuilder, and DBDemos. Email in zip
format to … -
1. Create a main report and remove the header/footer so that the layout
contains only a detail band..
2. Connect the report to the DBPipeline.
3. Add 4 subreports and set each to PrintBehavior of pbSection.
The text object in ReportBuilder such as TppLabel and TppDBText use the
Delphi TFont object which contains Font.Name and Font.Charset properties
that determine the font. Try creating a new form, add a TppReport and then
use the …
I think you need set DataDictionary.UseTableOwnerName to true. Then
repopulate the DataDictionary. If you use the DataDictionary Builder, it
will generate the entries in the format OwnerName.TableName.
The best approach fo…
We need a Delphi project that contains an example report that demonstrates
what you are trying to accomplish. Include any comments/notes that explains
the issue. Include an tables needed to run the example. (Or use DBDemos or
th…
Please create a simple example using paradox or Access tables and send in
.zip format to support@digital-metaphors.com.
--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com
For the other queries that require the same search value, define search
criteria but do not designate them as autosearch. You can programmatically
assign the autosearch value entered by the user to the additional queries.
…
Based upon your description I think you need to remove the Day field from
the master query. Link the detail to the master based upon the IdUser and
add the search criteria on Day to the detail query.
--
Nard Mo…
From the Data tab, use the Preview button on the DataView tool widnows to
preview the master data.The master dataset should be sorted on the IDUser
field first, then the group should not break until the IDUser field changes
The ReportBuilder Query tools do not support accessing data across multiple
database for a single report.
You need to create one or more Custom DataViews (see
RBuilder\Demos\EndUser\Custom DataViews) or use external datase…
Use the Data workspace to link the detail to the master on the linking
field.
You cannot filter the detail while the report is executing. DADE uses RB's
DataPipeline linking which works by firing the detail query only a si…
Here is an example of applying autosearch values to additional SQL search
criteria values....
http://www.digital-metaphors.com/tips/…
When a query is not linked to a master, the SQL text that you can preview
via the DataView tool windows preview SQL option.
If a Query is linked to a master then special linking SQL is generated. See
the following article …
When you use the Query tools do you have the app configured to use the
DataDictionary? If so then the Query tools use the DataDictionary to
generate the field aliases. The DataDictionary will not be used if you
assign SQL text.<…
Try the exact code that I posted in my prior response. Do not add any
additional code. Notice that I do not set EditSQLAsText to true. (This will
occur automatically. ) I also do not call out of sync.
--
…
I researched this and the TdaSQL object requires that you assign a TStrings
object to the SQLText property. Try soemthing like this....
var
lSQLText: TStringList;
lSQLText := TStringList.Create;
…
Try calling TdaQueryDataView.OutOfSync after setting the EditSQLAsText
property.
--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com
If you are using the BDE, try increasing the settings for MaxBlobSize and
BlobsToCache.
The Report.DeviceType property is saved down with the reports. As a test you
can try saving a report definition to an .rtm file then l…
You could create a custom printer dialog and register it with ReportBuilder
to replace the default printer dialog. You could use the existing
TppPrintDialog as a starting point (see RBuilder\Source\ppPDlg.pas). Save
the unit dow…please send a request to support@digital-metaphors.com
--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com
There is patch available for the RB 7.03 that corrects some issues that may
be causing this error. If you are using RB 7.03, please send a request to
support@digital-metaphors.com .
--
Nard Moseley
Digital Metap…
We do not have any examples of implementing "AutoSort" type of
functionality.
I think the approach would be to register a custom AutoSearch dialog that
contains the sort options. I am not sure where you would store the sor…
Same question as you posted above, same answer from me.
--
Nard Moseley
Digital Metaphors Corp…
Okay, I am understanding better now.
AutoSearch is not going to work for that scenario.
As an …
The AutoSearch feature supports ask at runtime. Although it is most often
used for query parameters, it can be used for any type of ask at runtime
parameter. See RBuilder\Demos\AutoSearch for examples.
--
Nard Mosele…
We can add it the list of requested enhancements so that it will considered
for the next release.
--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com
I tried to create a similar query. Looks like once you link the same table
in twice to first the master, then link dialog lists the same table name
twice rather than listing the table SQL alias.
I think you will have to ma…
I think you are encountering the limitations of the query builder.
Are you trying to link queries or build one query with SQL joins?
--
Nard Moseley
Digital Metaphors Corporation
ww…
There are a number of the TppDesigner.DataSettings properties that are
applied to the TdaSQL object when it is created. I think you need to assign
more of these properties:
For examlple:
TdaSQL.DatabaseName = …