Topic: Generate Draft Contracted with databases of information.

Hi, Dmitry



How and where to register the document template for later use.

any suggestion.................

Post's attachments

Attachment icon mvd.jpg 320.97 kb, 353 downloads since 2016-02-27 

Re: Generate Draft Contracted with databases of information.

Hello,


Unfortunately I can't understand what exactly you need.

Dmitry.

Re: Generate Draft Contracted with databases of information.

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?

Re: Generate Draft Contracted with databases of information.

tcoton
Thanks! )

Dmitry.

Re: Generate Draft Contracted with databases of information.

Gilberto_Schiavinatto wrote:

Hi, Dmitry



How and where to register the document template for later use.

any suggestion.................

An example for you:

Post's attachments

Attachment icon Report template generator.zip 6.48 kb, 685 downloads since 2016-02-28 

Dmitry.

6 (edited by tcoton 2016-02-29 09:36:01)

Re: Generate Draft Contracted with databases of information.

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...

Re: Generate Draft Contracted with databases of information.

tcoton wrote:

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"]"

Dmitry.

8 (edited by tcoton 2016-02-29 16:39:26)

Re: Generate Draft Contracted with databases of information.

Ah Ok, nice trick. big_smile

I got the "[Report."Value1"]" but was wondering how to set Value1 hmm

9 (edited by Gilberto_Schiavinatto 2016-03-02 01:01:21)

Re: Generate Draft Contracted with databases of information.

Dmitry / tcoton Ok, thank you...

10 (edited by Gilberto_Schiavinatto 2016-03-15 01:44:11)

Re: Generate Draft Contracted with databases of information.

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.

Post's attachments

Attachment icon ReportGS.zip 325.52 kb, 644 downloads since 2016-03-15 

Re: Generate Draft Contracted with databases of information.

Gilberto_Schiavinatto wrote:

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:

Post's attachments

Attachment icon ReportGS_fixed.zip 5.07 kb, 677 downloads since 2016-03-18 

Dmitry.