• Registered: 2018-12-05
  • Posts: 41

Topic: Store name in all Forms and Report

Hi,

1. I need to have a form that will make me enter my store details
2.Then the details should automatically appear on all of my forms (but not on a table grid), just texts (or best if with logo).
3. Then the details should also appear automatically on the fastreport as header.

4. Then if i change the details in the Details Form, so will the data in all the forms and fastreport too.

I'm no programmer. how to do this?

Thanks!


Anakin

Post's attachments

Attachment icon 6.jpg 118.95 kb, 111 downloads since 2020-06-01 

---may the force be with you!
  • CDB
  • Member
  • Offline
  • Registered: 2019-12-16
  • Posts: 370

Re: Store name in all Forms and Report

I'm not sure about the reports part, but for your forms you could read the contents of your database into a TStringlist or a memobox and then display this on each form.

On a clear disk you can seek forever
  • From: Gotham City
  • Registered: 2017-12-31
  • Posts: 406

Re: Store name in all Forms and Report

Use script in Designer's Pascal Code

Memo1.text := SQLExecute('select Name from Store where id = 1');
Memo2.text := SQLExecute('select Address from Store where id = 1');
Memo3.text := SQLExecute('select Contact from Store where id = 1');

  • Registered: 2018-12-05
  • Posts: 41

Re: Store name in all Forms and Report

Hi,

I don't know where to start with your ideas. Not a programmer.
Can anyone post a sample project like this? thanks


Anakin

---may the force be with you!

5 Reply by derek (edited by derek 2020-06-01 18:47:37)

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,675

Re: Store name in all Forms and Report

Hi Anakin,
Please take a look at  couple of suggestions (see attached).
Anakin2
In this option, click on the image on the first form and you can change the company information and company logo.  There is a small amount of script involved but all you need to do is copy the relevant lines for every new form that you add to your application.
Anakin3 (the non-script option)
In this option, the changes are done totally outside of MVD, simply using an image editor (think of it as creating a 'business card').  Then save your 'business card' and (in this example,  rename it to mylogo.jpg).  After that, just recompile your application and the company details and logo on the new 'business card' should be displayed; in this example, there are 2 'business cards' that are in the /images folder).
Hope this gives you some ideas,
Derek.

Post's attachments

Attachment icon anakin.zip 1.74 mb, 278 downloads since 2020-06-01 

  • Registered: 2018-12-05
  • Posts: 41

Re: Store name in all Forms and Report

CDB, blackpearl8534, derek,

Thanks for your help, will check your suggestions!


Anakin

---may the force be with you!