• Registered: 2014-02-14
  • Posts: 10,294

Re: Some Questions!

sonixax
Your project not attached,  you can send me your project to support@drive-software.com with link on this topic.

Dmitry.
  • Registered: 2014-10-04
  • Posts: 154

Re: Some Questions!

Hi,
Dear Dimitri I've just sent it to your mail!

  • Registered: 2014-10-04
  • Posts: 154

Re: Some Questions!

I have a problem!
I have some Categories for my products!
So I want to print some report like attached pictures!

Category1           Category2             Category3
      p1                        p1                           p1
      p2                        p2                           p2
      p3                        p3                           p3

But I don't know how can I do it sad
Is there any sample for reports for this thing ?

http://oi64.tinypic.com/sv2jvq.jpg

Thanks a lot smile

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Some Questions!

sonixax wrote:

Hi,
Dear Dimitri I've just sent it to your mail!

Please add this line

     UpdateDatabase('');

after

     login.ShowModal; // show windows for login
Dmitry.
  • Registered: 2014-02-14
  • Posts: 10,294

Re: Some Questions!

sonixax wrote:

I have a problem!
I have some Categories for my products!
So I want to print some report like attached pictures!

Category1           Category2             Category3
      p1                        p1                           p1
      p2                        p2                           p2
      p3                        p3                           p3

But I don't know how can I do it sad
Is there any sample for reports for this thing ?


Thanks a lot smile


An example for you, to change number of column on page follow to menu: File > Page Settings > Other options > Columns > Number

Post's attachments

Attachment icon Report group and 3 columns.zip 8.94 kb, 440 downloads since 2016-06-02 

Dmitry.
  • Registered: 2014-10-04
  • Posts: 154

Re: Some Questions!

Thanks a lot Dear Dimitri smile

Have another Question tongue

How can I compare to dates ?

for example I want to know how many days before my record saved!
or something like it :

if (RecordDate > 7) !

Thanks a lot smile

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Some Questions!

sonixax wrote:

Thanks a lot Dear Dimitri smile

Have another Question tongue

How can I compare to dates ?

for example I want to know how many days before my record saved!
or something like it :

if (RecordDate > 7) !

Thanks a lot smile

Where you need to show result? If you need to show result in TableGrid, you should use calculated field like this

julianday('now') - julianday(RecordDate)
Dmitry.
  • Registered: 2014-10-04
  • Posts: 154

Re: Some Questions!

Thanks a lot ,
Dear Dimitri,
I want to run a Query when main form is loaded! to find every unpaid invoices and compare invoice date with current date and if the difference is bigger than 7 set orange (A boolian field) to 1 and if bigger than 14 set red field to 1!
so I just need a loop to check them! but I dont know how can I do it in delphi sad
I mean grab every affected rows and check them one by one!

Thanks a lot smile

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Some Questions!

sonixax wrote:

Thanks a lot ,
Dear Dimitri,
I want to run a Query when main form is loaded! to find every unpaid invoices and compare invoice date with current date and if the difference is bigger than 7 set orange (A boolian field) to 1 and if bigger than 14 set red field to 1!
so I just need a loop to check them! but I dont know how can I do it in delphi sad
I mean grab every affected rows and check them one by one!

Thanks a lot smile

An example, how to change color of cell depending on the date.

Post's attachments

Attachment icon Color Grid date.zip 6.69 kb, 470 downloads since 2016-06-09 

Dmitry.
  • Registered: 2014-10-04
  • Posts: 154

Re: Some Questions!

Thanks a lot,
But dear Dimitri I Already know how can I make grid colorable!
It should be filterable by colors!
the only way is to update datas in database!
so I just need to know how can I run a query on program start to check every records and update status!
Thanks a lot smile

  • Registered: 2014-10-04
  • Posts: 154

Re: Some Questions!

any Idea dear Dimitri ?

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Some Questions!

sonixax wrote:

so I just need to know how can I run a query on program start to check every records and update status!
Thanks a lot smile


You should use event OnShow of main form.

Dmitry.