nicocizik
Comments
-
Hi Trevor,
You will need to either remove the ChildDBPipeline every time you load that
specific template or remove the dataview manually and resave the template.
--
Regards,
Nico Cizik
Digital Metaph… -
Hi Trevor,
You can use the TdaSQLBuilder (TdaSQLBuilder.Clear routine) to clear out a
DataView of all tables and search conditions or if you would like to
completely remove the entire dataview, you can simply free the
Td… -
Hi Ian,
Typically the DADE plugins do not replace the TdaSQL class. This is how all
of the plugins work that are included with ReportBuilder and are available
from our web site. The IsOrderedByAggregateCalcField is not a new… -
Hi Ian,
The IsOrderedByAggregateCalcField routine is located inside the TdaSQL class
(daSQL.pas). This unit is referenced in the uses clause of the
daLinkBroker.pas file. Check to be sure you are not referencing any old RB <… -
Hi Rob,
Which version of ReportBuilder/Delphi are you using? Are you using the
end-user solution including the ReportExplorer and Designer to alter and
save reports similar to the demos located in the \RBuilder\Demos\EndUser … -
Hi Nigel,
The ReportBuilder Query Designer does not support conditional joins on a
specific value like your second query. I'm unsure why adding a Where clause
condition returns no records. This is either a limitaion of SQL S… -
Hi Rob,
What is the datatype of the Paid field? Note that SQL Server does not
support a boolean datatype. If this is a Bit datatype, you will need to use
1 and 0 as True and False respectively.
--
Regards,Hi David,
Great! I'm glad you got it working.
Thank you for offering to help others that may have this issue.
--
Regards,
Nico Cizik
Digital Metaphors
in NexusDb & Date Comment by nicocizik August 2007Hi David,
Be sure that the DataBaseType property of the Designer.DataSettings object
is set to dtNexusDB and that the DataBase Type option in the Data Settings
dialog of DADE is also set accordingly. It looks like this proper…Hi David,
Are you using the Nexus DB2 plugin located in the \RBuilder\Demos\End User
Databases\Nexus\ directory? Looking at this code it looks like the database
type is properly set in the TdanxSession.GetDatabaseType routine…Take a look at the following article.
-------------------------------------------------
Tech Tip: Date formats used by DADE
-------------------------------------------------
DADE handles in two phases:
Hi Bill,
I'm a bit unclear about what you would like to accomplish. Do you need to
enable the use of UDF's in DADE?
ReportBuilder does not natively support using UDF's or Stored Procedures
with DADE. It is my unde…Hi Bill,
Yes it is definitely possible to create custom dataviews using daADS. As
you mention below, I would recommend taking a look at the Stored Proc
example located in the SQLServer\ADO\Stored Proc\... directory in the RB …Hi Bill,
Sorry for the delay in this response.
Be sure you are setting the DataPipeline.AutoCreateFields property to False.
You will see that this is done in the Init routine of the
TdaBDEQueryDataView class.
<…Hi Bill,
Yes, it is possible however as I mentioned before, all the logic for
handling these calculations is inside the TdaSQL class so you would be
forced to either decend from that class or alter the source code which isHi Bill,
If you take a look at the TdaCalcPage class located in the
daQueryDesigner.pas file you will see how calculations are made. All the
available calculations are defined as an enumerated type TdaCalcType defined
i…Hi Bill,
Try setting the DataDictionary.ValidateTableNames and ValidateFieldNames
properties to False. This will remove the table and field validation
process from the DataDictionary and just rely on the entries inside theHi Andy,
The nice thing about the DADE plugin architecture is that you can alter the
plugins to meet your specific needs. DADE uses the TdaDataSet.GetTable to
either create or get an existing table. This routine is overridde…Hi Monte,
Which version of ReportBuilder and Delphi are you using?
We do not have Firebird however I downloaded the FIBPlus plugin and
successfully tested the included demo with the Employee database included
with I…Hi Terje,
In order to successfully load your report(s) from database, you will need to
assign the Template.DatabaseSettings.Datapipeline property. This
datapipeline is to be directly connected to a dataset with your reportHi Branden,
Thank you for the feedback. We will continue to consider this enhancement
for a later major release of ReportBuilder.
--
Regards,
Nico Cizik
Digital Metaphors
in SQL having statement Comment by nicocizik October 2007Hi Branden,
I believe you asked this same question on 11/08/2004...
.
There is currently no support for t…Hi Scott,
These constants have been moved to the ppRptExpCommon.pas file.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphor…Sorry, the previous post assumes you are using RAP.
If you are, take a look at the article below on extending RAP (creating pass
thru functions etc.). I would suggest getting this working in Delphi first
regardless then movin…Hi Andrew,
ReportBuilder will not execute any SQL code until the report is being
generated. If you need to execute a query before the report generates, you
will need to access the datasets directly (perhaps using Delphi compo…Hi Andrew,
At what point in time are you looking to access your dataset? As a general
rule of thumb, it is not a good idea to access or manipulate your data once
the report has begun generating. The easiest/most robust way t…Hi David,
1. Please use the nexus plugin included with the installation of
ReportBuilder. rbNexus77 implies that it is to be used with ReportBuilder 7
and Delphi 7.
2. Open the rbNexusDB10105.dpk and be sure the …Hi Halim,
In my testing, opening a report, closing the report and dataset, adding a
field to a Table, then re-opening the report works successfully. Be sure
you are completely closing the dataset the report is connected to be…Hi Halim,
Yes, sorry, the MetaData Cache will not help in this case.
1. You need to be sure the new record is actually being committed to your
database. This will most likely involve closing the query, adding the
…Hi Halim,
Try clearing the MetaData Cache. If you are using the end-user designer and
simply changing the query being used, the report will honor those changes
when it is regenerated. (This works as expected in my testing).<…