nicocizik
Comments
-
Hi Max,
This is the designed behavior of ReportBuilder when encountering Null
values. You can use the Band.BeforePrint or the DBText.OnPrint event to
check for Null values then manually assign the value to "0" if it is.
… -
Hi John,
Thanks for the clarification. I believe we fixed some issues with the
IBExpress demo for 10.01 but somehow they were not added to 10.02. Please
upgrade your version to 10.05 and see if that helps the problem. For <… -
Hi John,
When saving a report template to database directly from your application,
you need to be sure you set up the Report.Template.DatabaseSettings
properties correctly. This includes creating and assigning a name field an… -
Hi Thomas,
Please use your full name when posting to these newsgroups.
I'm a bit unclear about the condition you would like to check. If you just
need to check the value of the data field, you can access it through the <… -
Trevor,
You need to be sure you select at least one field from each table you select
in order to have a valid SQL statement.
--
Regards,
Nico Cizik
Digital Metaphors
in Re: Getting Error when selecting tables in data view ... Comment by nicocizik April 2007 -
Hi Sandor,
The DBChart will simply traverse the data it is connected to and generate a
chart based on that data. It is up to you to filter or provide a search
condition to the data in order to only show the points on the char… -
Hi Sandor,
Please forgive me, I'm a bit confused about what exactly you would like your
report to look like.
Note that if you place a DBChart inside the detail band, it will print for
each record in your dataset. A… -
Hi Sandor,
We have thousands of customers and many of them use AMD processors however
we have never heard of this issue. It is my understanding that AMD
processors are designed to run the same processes as Intel. This leads … -
Hi Sandor,
For future reference, please post to these newsgroups using your full name
rather than your email address.
The TeeChart component in ReportBuilder is simply a wrapper around the
actual TChart component cr… -
Hi Bob,
You can alter the Field Alias's of each field to give the users a more
friendly message in the AutoSearch dialog. In the fields tab of the query
designer, click a field alias, wait a second, then click it again to edi… -
Hi Tom,
My first guess is that the TextPipeline is ignoring the hyphen and space
characters when determining the field length. I will take a look at this.
As a rule of thumb, it is best to keep the field size well beyond the … -
Hi Peter,
If the detail field is null the Master record will print only if the detail
pipeline's SkipWhenNoRecords property is set to False. Otherwise the master
and detail records do not display.
--
Regards,… -
Hi Peter,
You should be able to do so by simply creating another TppMasterFieldLink
object...
lFieldLink1 := TppMasterFieldLink.Create(nil);
lFieldLink2 := TppMasterFieldLink.Create(nil);
etc...
Hi Bill,
Thanks for the clarification. The AddExpression returns a TdaCalculation
object which is a descendent of the TdaField class. After you call
AddExpression you can manually assign the TdaField.FieldAlias property to <…Hi Bill,
When using the TdaSQLBuilder.AddAutoSearch routine you can define the table
and/or field using the name or the alias. Both should work correctly.
--
Regards,
Nico Cizik
Digital MetaphorsHi Bill,
You should be able to update the SQLText property to add custom sql code.
Take a look at the following examples of creating all the dade components
needed and editing the SQL code using the SQL object.
Hi Ian,
If the extra field exists, you could possibly use the TdaSQLBuilder to add
the field to the dataview/datapipeline that is connected to that dataset.
I'm a bit unclear about the specifics of your application. Are givin…Hi Bob,
If you just need to reprint the detail band up to three times, you can alter
the TppDetailBand.BandsPerRecord property to the number of times you would
like it to print per record traversal. Setting this value to 3 wo…Hi Jerri,
If you are calculating the sum of a value inside a subreport from the main
report, you will need to place another variable inside the subreport and use
its OnCalc to update the value of the variable in the main repor…Hi Jerri,
I'm a bit unclear about the calculation that is incorrect.
1. Are you strictly using TppVariables? Where are the variables located in
your report.
2. Are you trying to calculate the grand total from the …Hi Angela,
Are you using an application with ReportBuilder built-in or are you using
the full version of ReportBuilder?
The sort order in a report is controlled by the dataset itself. You will
need to access the qu…Hi JF,
In my quick testing with the DBDEMOS database and using the exact code
provided with the article you posted, I was able to successfully link two
datapipelines in a master-detail relationship in code.
Where ar…Hi David,
Thanks for the clarification.
Yes, creating queries in the data tab (DADE) is an easy and efficient way to
connect a report to your data. Under the covers however, ReportBuilder is
automatically creating …Hi David,
The idea of a DataPipeline is that it simply provides a connection from the
report to dataset (or SQL Query). It is the mechanism RB uses to retrieve
data from your database.
What exactly are you trying t…Hi Frank,
If you always run the DefineField loop before loading your application, the
fields should stay persistent. If you would like to add each field to the
form definition, you will need to create something similar to the…Hi Frank,
An easy way to create fields at runtime is to use the Pipeline.DefineField
routine. Placing this in a loop will quickly create the fields you need.
--
Regards,
Nico Cizik
Digital Metaphors…Hi Jack,
These properties (which are part of the TppField and TppAutoSearchField
objects) are only included in ReportBuilder for backward compatibility.
They currently serve no function.
What are you trying to accom…Hi Imam,
The ppBDEPipeline and ppDBPipeline are the same. The ppBDEPipeline is
provided only for backward compatibility with older versions of
ReportBuilder.
The datapipeline simply retrieves the data it is given. …Hi Andi,
Which version of ReportBuilder and Delphi are you using? I'm a bit unclear
about the error you are receiving. If you trace into the ReportBuilder
source, where is the error occuring? There is no way to prevent RB f…