nardmoseley
Comments
-
Create a simple, minimal example that we can run here. Use standard Delphi
components and RB. Use DBDemos or create some MS Access or paradox data that
we can run here. Send in zip format to support@digital-metaphors.com.
-------------------------------------------
Tech Tip: Database Collation and Linking
-------------------------------------------
Overview
---------
Linking DataViews in the ReportBuilder Data workspace (DADE), re…
There are no known issues with the SuppressRepeatedValues feature in RB
9.01. I created a couple of examples using DBDemos but cannot recreate the
issue. Please create a simple example, using standard Delpi components, RB
and…
Based upon your description I understand that
- The RB application is running on the citrix server
- The Universal Printer Driver is installed on the citrix server
- RB cannot print to the driver
1. Make sure th…
Add ppTypes to the uses clause.
--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com
The DataDictionary has been tested with the Delphi ADO components that are
included with Delphi. Please see RBuilder\Demos\EndUser Databases\ for
examples.There are ReadMe.doc's included. Make sure that you use the SQL
script…
1. You can use the new Report.OnInitailizeParameters event to define the
autosearch parameters that you want to be displayed. Then in the
Report.OnGetAutoSearchParameters event you can access the values entered by
the user an…
Thanks for supplying those tips and sharing your Oracle expertise
--
Nard Moseley
Digita…
1. For end-user examples using Oracle, check out RBuilder\Demos\EndUser
Databases\Oracle. There are examples there for BDE, dbExpress, and DOA
(Direct Oracle Access).
If you are using Oracle and Delphi, I recommend that …
PrintPosRect is in microns. For an example, check ppMemo.pas, the method
CalcSpaceUsed.
--
Nard Moseley
Digital Metaphors Corporation
http:/…
1. If you are using the BDE for database access, then try increasing the BDE
settings for MaxBlobSize and BlobsToCache.
2. As a test try removing the midas layer and test a simple client to
database server solution. Once…
Please do not cross post messages. This message has been answered in the
DADE newsgroup.
--
Nard Moseley
Digital Metaphors Corporation
http://www.digita…
1. The ClientDataset has support for XMl
2. If you want to bypass the client dataset, you could create a custom
XMLDataPipeline. (You might also be able to use a JITPipeline, but that
would require that implement event-h…
This is not a known issue, so I am at a loss as to what to tell you. If it
happens, access the report designer, select the Data workspace, and then
select File | DataSettings to check how they are configured.
The Designe…
Make sure that you have DataDictionary.UseTableOwner set appropriately. In
most cases this should be set to false. See the RBuilder.hlp file.
Perhaps you have some reports that use a different database connection than
ot…That should work, its probably a timing issue. The Designer delays the
creation of the toolbars until the window is shown. See CreateToolbars and
SafeCreateToolbars methods in ppDsgner.pas. We had to delay creation to
avoid AV's - …
1. Select the View | Toolbars | Report Tree menu options to show the report
tree tool window.
2. The Report Tree can be docked to the left side of the designer by
dragging over the left edge until a docking rectangle is …
The code for the TppReportExplorer.Print method looks like this:
LoadReport(aReportName, aFolderId);
FReport.DeviceType := dtPrinter;
FReport.Print;
Thus, your OnLoadEnd settings ar…
1. To customize the report designer menu, use the TppDesigner.Menu property
to access the main menu and its subitems.
2. Simplest way to provide a default configuration for the report designer,
is to configure it as an e…
For future reference please post server related questions to the server
newsgroup.
The Server Developers Guide contains step by step tutorials for building a
server, client, and webtier application. If you have not worke…
The WebTier includes support for rbWebTier.ini, however the Server does
support an .ini file.
My guess is that there is an issue with the database connection component.
--
Nard Moseley
Digital Metap…
Do not call ReportExplorer.Execute from the DataModule.Create method.
Instead add a TDataModule.ExecuteReportExplorer method that which calls
ReportExplorer Execute. Also, rather than use the OnClose event to set
caFree, simp…
You can access the TppAutoSearchField via the SearchPanel.AutoSearchField
property.
The AutoSearchField TableName and TableAlias properties provide info about
the table name.
--
Nard Moseley<…
No.
I suspect there is modal dialog being shown somewhere. Delphi does not
handle window layering when task switching amongst applications.
Try adding an event-handler to the Application.OnActivate event that always…
Synchronize will remove any tables and fields that no longer exist in the
database. It basically checks over all of the DataDictionary entries and
verifies whether the table and fields exists in the database.
Generate wi…
Some observations:
1. The TdaSQL.SQLText property provides access to the SQL text (MagicSQL is
used internally when generating linking SQL).
2. If you originally used the Query tools to build the queries, then you <…
There is no limit. You are encountering something else.
It might be related to the data. I assume you have linked dataviews that are
also four levels deep.
1. As a test, try unlinking all of the dataviews. Then tes…
1. As a test comment out all event-handler code associated with the report.
You may have code that is executing more often than you think. For example
the Report.BeforePrint event fires once for preview and again for printing
Below is an example that uses the older technology.
http://www.digital-metaphors.com/tips/ExtractSQLObject.zip
-- <…
One option is to use the BeforeAutoSearchDialogCreate to set
Report.ShowAutoSearchDialog to false.
RB 9 includes a new TdaSQLBuilder class that provides a runtime interface
for manipulating the TdaSQL object programmtica…