Search options (Page 74 of 104)

Hello,
Please find attached a sample program that uses an auto-generated number that shows on all forms and in a report.
I've done this in 1.44 so you should be able to open it and see what's going on.
If anything's not clear, then just ask and someone will know the answer.
Regards,
Derek.

Hello Reteinformatica, Thierry
Another way to approach the problem:  in the attached example, the second date field is automatically set to be 30 days ahead of the first date field;  this is done with a small (1 line) script. 
Is this the sort of thing you were meaning?  Even if not, it shows one approach you could take.
Regards,
Derek.

Hi,
Welcome to MVD.
Basically, if your amortization calculations follow set rules, then MVD will be able to calculate the monthly payments;   typically, you'd achieve this by using 'calculated fields' or by using MVD's coding script.
Derek.

Hi Anakin,
I hardly use Fast Report but I had a quick go at creating a 'salary slip'.
I'm sure you'll want to change the layout to better suit your own requirements but the data is all there and the figures seem to add up, which is the main thing that I was concentrating on!
Regards,
Derek.

Hi Eddie,
I'd probably try and do it something like the attached, using the same lookup (tags) table for however many tags I wanted to hold against the website and then concatenate the tags into a calculated field to use for my search.
Derek.

Hello Anakin,
Attached is an update of the project with the 'basic pay' showing as a discrete column.
A couple of other changes:
1)  all the numeric column headings, cells and footers are now right-aligned.
2)  the 'search' field accepts first name, last name, payroll id or position (basically, anything that you can see in tablegrid1 you can search on).
Hope this enables you to move things along a bit.
Derek.

Привет,
Надеюсь я правильно понял ваш вопрос (гугл переводчик).
Возможно, вы могли бы сделать это так? (смотрите вложение). Нажмите «01», «02» и т. Д., Чтобы выбрать или отменить выбор. Кроме того, поместите мышь на «01», «02» и т. Д., Чтобы увидеть «подсказку».
С Уважением,
Derek.

Hello Again,
Немного другой способ (лучше?) - меньший скрипт и меньше столбцов, которые можно скрыть в таблице, так что, может быть, более эффективный?
Derek.

Hi Anakin,
Had a quick look at your warehouse spreadsheet.
I've made a few (well, a lot actually - LOL!) assumptions but I'd probably tackle it this way (please see attached).
I've used 'weighted average' for valuation of stock and have associated items with a specific warehouse location rather than allocate the location on delivery (it doesn't have to be that way but I'm guessing you'd hit problems taking an item from different locations on the same dispatch note).
Again, a small script but it's only cosmetic (and it would work just the same without it).
Anyway, hopefully you can use it as a bit of a guide, if nothing else.
Regards,
Derek.

Hello Anakin,
I had a quick look at your project and made a few changes.
Of course, it's based on my understanding of what you're trying to do so some of what I've suggested may be invalid.  But at least it may give you some ideas.
In your data structure, you had relationships going in both directions between tables (many:many relationship) but I don't see that being needed with your data.  Also, you had a couple of currency / value fields defined as 'integer' (so these would only have displayed whole numbers rather than the precision (normally 2 decimal places) you need).
With some of your forms that hold 'lookup' data  (which in your project is pretty much everything except the 'service' and the 'article's tables), it's probably easier to set those up as 'editable grids'.  Even the 'asset' table itself is being used just as a 'lookup' for the Maintenance Department, as I understand it.  I've grouped all of these together on just one form (which should make your project slightly quicker to load).
Other than that, I've just used the standard MVD approach of listing all 'service' records in a tablegrid and maintaining individual 'service' records on a discrete form.  And likewise for the 'articles' table.
Unfortunately, your report is messed up a bit now but than can be corrected once everything else is set up as you want it.
Lastly, there is a small script to initially 'click' the search button (now hidden) on Form1 but that's really just a cosmetic thing.
Again, apologies if some of my assumptions for what you're after are wrong but at least the approach might show you a way to proceed.
Hope this helps,
Derek.