nardmoseley
Comments
-
1. As a starting point, work thru the EndUser tutorials in the Developers
Guide. They start with paradox and there is one for the DataDictionary and
one for Interbase. The EndUser Databases examples such as IBO, contain a
Rea… -
1. If you have two reports/subreports connected to the same datapipeline and
you need filtering, then you really need two datapipelines (two querys).
The only other alternative would be to use the detailband.BeforePrint event
1.Use the TppDataDictionary to define what table and fields the end-user can
accessa and to define user friendly table and field aliases. You can
optionally pre-define join conditions as well. See the tutorials in the
Develop…
1. You need to save the report to a stream. You can use
Report.Template.SaveToStream to accomplish this.
2. The technique used by ReportBuilder to save reports to the database does
not use a SQL statement. It uses DatSet…
1. One option is to create a custom dataview template. Then the end-user can
select File | New.. from the Data workspace and select your template. For an
example, see RBuilder\Demos\Custom DataViews.
2. Another option is…
The TppViewer.Scrollbox property provides access to the scrollbox. The
Scrollbox VertScrollBar and HorzScrollbar properties can be used to set the
scrolling position.
There are a few options for getting access to the vie…
One way to do this is to use the Report.Template object to load the .rtm
file and then save it to the database.
1. Load the .rtm file
myReport.Template.FileName := 'c:\myReport.rtm';
myReport.Template.LoadFromF…
1. The rbItems and rbFolders tables are no different from other database
tables, so I think using a script should work fine.
2. Another option is to export the reports to .rtm files and then import the
.rtm files into th…
We have not had reports of anything like this from other customers. Try to
recreate the error by running the application under the Delphi debugger.
Another option would be to use an exception handler such as madExcept to try
…
----------------------------------------------------
Tech Tip: Using the JITPipeilne OnGetPicture Event
to display images
----------------------------------------------------
Question
--------
You can easily build this using Delphi and RB. You can create any number of
templates and offer the user a choice using a menu, listbox or whatever type
of user interfact controls you prefer. Then load the template and run th…
I recommend upgrading to RB Enterprise. The requirement you describe is
exactly what RB Enterprise provides an powerful, elegant solution for.
With RB Professional the end-user reports are more limited. Any code that
you…
RB Enterprise includes a Calc workspace that provides a run-time Pascal
environment for coding calculations and event-handlers. This enables the
code to be saved as part of the report definition - outside of the
executable. Y…
I just recalled that there is a TppVariable patch available for RB 9.02 that
contains a fix for an issue related to having a Variable incremented by a
subreport.
Send an email to support@digital-metaphors.com and request…
The basic approach is to use the subreport to update a TppVariable that
resides in the main report. If you are using RAP code to implement this,
then you need to create global var in RAP that provides a reference to the
main …
That error message indicates that the report template contains a reference
to a event-handler method called "ppVarOtherFeesTotal.OnCalc" that cannot be
resolved when the report loads.
If you open each report and resave, …
Try modifying your Delphi library path to include RBuilder\Source (just
above the entry for RBuilder\Lib). Then run in the debugger and step thru
the code.
If you would like to create a simple example that uses ADO and M…
Trace the RB Source code for the unit daADO.pas.
The ADOQueryDataView.SQLChanged method is where the query gets fired.
The Designer.DataSettings should be configured to use the ADOConnection that
resides on the end-…
The ADOConenction object resides on the end-user form.
TADOConnection.CommandTimeOut is a published property. You can set it at
Delphi design-time via the object inspector.in Group Error when SQL is changed dynamically Comment by nardmoseley October 2005
Sorry, it should read TADOConnection.CommandTimeOut
(That value will be applied to the ADOQuery objects created by DADE).
--
Nard Moseley
Digital Metaphors Corporation
in Group Error when SQL is changed dynamically Comment by nardmoseley October 2005
Set TADOConnection.CommanTimeOut.
--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com
1. The standard way to support a dynamic SQL Where clause is to use the
AutoSearch facilities built into the product. See the article below
"Creating AutoSearch parameters via DADE".
2. TdaSQLBuilder can be used to modif…
1. Views
We have modified some of the DADE plug-ins to include Views. If the DADE
plug-in that you are using does include views in the list of available table
names, then modify the GetTableNames method of the plug-in. F…
I tried a test here using RB 9.02. I modified the RBuilder\Demos\EndUser
Databses\MS Access\ADO example. I moved the ADOConnection component to a
DataModule. That worked in my testing here. Are you using RB 9.02? Try doing
th…
We do not have any examples of using that combination. There are examples of
using several popular databases installed to RBuilder\Demos\EndUser
Databases. Those might be useful for comparsion.
1. Query tools
…
This is a feature that we can consider adding to a future release.
One technique is to set the zoom setting to WholePage so that the entire
page is visible. And then zoom in on highlighted areas.
--
ReportBuilder requires an additional registeration:
RegisterComponents('RBuilder', [TppReport]);
RegisterComponentEditor(TppReport, TppReportComponentEditor);
ppRegisterComponentDesigner(TppDesignerW…
A component editor must be registered for the component. For an example,
check out the code in ppRegPro.pas.
--
Nard Moseley
Digital Metaphors Corporation
in After Registering "No Editor Registered For this Component" Comment by nardmoseley October 2005
Position the mouse over the DataView and press ctrl + left mouse button -
this will display the SQL statement. Examine the SQL statement and report
the SQL statement and error to Advantage tech support.
The Designer.Data…----------------------------------------------
Tech Tip: Working with Report Templates
----------------------------------------------
Whenever you save a template to an .rtm file, all of the published
properties of the Repo…