nicocizik
Comments
-
Hi Ed,
There should be no need to create your own plugin etc.
To test if adding the schema name will work, simply open the
daDBExpress.pas file, and alter the code at the bottom of the
TdaSQLSession.GetTableNames to… -
Hi Ed,
Seeing that you are using the latest version of Delphi, one option is to
try FireDAC rather that DBExpress to connect to your data. The FireDAC
plugin contains logic to automatically try to use the correct schema
Hi Chris,
We do not permit attachments in these newsgroups. If possible please
resend this message (along with the attachments) to
support@digital-metaphors.com and we can continue this conversation via
email.
Hi Chris,
I was not able to recreate this behavior with a simple demo. The only
reason the linking should automatically change to Parameterized is if
you are manual editing the SQL. If you are able to reliably recreate…Hi Julien,
Many ReportBuilder DADE plugins use this SQL command to obtain your
table field names. This command should return 0 records and execute
fairly quickly and is the only way in many cases to get a list of your
f…Hi Terry,
All columns in the "select" clause that are not an aggregate function
need to be in the "group by" clause. Otherwise you will have an invalid
query and will likely get an error from your DB.
--
Jeroen,
Try using the Global.OnCreate or the OnGetAutosearchValues instead of the
OnAutosearchDialogClose event. The Global.OnCreate would probably work best
for your situation.
--
Hi Waguih,
Try setting the variable's datatype in the GlobalOnCreate event. You can
access this event by right clicking in the Report Objects window of the Data
tab in the Report Designer and selecting "Module". Then select th…Hi Waguih,
1. Yes, RAP would be your best option if trying to use different event
handlers for each template you load in the Report Explorer.
2. You can change the datatype of a component using RAP. Select the
comp…Ian,
Since we do not include the source code to RAP, if you change the interface
section of any RB source, RAP will no longer work. If you need to use RAP,
please reinstall ReportBuilder and replace all the changed code with th…Rhonda,
The OnGetAutoSearchValues event fires before the GlobalOnCreate event. They
will each fire once. You can check the timing of other events in RAP by
placing a ShowMessage call in the event handler and previewing or runn…Ben,
Sorry, I just realized that there is a way to set the value of the
TppAutoSearchField by using the published property SearchExpression. I
tested this with RAP and it seems to work correctly. Here is the RAP code
that…Ben,
The TppAutoSearchField.Value property is a read only property so you will
not be able to assign this value. You will need to create the autosearch
criteria completely in RAP using the CreateAutoSearchCriteria function. Yo…Ben,
Sorry but unfortunately adding AutoSearch criteria is not possible in RAP
unless you us a passthru function.
--
Hi Ben,
Below is an example of how you could add an "OR" or parentheses to a search
criteria using Delphi code. This, however, will require that you use a
passthru function to get this working in RAP. See the ReportBuilder
Hi Paolo,
Since RAP does not support Delphi Sets, we decided to make each Font.Style
into a boolean property to enable a user to access them. You're RAP code
should look something like the following:
BadgeName.Font.B…--------------------------------------------
Article: Troubleshooting Lost Event Handlers
--------------------------------------------
Let's assume you have created a report in Delphi and assign an event
handlers to the OnP…Hi Nikolai,
Sorry, there are currently only 3 ways to change the caption of a label in
ReportBuilder.
1. Delphi Object Inspector (Caption Property).
2. ReportBuilder Edit box (at the top left of the Report Designer)…Hi Felix,
You can hide the detail band by setting its Visible property to False in the
DetailBeforePrint event. Something like the following...
procedure DetailBeforePrint;
begin
if (customer['CustNo'] = 1231)…Hi Heinrich,
Please send an example .rtm file demonstrating the issue in .zip format to
support@digital-metaphors.com and I'll take a look at it for you.
--
Hi Chris,
Sorry, there are no short cuts available in RAP to compile your code other
than using the popup menu option in the code editor. When writing code the
RAP compiler should however compile your code periodically automati…Hi Uwe,
Unfortunately, you have run accross a limitation of ReportBuilder. Using
the DetailBand.AfterPrint event in this case is the best option for what you
need to do.
--
Hi Nicola,
ppToMMThousandths is an internal function used to ensure the highest
precision when making report calculations. There are many methods similar
to this one located in the ppUtils.pas file but they are all meant to be<…Hi Scott,
Whenever making calculations in ReportBuilder, it is always best to make
calculations in the OnCalc event of the TppVariable component. For instance
you could place a TppVariable component in your detail band with the…Hello,
There have been multiple updates and fixes in this area since RB 6.03. My
suggestion would be to download a trial version of ReportBuilder 7.03 and
test with that. If this solves the problem, you will need to update to …Hi,
This and many other helpful tips are available in the ReportBuilder and RAP
help file. \RBuilder\Help\...
Q:
Since RAP doesn't support Set types, will I be able to set TFont.Style in
code?
Hi Phillip,
The reason you are seeing this error is that the type of the Variable does
not match the type you are trying to set it to. In the Report Designer, be
sure you set the TppVariable's type to Currency, or Double. This…Hi Kongthap,
Starting with ReportBuilder 7.02 parameters were added to the feature list.
You can use report parameters to pass a value from Delphi into a report.
Check out the simple example below for an example of how to use Re…Hi Jakob,
Unfortunately there is not a single component available in ReportBuilder to
merge two data values into one area. If you are designing your reports at
runtime, you still have access to RAP which gives you a full develo…Hi Jakob,
There are two ways to do this. First, you can use a single TppVariable
instead of multiple DBText components. Then append each data value on to
the value of the variable directly leaving a single space between the