nardmoseley
Comments
-
One of the best features of RAP is how easy and powerful it is to extend it
with custom functions and RTTI.
For more details, check out the 'Adding Functions to RAP' tutorial in the RB
Developers Guide and the RBuilder\D… -
If the user deletes a Label, then any RAP event-handlers associated with the
Label's events will also be deleted. However, if you have code in say, the
Band.BeforePrint event, that references the Label, then that will cause a
I researched this one. The RAP RTTI for TFont needs to be extended to
support the constructor. We can add this for the next maintenance release.
For now, modify ppRTTI.pas to include the following work around:
- add…
TdaSQLBuilder.Sql provides access to the TdaSQL object, so try something
like...
lSQLBuilder.Sql.SqlText.Text := 'SELECT * FROM ADRESSE Where ZIP<1100';
--
Nard Moseley
Digital Metaphors
RAP does not currently contain any support for the WideString datatype. This
is something that we need to add going forward...
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
RB 9 introduced a new Report.OnInitializeParameters event that can be used
to cancel a report (and to initialize parameters, show custom dialogs, etc).
The event-handler includes a boolean parameter, aCancel, that can be set to- you can easily register more functions with RAP. See article below.
- I think RAP has built-in support for EncodeDate, DecodeDate.
- TDateTime is a double, the integer part is the number of days since
12/30/1899 and the…> 1) How do I now manipulate that date in code to get the prior year or
Report.AutoSearchFields[0] returns a TppAutoSearchField object.
TppAutoSearchField.SearchExpression is of type String. For the Between SQL
operat…
One difference is that you are using the SQL Between operator. I modified
the example that we provided to use the SQL Between operator and found that
I had to change the code as follows...
- I modified both SQL queries t…
http://www.digital-metaphors.com/tips/ApplyAutoSearchValueTo2ndQuery.zip
--
Nard Moseley
Digital Metaphors
w…Please provide more details about what you are trying to accomplish, I do
not understand the question.
The main report has a TdaDataModule that contains all the QueryDataViews
used by the main report and any subreports. Thus o…Mark,
Please post questions to a single destination - either the newsgroups or
support@digital-metaphors.com but not both.
This question was also sent to support@digital-metaphors.com. Here is the
email reply that …---------------------------------------------------------------
Article: Resources for Learning ReportBuilder
---------------------------------------------------------------
1. Learning ReportBuilder is a complete learning syste…
For future reference please specify environment details.
Are you using MS Access? For MS Access a datetime literal in a SQL statement
will look like
#2008-02-15 00:00:00#
SQL for datetime literlas a…
For Internationalization of Report content such as Labels, check out
Sisulizer - they contacted us within the last year and did some work on
supporting RB.
in How to detach all events in raport Comment by nardmoseley February 2008
I recommend adding code to check for FirstPass.
if Report.FirstPass then
begin
{create memo object}
end;
You cannot create/destroy objects during the second pass. You need to define
the repo…
- for the section subreport, make sure you have subreport.NewPrintJob set to
true and ParentPrinterSetup to False.
- now subreport.Report.PrinterSetup.PrinterName will control the
destrination for the section.
QueryDesigner and SQLBuilder both provide an easy way to configure the
TdaSQL object assoicated with the QueryDataView. The TdaSQL object has two
modes, it either contains an object based description that it uses to
generate …
Your custom plug-in can specify the date/time formats that the SQL requires.
See daDB.pas, the class TdaSession defines virtual methods for
GetSearchCriteriaDateFormat and GetSearchCritieriaTimeFormat. In your
TxxPervasi…
Which DADE plug-in are you using are you using?
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
When using the Query Designer or SQLBuilder to specify a search date, use
the locale format for your environment - MM/DD/YYYY.
When TdaSQL generates the SQL command, it will translate the date into the
format required by…For future reference, please post using your real name, rather than 'muck'.
Please post to a relevant newsgroup. This is the RAP newsgroup and thus
focuses on RAP - the run-time Pascal environment included with RB
Enterprise. …
If you are using the Query Designer to define Calc fields, then you can use
TdaSQLBuilder.CalcFields[ ] to acess the calc fields items at run-time. The
items are of type TdaCalculation and have an Expression property.
Td…Here is an example that shows how to manually edit the sql text and
implement autosearch.
www.digital-metaphors.com/tips/EditSQLAndAutoSearch.zip
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com…
Works in my testing here with RB 10.08.
If you are using a prior release, download a trial version and give it a
try.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Here is a simple example to hide the preview tab...
procedure TForm1.Button1Click(Sender: TObject);
var
liPreviewTab: Integer;
begin
liPreviewTab := ppDesigner1.Notebook.PageCount-1;
ppDesigner1.Notebo…
Try using a TppVariable or TppDBCalc with LookAhead set to True.
For formatting use the component's DisplayFormat property.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
As a quick work around try
varMonth.value := -1 * varMonth.value;
I can duplicate the AV here and will research it.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
In the code you posted, I do not see anything about ResetPageNo, both lines
say Report.Groups[0].NewPage.
That said, I do not think conditionally configuring the group properties
will work. Most Group properties are desi…h
Selecting All records is slow, we do not recommend that. I think you
misunderstood.
Most SQL database engines only support SQL. Using a Table object, results in
a Select All records.
Best solution is to…