nicocizik
Comments
-
Hi Scott,
By definition, ReportBuilder will trim all leading spaces off any search
condition. There currently is no workaround however we will consider adding
an option to DADE for a later release. Currently and for your ver… -
Hi Don,
For ReportBuilder 11, all demos have been moved to a new location on your
machine. Take a look at the following article on how to find them.
The Advantage plugin is located in the \Demos\4. EndUser
Database… -
Hi Patrick,
Not to worry, there's no such thing as a "stupid" question on here. The
parameters feature can be confusing at first however once all the pieces are
in place, it can be a very useful and powerful feature for you a… -
Hi Patrick,
If you create a separate dataset (in the Data Tab) simply containing the
customer names, you can then assign the
TppParameter.LookupSettings.DataPipeline property to that dataview and the
ValueField property … -
Hi Hendra,
At runtime you should simply need to add the daUnidac reference to your uses
clause to register it. This is assuming it has the propert register
commands in the Initialization section of the file.
At Del… -
Hi Patrick,
When the application loads, the DataPipeline compiles a list of fields, then
when the report loads, a list of records is compiled for the parameter. If
you then add a record to the dataset, it will not be reflecte… -
Hi Patrick,
When are you adding this new datafield? Is this occuring at runtime while
the report is executing? Once you add a new data entry, you might try
disconnecting the datapipeline from the parameter then reconnecting … -
Great!, glad we got to the bottom of it.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
-
Hi Patrick,
I have tried, but am unable to recreate this behavior on my machine. The
autosearch fields and settings are saved to a template the same as any other
component however according to your descritpions, they are the … -
Hi Patrick,
Using the same technique, if you change another aspect of the report (such
as a label color) and save it to your DB, then try to load and view it are
you able to see the changes reflected in the viewer?
… -
Hi Patrick,
The ppViewer.DisplayAutoSearchDialog is simply a passthru to the
Report.DisplayAutoSearchDialog call. If you are loading templates, it will
display the autosearch dialog saved down with that template. You will ne… -
Hi Patrick,
Once you load the template, you can check the Report.AutoSearchFieldCount
property to determine how many autosearch fields are present.
--
Regards,
Nico Cizik
Digital Metaphors
Hi Patrick,
In my testing with RB 11.06 and ADS 9.1, I was able to successfully add
numerous fields with the TRIM function without any errors (similar to your
query). If possible, please send a simple example that demonstrate…Hi Patrick,
As a test, copy the SQL code generated by the Query Designer and try
executing it manually on your database (either using a simple Delphi app or
using the Advantage consol. I'm trying to find out if this is an iss…Hi Patrick,
Which database are you using? Are these fields with the TRIM function
declared as Calculated fields in the Query designer or are you entering the
SQL manually? If you take a look at the SQL that is generated by t…Hi Patrick,
This is not a known issue. Are you able to see this error in the Delphi
IDE? If so, try tracing into the RBuilder source and let me know exactly
where the issue is occuring. Also, try to simplify the report that…Hi Patrick,
Yes, exactly. When you clear the MetaData cache, you will refresh the
information the QueryDesigner/Query Wizard shows. The actual DataView
information is saved down with the template so if the field names/table …Hi Patrick,
After you make changes to the fields or tables, try clearing the MetaData
cache. This should force the refresh of any name changes.
in Refresh DataView on Data Tab? Comment by nicocizik November 2009There is now a patch available that solves this issue. Please contact
support@digital-metaphors.com if you would like the fix.
--
Regards,
Nico Cizik
Digital Metaphors
in List index out of bounds(1) when inserting new Group Search Criteria Comment by nicocizik November 2009Hi Ettore,
If possible, please give me the steps I can take (perhaps using the DBDEMOS
database) to recreate the issue here. If it would be easier, you can also
send an example I can run on my machine in .zip format to
…Hi Bill,
For ReportBuilder 11, you can use parameters to do this. This would involve
first creating a parameter using the Report Tree. Next you can set up its
autosearch properties using the object inspector. Finally you us…Hi Alejandro,
The Query Wizard is the dialog with two listboxes next to each other. This
is exactly what the example in the article does
Hi Gonçalo,
The items displayed for the available tables in the query wizard is
controlled by the DADE plugin that connects to the database. The
TdaSession.GetTableNames routine performs this task.
For instance the…Hi Glenn,
Take a look at the AutoSearch demos located in the RBuilder\Demos\5.
Autosearch\... directory. Specifically the "AutoSearch Field to SQL Params"
example. This shows how you (in code) can use the autosearch values e…Hi Hartmut,
Ideally you will do all of this in DADE. There is no need to "give" DADE
any data, you simply create an manipulate the query inside DADE, then your
users can add-on, link to, or remove anything they would li…Hi Hartmut,
Looking at your code below it seems that you are trying to connect the
pipeline of the DADE dataview to an external dataset (TClientDataset). This
is simply not the way DADE is designed to work. The QueryDataView…Hi Hartmut,
There is now a patch available for RB 11.08 that solves this issue. Please
contact support@digital-metaphors.com to receive the patch. Also, once you
apply the patch there is no need to assign the Pipeline.AutoCr…Hi Hartmut,
Rather than editing the SQL text manually (which limits the linking
ability), I recommend creating the query using the TdaSQLBuilder class. See
the following articles and help topic on the subject on how this clas…Hi Uildenei,
The daDBExpress unit is included in the rbDBExx package.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.co…