Topic: Generate Draft Contracted with databases of information.
Hi, Dmitry
How and where to register the document template for later use.
any suggestion.................
My Visual Database → Reports → Generate Draft Contracted with databases of information.
Hi, Dmitry
How and where to register the document template for later use.
any suggestion.................
Hello,
Unfortunately I can't understand what exactly you need.
I think Gilberto_Schiavinatto would like to use data stored into tables to auto-fill an official document template (contract for instance) where only some specific data are changing (name, contract number, etc...)
This is very common to use Word template using an odbc link to whether excel, access or another word document, then you just pick-up what you change and your contract is done in no time. Am I right?
tcoton
Thanks! )
Hi, Dmitry
How and where to register the document template for later use.
any suggestion.................
An example for you:
Hi Dmitry, it seems to do what Gilberto_Schiavinatto is looking for. How do you set the value1, value2 and value3 in the report? I cannot figure it out...
Hi Dmitry, it seems to do what Gilberto_Schiavinatto is looking for. How do you set the value1, value2 and value3 in the report? I cannot figure it out...
Hello,
Using the SQL query:
SELECT
(SELECT tableA.text FROM tableA WHERE tableA.id={ComboBox1}) as Value1,
(SELECT tableB.text FROM tableB WHERE tableB.id={ComboBox2}) as Value2,
(SELECT tableC.text FROM tableC WHERE tableC.id={ComboBox3}) as Value3
In the report designer:
Lorem Ipsum is simply dummy text of the printing and typesetting industry [Report."Value1"].
Pay attention to: "[Report."Value1"]"
Ah Ok, nice trick.
I got the "[Report."Value1"]" but was wondering how to set Value1
Dmitry / tcoton Ok, thank you...
Hi, Dmitry
For me is SQL novelty, I know nothing.
Please could ride SQL data exemple attachment.
The sample I sent earlier is not the current need.
Hi, Dmitry
For me is SQL novelty, I know nothing.
Please could ride SQL data exemple attachment.
The sample I sent earlier is not the current need.
Done:
My Visual Database → Reports → Generate Draft Contracted with databases of information.
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi