Change a calculation before printing a report - RBCalculations.png (0/1)

rbuser

Hi,

RB 15.02
Not sure if this is the right newsgroup.
I would like to change the value of a calculation (see attachment) of
a report before it is printed. This has to be done in code.

The general idea is that the user will load a report and based on
specific choices that they have made we can change the underlying
calculations.

In the exampel screenshot we would for example chane the function of
calc_1 to (select count(*) from customer where company like 'F%')

Is this possible?

regards
Paul

nicocizik

Hi Paul,

For future reference, we do not permit adding attachments to newsgroup
messages. If you would like to send a file, please send it to
support@digital-metaphors.com with a short message referencing the
newsgroup post.

The best option for altering DADE data queries from Delphi is to use
Report Parameters.

See the following article on parameter fundamentals.

http://www.digital-metaphors.com/rbWiki/End-User/Fundamentals/Report_Parameter_Fundamentals


Also, see the following articles on how to use the SQLBuilder to
create/edit DADE queries in code. There is also extensive documentation
in the RB help.

http://www.digital-metaphors.com/rbWiki/DADE/SQLBuilder

rbuser

Hi Nico,

I don;t think report parameters is what we need. I send an e-mail
message containing a screenshot that hopefullt will make it clearer.

We have a bunch of calculations that will do a select count , or a
complicated SQL case statement. We need to change all or some of these
before printing tehe report.


On Fri, 15 Jan 2016 07:56:47 -0700, "Nico Cizik (Digital Metaphors)"