nicocizik
Comments
-
Hi Luca,
ReportBuilder 9.0x includes the TdaSQLBuilder object wich makes if very easy
to access and alter the SQL object in DADE. Take a look a the TdaSQLBuilder
topic in the ReportBuilder held for a detailed description and … -
Hi Rodrigo,
Unfortunately, DADE does not support the use of parameters from within the
SQL code. You will need to use the autosearch feature to add or change the
search criteria of a SQL statement in DADE. Note that this has… -
Hi,
For future reference we prefer you use your real name when posting to these
newsgroups.
I'm a bit unclear about how your application is set up. Are you using DADE
to define your datasets? If so, there is no ne… -
Hi Vincenzo,
If possible, please send a small example in .zip format I can run on my
machine that demonstrates this error to support@digital-metaphors.com.
--
Regards,
Nico Cizik
Digital MetaphorsHi Richard,
There is now a patch for this issue. Please email
support@digital-metaphors.com requesting this patch and well send it to you
as soon as possible.
--
Regards,
Nico Cizik
Digital Me…Hi Dimitar,
Yes, it is possible to successfully change the SQL in RAP at runtime.
Starting with RB 9 we introduced the TdaSQLBuilder class. This class makes
the task of accessing and altering the SQL object in RAP and Delphi …Hi Dimitar,
If you would like to manually open and close your datasets from RAP, you
will need to create a RAP pass thru function. Examples of creating pass
thru functions can be found in the ReportBuilder Developer's guide l…Hi Bin,
I can think of two items that may be causing this behavior.
1. If you look at the TdaMetaData.GetFieldsFromDataSet procedure, the error
is probably occuring after the lDataSet.Active := True; line is called. You…Hi Bhoj,
Where in your app are you calling SQL.SelectFields? Perhaps you are calling
this too early for the field alias to be set. Does this happen for every
field?
--
Regards,
Nico Cizik
Dig…Hi Bhoj,
The FieldAlias is either obtained from the DataDictionary, or (if you are
not using the DataDictionary) from the FieldName. If you need the
FieldAlias to display something different than the FieldName, you will need …Hi David,
This can be done in RAP using the TppReport.AutoSearchCriteriaByName
routine. If for instance you have a variable inside your header band you
could place the following code inside the HeaderBand.BeforePrint event to…Hi Dave,
I would suggest trying the DetailBand.BeforePrint event.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.comHi Dave,
You can use the DetailBand.BandsPerRecord property to determine how many
copies of a certain detail band you would like printed. If this number
changes for each record in your dataset, you can dynamically change this…> In my end user report designer I only have Design and preview tabs ?
Is this at design time? If so, you may not have the proper packages
installed into your IDE. Selecte Component | Install Packages from the
Delphi main…Hi Dave,
Yes, from the data workspace (data tab) in the designer, be sure your
datasettings are properly set by using the data settings dialog (File | Data
Settings). Then select File | New and choose the Query Wizard option …Hi John,
Yes, this should still work. We did not change the plugin architecture
until RB 10.x.
--
Regards,
Nico Cizik
Digital Metaphors
Hi John,
The older version of the NexusDB plugin can be downloaded from our web site
at the following address. Note that you will need to change the package
contents and file name to match the versions of RB and Nexus you are…Hi Isaac,
I sincerely apologize, usually when I see the same subject for a post from
the same person, I assume it is a cross post
This question has been answered in the End-User newsgroup. Please do not
cross post.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-m…Hi David,
If you are just after the two values, you will need to use the
TppAutoSearchField.Values property to get access to both values. For
instance...
var
lAutoSearchField: TppAutoSearchField;
begin<…Hi Andrew,
Try using a Section style subreport. This type of subreport by definition
will print on its own page. Simply right click over the subreport object
and select "Section".
--
Regards,
Nico…Hi Jean-Francois,
The Data Dictionary is designed to be used when datasets are created in the
data workspace (DADE) of ReportBuilder only. When you create a query in
DADE, a pipeline is created internally to manage the flow o…Hi Steve,
Unfortunately the Query Designer does not support the use of built-in
functions in the search condition. One option would be to edit the SQL
manually.
--
Regards,
Nico Cizik
Digital …Hi,
The Query Designer does not support SQL Unions. You would need to manually
edit the SQL Text. This is a feature we may consider adding for a later
release of ReportBuilder.
--
Regards,
Nico Ciz…Hi James,
Once you edit the SQL manually in DADE, you loose all of the Query Designer
options and dataset linking capability. If you would still like to add
autosearch to the edited query, you will need to do so manually usin…This questions has been answered in the End-User newsgroup. Please do not
crosspost.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-m…Hi,
You should be able to intercept the autosearch value using the
OnGetAutoSearchValues event of the report. Then if you are using DADE, take
a look at the TdaSQLBuilder object. This allows you to access the SQL
objec…Hi Grant,
This can be done in DADE by simply selecting the table and fields you would
like in your report, then defining a search criteria limiting the query to a
single record. This can be accomplished both in the Query Wiza…Hi John,
Take a look at the following example of how to send ESC commands to a
printer using the Windows API routine Escape().
http:…Trevor,
This is not a known issue. Please upgrade your version of ReportBuilder to
the latest (RB 10.06) and test with that. For upgrade instructions, contact
info@digital-metaphors.com with your serial number and purchasing…