nardmoseley
Comments
-
You can define AutoSearch fields and then set the initial value via RAP code
or Delphi code.
Example of specifying a list of values for the InList operator...
myReport.AutoSearchFields[0].SearchExpression := 'value1… -
There is now patch available for RB 11.04, that fixes this issue. Please
send an email to support@digital-metaphors.com and request the SQL Group By
patch.
Typically a SQL Group By is used when the SQL includes one or mo… -
With RB 11, you should not need to write any code to handle parameterized
master/detail.
From the Data workspace you can link the queries visually by dragging from
the detail field to the master field or by using the Lin… -
To display Unicode characters you need...
Delphi 2009 and RB 11
Use a Font that supports Unicode
Make sure you have the relevant Windows Language support installed (this
varies by Windows version)
One possible approach for controlling group header/footer visibility is to
implemnent event-handlers for each band.BeforePrint event to toggle the
band's Visible property.
It is not currently possible to create band or …
This is possible in RB 11.05.
One of the new features is the ability to group on non-aggregrate calc
expressions.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
A Report or data-aware component such as a DBText can be attached to a
datapipeline. In fact many reports and objects can connect to the same
datapipeline, there is no limit.
The DataPipeline should not know about object…
As Nico stated, the DBText.Width reflects the Report.Units
An alternative is to use DBText.spWidth which is in screen pixels.
And there is also DBText.mmWidth which is in mmThousandths
--
Nard…
In my prior post, I only meant to change the code on your end as a temp fix
to get it working until we had more time to research it.
There is now a patch available for RB 11.06. With the patch, when using the
Designer.Da…
You just repeated what I said
And that is what ReportBuilder is doing. The Sum( ) calcs are aggregrate
…
What database engine are you using?
According to the SQL standard, all non-aggregrate expressions from the SQL
Select must be included in the Group By.
--
Nard Moseley
Digital Metaphors
w…Yes, when manually defining the fields you should also set FAutoCreateFields
to false.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
You posted in DataPipelines and not in DADE. So I am guessing that you are
using external datasets placed on a form/datamodule. For this case, try
using Delphi dataset linking, which I think supports that type of syntax.
The R…
We have many customers using RB and Advantage successfully, have not heard
of this error.
RB uses simple TDataSet methods such as First, Next, Prior and GetBookmark,
GotoBookmark, GetFieldValue.
RB Serve…
You might try some simple base line tests.
Create a new project and test the custom pipeline, without the master/detail
setup and without the report. Just connect the custom pipeline to your data
and then call methods on…
When the Pipelines are 'Owned' by the Form they will be visible in the
Designer.
The TppDataPipelineList class is defined in ppDB.pas. You can modify that
class if you would like to customize the behavior. The logic is …Yes, using a ClientDataSet or memory-dataset would be a nice solution.
Another option might be to use two datasets. One could be a read-only query
that contains a list of records to print and then the other could be a live
dat…If possible try downloading a trial version of RB 14 and perform the same
test. If not perhaps you can provide an example using a small sample
database or the DBDemos data that I can build and run here. IF so please
send to support…
If you encounter an issue with TSimpleDataSet, then as a test try using a
TClientDataSet with a SQLDataSet and Provider. For the Visual Query tools
included with RB Professional and Enterprise, we internally use the
ClientDa…
From a logical/design standpoint, the DataPipeline should only call
OpenDataSet from DataPipeline.Open. Customers reported the prior behavior as
a bug because the DataPipeline is closed but opens the dataset - that make
no se…
Thanks for providing the example.
To correct the example, double-click each DataPipeline to access the fields
editor. Then close the fields editor and set DataPipeline.AutoCreateFields
to False. Doing this will create st…Andre,
I created a simple test here and did not encounter any issue. For my test I
used RB 15.03, DXE5, and the DBDemos data. I used the RB Data workspace to
create two queries on the Customer table: Customer and CustNoLookup…Hi Chris,
Thanks for providing the details about what you are trying to accomplish.
Once solution might be to use the DBPipeline and implement the
DataSet.OnCalcFields event to extract the XML Blobs and populate the calc …Hi Chris,
I recommend descending from TdaCustomDataView, the anscestor of
TdaQueryDataView. TdaCustomDataView has no concept of TdaSQL, TppDBPipeline,
or TDataSet.
TdaQueryDataView is an abstract ancestor class for …Hi Scott,
The simplest solution is to generate the SQL prior to loading the report.
For the 'design SQL' you can limit the number of records returned in a
couple of different ways.
a. Dummy search condition.
TppPreview was introduced I think around RB version 6.0.
With older versions you can replace the built-in preview dialog as
described in the article below.
------------------------------------------------------------…
We probably never thought of the usefullness of this property outside the
context of subreports.
--
Nard Moseley
Digital Metaphors
http://www.digita…
Thanks for correcting me.
Sorry, about the incorrect info.
There is a freeware component available, check out the friends | RCL
page on our web site.