nardmoseley
Comments
-
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 = … -
The option in the Link dialog box refers to the SkipWhenNoRecords property
of the detail datapipeline. It controls how the datapipeline traverses data.
It does not affect the SQL that is generated.
The Linking SQL that is … -
See my response to the original post.
--
Nard Moseley
Digital Metaphors Corporation
www.digit… -
The top 1/3 can be handled by a group header.
For the middle and bottom 1/3's try using a subreport for each 1/3. Set
subreport PrintBehavior to pbFixed and set the subreport's Height to define
the page area in which the d… -
Okay, so now you are switching over to EndUser newsgroup from RAP.
Sorry, I have not had time to research thi… -
The ReportBuilder newsgroups are provided for the Delphi developers that
have either purchased a license to ReportBuilder or are evaluating
ReportBuilder for a potential purchase.
Please understand that Digital Metaphors r… -
Simplest solution is to place the ADOConnection object on the same
form/datamodule that contains the TppDesigner. When you specify ADOSession
for the Designer.SessionType the drop down list for DatabaseName will list
the ADOConn… -
Please do not post attachments to the newsgroups.
Please create a simple, minimal example that demonstrates what you are
trying to accomplish. The example should be a Delphi project that we can
compile and run here. Please… -
1. There are some articles in the Tech Tips newsgroup on creating reports in
code and on working with templates.
In general you want to make that all objects are Owned by the form or
datamodule that contains the report. Th… -
In ReportBuilder you use the PrinterSetup properties to specify the Page
size, Margins, Orientation, etc. These settings are applied to the printer
when you print the report.
(As a test, I created an A4 document in Word. T… -
Try using the Designer.NoteBook.SelectNextPage method. Calling this method
will fire the page change events, which the Designer uses internally.
--
Nard Moseley
Digital Metaphors Corporation
www.digital-me… -
We do not have any examples other than the ones that Nico posted. I think
the best approach to learn how those example work by tracing the
ReportBuilder source code in the Delph debugger.
--
Nard Moseley
Digital… -
The ReportDesigner works with DataPipelines. The Report and Data-aware
components can be connected to DataPipelines. DataPipelines include
DBPipeline, TextPipeline, and JITPipeline. The architecture is open,
enabling custom Data… -
You must have a very old version of the Developers Guide. I looked thru the
second and third editions and could find no reference to that code.
--
Nard Moseley
Digital Metaphors Corporation
www.digit… -
Try checking out the code in daDataDictionaryBuilder.pas.
I checked the Developers Guide for ReportBuilder 7 but could not find the
text that you are quoting. Is that text located in a tutorial?
--
Nard M… -
To display the datadictionary builder at runtime, download the following
example:
www.digital-metaphors.com/tips/DataDictionaryBuilderAtRunTime.zip
--
Nard Moseley
Digital Metaphors Corporation
… -
1. The DataDictionary and DataDictionaryBuilder can be used with Firebird or
Interbase.
2. The DataDictionary is only used by the Query Wizard and Query Designer
when you create queries from the Report Designer's Data work… -
One option is to use Delphi code and use the Report.Template.OnLoadEnd event
to extract the TdaSQL object from the dataview and modify the SQL.
www.digital-metaphors.com/tips/ExtractSQLObject.zip
Most of the RAP even… -
The following example shows how to extract the TdaSQL object from a
DataView. The TdaSQL object contains the description of the SQL.
www.digital-metaphors.com/tips/ExtractSQLObject.zip
--
Nard Moseley
Sorry, but the current internal architecture of the report designer does not
support placing the designer on a tab sheet.
--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com
…
Thanks for the feedback.
No immediate plans to implement a basic like syntax, but that would be a
great enhancement.
1. Learning ReportBuilder is a tutorial system designed for end-users. (see
article below) .
2. You may use materials from the Developers Guide and RBuilder.hlp as well.
Please include a copy right. You can contact info@d…
Here is a simple example that I constructed...
www.digital-metaphors.com/tips/EndUserDefaultFielDir.zip
--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com
If you update to RB 7.03 you can specify a SQL statement as a search value.
Thus you can add a search condition on MemberID and use the Not InList
operator. For the search value you can specify (Select MemberID from
Member…
Try using AutoSearField.SearchExpression. That propery contains the date
entered by the user. Note: the SearchExpression property is a string.
The string entered by the user is converted using Delphi's StrToDateTime. By
de…If you set Report.SaveAsTemplate to True, the ReportDesigner will ask the
user whether to save changes. I recommend only using the SaveAsTemplate
property at runtime (i.e. do not set to true for Delphi design-time.)
The RBuilder…
There are different approaches to this, here are some options:
1. Use a local database to store the reports. Each user can have their own
local database to store and retrieve reports.
2. Implement the TppDesigner.OnC…