making a macro from a seect

View: New views
2 Messages — Rating Filter:   Alert me  

making a macro from a seect

by giovanni-36 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Sorry, I have a problem:
I must assign to a cell of a writer's table the following expression:
SELECT SUM(1+2+3+4+5+6) form costi, group by id
Someone told me to use a bookmark and a macro,but i have no idea at all
how to do.Could you help me, please?

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...


Re: making a macro from a seect

by Fernand Vanrie :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Giovanni ,

You can do this in several way's, but an easy way without using macro's
could be: starting with creating a query in the database
where("SUM(1+2+3+4+5+6) form costi, group by id") is a field. Then open
your datasource browser(beamer)  with this query and drag the calculated
field into  your texttable.
You can handle this also with making a macro, connection to the database
and then filling the texttablecell with the data coming from the
resultset created with "SUM(1+2+3+4+5+6) form costi, group by id"...But
thats easy when you can handle the basic code behind.

Hope it helps

Fernand

> Sorry, I have a problem:
> I must assign to a cell of a writer's table the following expression:
> SELECT SUM(1+2+3+4+5+6) form costi, group by id
> Someone told me to use a bookmark and a macro,but i have no idea at all
> how to do.Could you help me, please?
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@...
> For additional commands, e-mail: dev-help@...
>  


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...