nardmoseley
Comments
-
This article discusess conversion from BDE to ADO, but same concepts apply
to any conversion...
-------------------------------------------------
Tech Tip: Convert BDE Template Dataviews To ADO
----------------------------… -
I was able to create the following downloadable example. (In testing it, I
noticed that the MoveBounds/ResizeBounds notifcation fires a bit too often,
something we look at optimizing going forward.)
www.digital-metaphors… -
The TdaSQL object contains an object based description that is used to
generate a SQL statement. You cannot check the SQLText, because it will not
be generated until after the autosearch dialog is displayed. Instead you
need … -
Try something like this...
uses
ppAsField, daQueryDataview, daSQL;
var
lSQL: TdaSQL;
if myAutoSearchField.DataView is TdaQueryDataView then
lSQL := TdaQueryDataView(myAutoSearchField.DataVi… -
RB is designed to enable the report to be moved to different regional
settings. However, I researched this and found an issue in the logic for
loading the TdaSQL, TdaCriteria. A patch is now availablef for RB 10.07.
Reg… -
Try adding RBuilder\Source to the Delphi library path. Set the debugger to
break on language exceptions. Build and run the project. The compiler will
stop and open the source code when the error occurs. Check the call stack.
-… -
Thanks for reporting this. There is now a patch availabl for RB 10.07.
Registered users of RB 10.07 can email support@digital-metaphors.com to
request the patch.
A work around is to use the object inspector to modify the… -
For RB 10 we added a ReportExplorer.ItemTemplatePipeline that enables the
report explorer to be optimize. See the ReportBuilder help topic for this
property. And see the RBuilder\Demos\EndUser Database examples.
--
Nard … -
- Have a look at the custom autosearch dialog demo
(RBuilder\Demos\AutoSearch\Custom AutoSearch dialog. The architecture is
very flexible and powerful. For each autosearch field, a separate AutoSearch
Panel is created. Togeth… -
- you can select autosearch panels based on any TppAutoSearchField property.
Most useful properties are FieldName and DataType.
- to use a date picker for date fields, check the Field.DataType - it will
be dtDateTime or … -
There are no known issues with groups. If you would like to create a simple,
focused example, please use standard Delphi components and RB. Use the
DBDemos data or dump some of your data out to TClientDataSet. Send in zip
for… -
- for the Query, add an Order By caluse that sorts the data by the grouping
field. RB will not do that for you.
- the report engine will traverse the datapipeline to which it is assigned.
Group.OnGetBreakValue gets calle… -
Do to the timing of when the group break value is checked by the report
engine, you need to use either the Group.OnGetBreakValue event or the
Variable.OnGetText event.
--
Nard Moseley
Digital Metaphors
www.digi… -
I recommend modifying the source code to the relevant DADE plug-in (see my
first response to this thread). My intent was for you to try implementing
that code as a solution to your issue.
--
Nard Moseley
Thanks for the feedback.
- This is something we can add for the next major release.
- For tighter security you can optionally set
Designer.DataSettings.AllowEditSQL to False
Designer.AllowDataSetti…
One solution would be to modify the DADE plug-in to allow only Select
statements. For example, if you are using ADO, modify daADO.pas, the method
TdaADOQueryDataView.SQLChanged.
Example:
lsSQLText := SQL.Magic…- Please do not post attachments to the newsgroups - please follow the
newsgroup guidelines.
http://www.digital-metaphors.com/support/newsgroups.html<…Thanks for the feedback. I updated the example - please download it again.
http://www.digital-metaphors.com/tips/PreventEditOfComponents.zip
Here is an example I created that shows how to prevent the end-user from
modifying the report header. No objects in the header can be selected and no
popup menus can be invoked.
in Disable the bands Header and Footer so that the end user can not change anything. Comment by nardmoseley November 2007
- This example shows how to control the designer selection.
http://www.digital-metaphors.com/tips/DesignerSelection.zip
- To c…
InfoPower RichEdit Support
---------------------------
InfoPower from Woll2Woll Software is a popular database add-on product for
Delphi. InfoPower's TwwRichEdit components support the Windows RichEdit2
format. This…
Here is an example that shows how to do several different customizations of
the RB 10 designer menus and toolbars...
www.digital-metaphors.com/tips/Designer10_CustomizeMenusAndToolbars.zip
--
Nard Moseley
The DataDictionary is useful for defining which tables and fields are
visible to the user and for defining user friendly field aliases. But there
is no functionality for converting datatypes.
Is there any way you can han…
------------------------------------------------------------
Article: Controlling the End-User Environment
------------------------------------------------------------
If you are having difficulty getting the D…
This is not related to moving from D6 to D2007.
I am guessing that you are migrating from an old version of ReportBuilder
and that you have an issue with a custom Report Explorer form.
There was a bug in prior versi…
This is not an issue with ReportBuilder. If you are using Pragnaan to export
to Excel then please contact Pragnaan tech support with any question/issues.
--
Nard Moseley
Digital Metaphors
www.digita…
The RichText/DBRichText componenents internally rely upon the Windows API
call to measure, format and render. The Windows documentation does not
mention how embedded COM objects are treated. If you want to submit a test
case …
Viewer.RegenerateReport
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Please post questions to a /single/ destination. Use the newsgroups /or/
support@digital-metaphors.com. Do not send the same question to /multiple/
destinations.
--
Nard Moseley
Digital Metaphors
I asked you before to please not post to the newsgroups and to
support@digital-metaphors.com.
Please be respectful of our resources and to other customers.
--
Nard Moseley
Digital Metaphors
www.digit…