nicocizik
Comments
-
Hi Patrick,
This can be done using the parameters feature of ReportBuilder.
1. Create a new parameter using the report tree and assign its value
properties and autosearch properties. (you can assign it a lookup listHi Igor,
Thanks Igor, we appreciate your feedback.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Hi Paolo,
Zooming in the designer (or data workspace) is not currently a feature of
ReportBuilder. This is something that we are considering for a later
release of ReportBuilder. Thanks for the suggestion and feedback.
…Hi Whit,
Yes I believe the ReadMe was written for older versions of Delphi (7 or
earlier) however the same concepts apply.
When you select Tools | Options in Delphi 2010, you then need to navigate to
the "Library - …Hi Whit,
Connecting your DADE pipelines to an Advantage database is identical to
connecting to most any other DB. You will simply place a TADSConnection
object on a form and connect it to your DB, then after adding the Advant…Hi Phil,
We have updated some of the DADE plugins to support views such as the ADO
plugin however it may be necessary to update the plugin you are using to
support views in your application. One of the main reasons we impleme…Hi Jo,
Take a look at the TdaSQLBuilder class. This gives you the ability to
easily create and edit just about every aspect of a dataview/query in DADE.
First see the help topic on TdaSQLBuilder and relating classes for …Hi Edgar,
When using parameters in DADE, you need to be sure you use the proper syntax
(:ParameterName). In your examples below, you are adding a space between
the colon and param3 doesn't have a colon at all.
-- <…Hi Branden,
Try upgrading to RB 12.02 and see if that helps the issue. We made a few
fixes relating to manual SQL and parameters that could solve the problem.
For upgrade instructions, contact info@digital-metaphors.com with …Hi Branden,
You have two options.
Depending on the version of ReportBuilder you are using (RB 11+) you can
manually edit the SQL text and still link your datasets. You could manually
create your queries including p…Hi Terje,
Which database are you connecting to? Take a look at the following article
on how DADE handles date values.
htt…Hi Tyran,
I downloaded DBISAM version 4.30 build 2 for Delphi XE, installed it, then
opened the dclRBISAM1215.dpk package, altered the requires clause for the
updated version of DBISAM, built and installed into the IDE success…Hi Tyran,
Which version of DBISAM are you using? I just logged into our DBISAM
account in the Elevate website and saw that the latest version available
(4.29) did not have a version for Delphi XE.
Regar…Hi Terje,
Are you using the DataDictionary? If so, have you refreshed its table
values?
Regards,
Nico Cizik
Digital Metaphors
htt…Hi Terje,
Take a look at the following article on clearing the Metadata cache.
http://www.digital-metaphors.com/rbWiki/DADE/MetaData/…Hi Ian,
Are you able to run the original demo (using Paradox)? Which version of
ReportBuilder are you using?
Sorry to move backward, I just want to find out if this is related to
Advantage or something else.
<…Hi Ian,
Using Delphi XE should not make a difference. I just ran the original
demo in Delphi XE without any problems.
My guess is that this is a data access error. At what point in the demo
code (which event) does…Hi Ian,
The easiest way would be to run through each template (as text) and
alter the table names in code. If these templates are saved to
database, which I assume they are, take a look at the following example
on how t…Hi Ian,
The error indicates that the template was saved down with some RAP code
(Code tab). If you enable RAP (add raIDE to your uses clause) the error
should go away. Another option is to load the template at runtime andThe examples in the RB Wiki are meant to familiarize you with the
feature. It is definitely possible to create new autosearch criteria
using the SQLBuilder. This is all documented in ReportBuilder help
including how to set up a "…Hi Chris,
When you say that you need this to happen in "DADE" I assume you are
only using RAP code?
If so, I suggest using the TdaSQLBuilder object to alter your search
criteria. TdaSQLBuilder is fully supported by…Hi Marcos,
You can find the demo located at the following location. These were
moved to better support the Windows Vista/7 architecture.
in Urgent help with advantage database Comment by nicocizik April 2011Hi Paolo,
The default value of PDFSettings.ScaleImages is True. The value will
only need to be saved to file if the default is changed.
Regards,
Nico Cizik
Digital Metaphors
in save report template Comment by nicocizik May 2011Hi Marco,
You can access the AutoSearch fields either using the
Report.AutoSearchFields property or by using the TdaSQLBuilder object
and clear out the SearchExpression value.
The best place to do this would be in a…Hi Arturo,
I believe the reason the DatabaseType was not saved down in your
templates is that dtOther is the default value for the property.
The report templates are not designed to be used with multiple database
ty…Hi Chantal,
Which exact version of ReportBuilder and Delphi are you using? Also,
which database are you currently using?
In my testing with RB 12.05 and a simple example using the DBDEMOS
database I was able to man…Hi Dave,
Using the Query Designer, you can set the search expression to "Not In
List" in order to use the NOT IN command in your query.
Dave,
Are you using Parameterized linking or Manual linking? Generally a Key
Violation Error occurs when trying to update a table. Are you trying to
alter a table from DADE?
Try control clicking over the detail da…Hi Chantal,
It appears Paradox does not support the Having clause when there are
non-aggregate expressions being selected.
Which database are you using for your application? Is it possible you
can send me an exampl…Hi Chantal,
What I really need is a reliable way of recreating this on my machine.
As a test I tried recreating the scenario you described below but was
unable to get an error when adding group search.
If possible, …