nardmoseley
Comments
-
Try the following configuration:
Create a main report with no header or footer, only a detail band. Leave the
datapipeline unassigned. In the detail band place two sectiion style
subreports. Use the first to print the tit… -
It would be a nice feature, though I think quite difficult to implement.
You can manually edit the SQL and add the Having. This will disable the
linking ability. You can programmatically create the links, as shown in the
f… -
If you are performing a join, it could be related to joining in a detail
record too many times.
The other possibility is that it is related to the linking SQL.
Linking DataViews in the ReportBuilder Data workspace (D… -
The Query Designer does not support either of those. Having is a SQL
standard, but is not supported. Limit, is not a SQL standard, but I think
some database products have added support for it.
You link query dataviews, by … -
Use either Report.AutoSearchDiscription or
Report.GetAutoSearchDescriptionLines. The following code is taken from the
RBuilder\Demos\5. AutoSearch\5. Build Description of AutoSearch Settings
example:
procedure T… -
One option would be to create temp tables in the database that are populated
by the data from the .DLL. This would pretty much solve everthing.
Another option might be to to create some custom dataview templates. But
these… -
To link datapipelines in RB, the detail datapipeline must be sorted on the
linking fields.
Here is an example that shows how to define the linking relationship in
code:
in Kind of JIT Pipelines in End-User reports Comment by nardmoseley February 2004 -
I do not understand the question.
The ReportBuilder Data workspace enables the user to build queries by
selecting from any tables in the database (or if using the DataDictionary,
then the user can select any tables listed … -
Yes, it is a complex problem. The criteria used to generate meaningful joins
is going to vary based upon the techniques used by the designer/creator of
the database tables, the meaning behind the data, possibly even the database
produ… -
Correct, the DataDictionaryBuilder performs a very simplistic field
matching.
You may want to write some custom code to populate the join table entries
based upon some more sophisticated criteria.
--… -
I should have added, that once you get one of the other Interbase examples
working, then try using Firebird again.
--
Nard Moseley
Digital Metaphors
1. If you have not done so, use the CreateEndUserTables.sql script installed
to \RBuilder\Demos\4. EndUser Databases\InterBase.
2. If you still have an error, then try the end-user examples in
\RBuilder\Demos\4. EndUser Da…
Using RB's Data workspace you can visually link two queries to define a
master/detail relationship. Access the Data workspace and select the field
in the detail dataview tool window, then drag it to the linking field in the
mast…
Note: The built-in AutoSearch does not display the OR, therefore if you need
that functionality you will need to customize it - see
RBuilder\Demos\AutoSearch\Custom AutoSearch Dialog.
--
Nard Moseley
Digita…-------------------------------------------------
Tech Tip: How to add OR criteria in code
-------------------------------------------------
The 'And' operator is implied. To add an Or, Begin, End to the criteria
you need t…
Sorry, but there is no support for this in the Query tools of the Data
workspace.
You could probably create some custom dataviews that use multiple Aliases.
See RBuilder\Demos\EndUser\Custom DataViews and check out the DAD…
You will need to write some sort of import utility that the user can use to
add the reports to the database. There is nothing in ReportBuilder to handle
this for you.
--
Nard Moseley
Digital Metaphors
…
Sorry, but there is no way to do this inside the Crosstab component. Perhaps
create a summary query that can perform the calculation there.
--
Nard Moseley
Digital Metaphors
in Crosstab calculation queston Comment by nardmoseley February 2004
The query tools in ReportBuilder do not support building queries for
multiple aliases. All of the tables must reside in the same alias.
--
Nard Moseley
Digital Metaphors
in Multiple alias Comment by nardmoseley February 2004
An example of editing report templates stored in a database as text can be
downloaded from...
http://www.digital-metaphors.com/tips/EditTemp…Correct, this is a limitation of RBuilder....
----------------------------------------------
Tech Tip: Limitations of using TdaSQL.SQLText
----------------------------------------------
The TdaSQL object can contain e…
Okay, now I understand the question. Once the SQL has been manually edited
then you need to extract the TdaSQLObject and update the text. The following
example shows how to do this
in Sql with params Comment by nardmoseley February 2004
----------------------------------------------------
Tech Tips: Creating AutoSearch parameters via DADE
----------------------------------------------------
1. Access the Data workspace of the Report Designer.
<…
When a new query dataview is created, the Designer.DataSettings are saved
with the dataview as part of the definition. In an end-user application,
you will want to have all dataviews created with the same DataSettings. If
you h…
When a report or childreport is not connected to any datapipeline, you need
to also set Report.AutoStop to true. Then the report will generate a single
detail band and stop.
See the Code Based thread the Tech Tips newsgrou…
I researched this and you are correct. This technique is currently limited
to DBCalc.
I will add this to the ToDo list....
You want to consider using the summary query technique that I mentioned
above. Or perhap…
The TmyTppVariableRTTI class is no longer needed for the example. I think
that is why you are seeing SaveToCache listed twice in the code toolbox.
--
Nard Moseley
Digital Metaphors
in RAP example of Group % totals Comment by nardmoseley March 2004
One simple way to calculate this type of stuff is to create a summary query
that contains the group totals. Then you do not need two passes.
At the end of each page, the TppVariable needs to update its internal cache
with …
One way to perform calculations like this is to create a summary query that
contains the summarized totals. Then link it to the detail query and the
calculations are very simple.
This example shows another approach in whic…
Thanks for the feedback. This is something that we can work on creating.
We have a heavy work load and limited resources, therefore we may not be
able to create something immediately, but can work on it going forward as
ti…