nardmoseley
Comments
-
I do not recall there being any variable issues with RB 7.04.
For calculations, make sure that you use TppVariables and the
TppVariable.OnCalc event to perform the calculation. As an example, check
out the RAP demos.
There is not a way to catch an exception in RAP. Therefore, I suggest
creating a pass-thru function that returns a boolean indicating a successful
load. Define a function that takes two parameters: the TppImage object and a
f…
This message has been cross posted, refer to the Devices newsgroup.
Please do not cross post messages. TIA
You could do that also - connect the subreport to the same datapipeline.
Each report/childreport will traverse the datapipeline to which it is
assigned.
I was originally thinking of creating a second SQL query that summa…
One way to do this is to use SQL to create a summary query that contains the
grouped calculations. Then use a subreport in the summary band. The
subreport can traverse the summary query and generate the results.
------------------------------------------------------
Tech Tip: Calculating a Summary based on Group Totals
------------------------------------------------------
Question: I am using a Variable in the Group Footer to con…
Check the Help | About box of the report designer to determine the exact RB
version that you are using.
When I test using RB 9.03, RAP recognizes the TdaSQLBuilder.ApplyUpdates
method. This is method was not exposed to R…
I tested here using RB 9.03 and was able to get it working.
RB 9.03 recognizes the TdaSQLBuilder. ApplyUpdates method in RAP.
The call to ApplyUpdates is necessary to force the SQL to regenerate (I
tested with and w…
The available DataPipelines are shown in the RAP Code Toolbox. The name
displayed for each pipeline is the value of the DataPipeline.UserName. RAP
supports a special syntax in which you can use the UserName directly in your
c…
ReportBuilder 9 includes adds a new TdaSQLBuilder class that can be used to
modify the SQL associated with a datapipeline. There is a new
Report.BeforeOpenDataPipelines event that can be used to modify the SQL
prior to the da…
My thought was that you could use the OnGetAutoSearchValues event to open
the first pipeline:
myPipelineA.Open; // open first pipeline
{ add more code here..}
Try using the Report.OnGetAutoSearchValues event. It fires after the user
has entered the autosearch value and before the datapipelines have been
opened.
There were no major changes made for RB 9.03. Perhaps you have a corrupt
installation. See article below.
Try the following test:
1. Test at Delphi design-time
2. Test at run-time (.exe)
3. Tes…
I would try using the AddByIndex method. Once you add the Calc field I think
it will become the last field in the available list.
liCalcField := lSQLBuilder.OrderByFields.AvailableCount-1;
lSQLBuilder.OrderByFields.…
Try setting Report.CachePages to True and in your event-handler code check
if Report.FirstPass then
begin
end;
1. Try removing the 'var' from the RAP function signature for DrawLineCMD.
2. Modify the Delphi library path to include RBuilder\Source and trace in
the debugger
3. If you still have an issue, create a simple exampl…
Its going to simpler to code a few RAP pass-thru functions.
However, if you want to extend the RTTI you need to add support for any
public properties that you wish to access (only published properties are
supported by de…
By default, not all of the properties and methods are exposed to RAP. You
can easily extend RAP, see the following article.
--------------------------------------------------
Article: Extending RAP
-----------------…
For the Delphi IDE a new component is added by installing a package. For the
runtime designer, a new component is added by adding a reference to the
'uses' clause. (see article below).
Open the form upon which the TppDes…
Sorry, there is no built-in feature to skip records. You can modify the SQL
to select the records that are applicable. Another solution is to use the
detailband.BeforePrint event to toggle the DetailBand.Visible property.
There is no way to control the detail SQL for each master record, that is
not how the Data workspace linking is implemented. The Data workspace linkes
the datapipelines and generates special linking SQL for the detail dataview.
Make sure that Transparent is set to False, When Transparent is set to True
(the default), the Color will never be used to render the element.
Try this...
- exit out of Delphi
- delete RBuilder.ini from the Windows directory
- restart Delphi
Internally variants are used. Perhaps there is limitation on the length of
variant strings. I tied to search for information about this but did not
find anything.
RAP supports TStringList. One solution might be to pass a…
Pagination is determined during the first pass, therefore a two pass report
will not provide a solution.
One option might be create a summary query that performs the calcs using SQL
Another option is to pre-process …
For simplicity I recommend that you test this report in a non-server
environment (that should provide the same calc resutls).
I checked back at bug fixes and there is a fix to TppVariable that was made
for RB 9.03 and is…
The global variable is likely the cause of the problem. Accumlations need to
done by TppVariabl components.
The TppVariable components have the ability to save/restore intermediate
results between pages. A global variabl…
It is hard to diagnose the issue from the description alone. Is this a
simple report, or a report that includes subreports? Is the variable in the
main report or a subreport?
If possible, please create a simple exa…
This is a bug in RB 10, please send an email to
support@digital-metaphors.com and request the patch.
a. One option is to use TraProgram.BodyText to read and write the constant
declarations. For the global constant program, that BodayText string will
return the entire declaration as a single string.
const
myFirstC…