Здравствуйте Stas,
Если я понимаю ваш вопрос, возможно, вы можете выполнить форматирование как часть «calculated field», используя «printf». После этого таблица будет отображаться без какого-либо дополнительного форматирования, а нижний колонтитул таблицы будет просто суммой значений столбца.
Derek.
(с гугл переводчиком)
.
If I understand your question, perhaps you can do the formatting as part of the “calculated field” using “printf”. After that, the tablegrid will be displayed without any additional formatting, and the tablegrid footer will simply be the sum of the column values.

Здравствуйте ABC52, Jean, Sibprogsistem,
Возможно, используйте это как основу для отображения даты.
С Уважением,
Derek.

1,403

(8 replies, posted in General)

Hello Amilas, Jean,
Try doing your calculated field like this (please see attached).
Derek.

1,404

(5 replies, posted in General)

Hi Joshua,
No worries - we've all forgotten to add attachments at some point LOL!
I had a quick look at 'Boundary1' and 'Boundary2' and played around with a couple of things.
It's not quite as straightforward when you have the same table being used for two different purposes (to show the 'main' state and also referencing the 'neighboring' states) so I used a bit of code just to keep everything in line (and added a couple of (optional) cosmetic things).
The attached is what I came up with which, even if it's not quite what you're after, might give you some ideas.
FYI, I changed your 'neighboring' states data slightly as you had each state being a neighbour of itself - hope that's okay.
Regards,
Derek.

1,405

(2 replies, posted in General)

Hi Adam,
Try this (see attached).
Derek.

Hi Lupo,
When you define it as MMM YYYY you are creating 2 discrete parts to datetimepicker1.
So you need to click on the MMM part of datetimepicker1 to change the month and click on the YYYY part of datetimepicker1 to change the year (clicking on the up arrow will change the month from December to January but does not change the year at the same time).
Derek.

1,407

(1 replies, posted in General)

Hi Raheel,
I'd do it like this, but there are probably other ways too.
Regards,
Derek.

1,408

(5 replies, posted in General)

Hi Joshua,
Can you add the project?
Derek.

1,409

(8 replies, posted in General)

Hi Jean, Joshua, Manixs,
If you want an image to appear as if it's inside a button, the only other way I could think of doing it is this (please see attached):
1.  Use a panel with a bevel size of 1 (so that it looks like a 'blank' button).
2.  Place an image inside the panel (the icon you want to display).
If you also want text associated with the icon, then
3.  Optionally, place a text object inside the panel (the text you want to display).
4.  Optionally, place a second label on top of the panel (NOT INSIDE the panel) and make this second label transparent.
Obviously, just an icon in the panel is pretty quick and straightforward, an icon plus text involves a couple of extra steps.
The script then simply moves the panel to mimic a button being pressed (and calls Form2).  Because the script moves the panel, the objects within the panel (the icon and optionally, the text) also move because they are subordinate to the panel.
But if you have a lot of buttons where you want to use your own icons then I think Jean's script is a much better solution.
Regards,
Derek.

1,410

(8 replies, posted in General)

Yes, that's the problem.
It's not possible to overlay an icon (or any image) on top of a button - the button is always on top.
Derek.

1,411

(8 replies, posted in General)

Hi Manix,
One way is to use an image and associate it with a (hidden) button (please see attached).
Optionally, you can move the image slightly when you click down and click up so that it behaves like a button.
But I agree, it would be better if we could simply place a customised icon on a standard button.
Derek.

1,412

(14 replies, posted in General)

Hi Stefano,
Select 'project' and then 'webgrid'  from the menu when you are in 'developer' mode (see attached screenshot).
Derek.

1,413

(17 replies, posted in General)

Hi,
Perhaps you could do something like the attached (not really tested it but the theory looks good - LOL!).
Please note you need to be using MVD v6 or above.
Derek.

1,414

(9 replies, posted in General)

Hi,
The error you are getting is because, at some point, you have deleted the 'begin' and 'end' statements from a section of the FastReport code.  These statements are needed, even if there is no code between the 'begin' and 'end' statements.  Please see screenshot 1 and screenshot 2 in the attachment.
Derek.

1,415

(3 replies, posted in General)

Hi Agusecc,
Perhaps like this (see attached).
Derek.

1,416

(9 replies, posted in General)

Hi,
1. The error you see when you try to delete an invoice is because your invoice holds data in 2 tables (dbinvoice and dbbills).  The data in dbbills is subordinate (child) to dbinvoice (parent) so you need to delete any related data in dbbills BEFORE you  can delete data in dbinvoice.  Please see screenshot1 in the zipped attachment.
2. The error you get when you try to print is because you are missing a 'quote'.  Please see screenshot2 in the zipped attachment.
3. I noticed that your 'New Invoice' button on Form 1 has a 'show form' action associated with it.  Normally you would expect this to be associated with a 'new record' action.  Please see screenshot3 in the zipped attachment.
Regards,
Derek.

1,417

(7 replies, posted in Reports)

Hi Joshua,
If I remember, it looked like the drawn line was in a group header all on its own and I think I was trying to simplify things as part of looking at your original problem and forgot to put it back - it was almost 24 hours ago so my memory is pretty hazy - LOL!  I probably lost your shaded grey background on change of store at the same time but it's straightforward to put it back in (see attached - I was also messing around with the layouts trying to improve the visual cues).
I don't really use FastReport so I can't add much to the discussion about conditional drawn objects (except to presume it can be done - FastReport seems pretty flexible) - alternate line shading is probably the only 'conditional' thing I've used.
Derek.

Hi,
Calculated fields are not held in tables, they only exist temporarily as the result of a calculation when your program runs.
In your example, 'price' is held in your invoiceline table and 'quantity' is held in your invoiceline table, but 'linevalue' does not need to be stored in your invoiceline table - it is derived by the calculation of 'price' * 'quantity'.
For this reason, If you use 'reportsql', you can't reference calculated fields because they do not exist! 
However, you simply need to replicate the formula to calculate the linevalue inside your reportsql if you need to see linevalue.
Have a look at the attachment.
Derek.

1,419

(7 replies, posted in Reports)

Hi,
I think the problem is the way you have defined the groupings for GroupHeader2 and GroupHeader3 (please see screenshot1 and screenshot2 in the attachment).
Also, in your original post, the 'desired' part of the screencapture shows John Balloon operating in Frederick MD.  However, looking at the data, that's not how it's currently held (just wanted to check I've not misunderstood something).
Regards,
Derek.

1,420

(7 replies, posted in Reports)

Hi Joshua,
Can you attach your project?
Derek.

1,421

(17 replies, posted in General)

Hi Zimguy, Hi Sibprogsistem,
Yes, also okay for me.
One thing you might check is whether the 'secondclickedit' property of the 'editable grid' is checked.  I don't believe it should make a difference but sometimes you can 'miss' the second click and so it appears that it's not working.
Please see the attached.
Derek.

1,422

(2 replies, posted in General)

Hi Manix,
Perhaps try it like this (please see the attachment).  A list for displaying / hiding other options is at the end of the script.
Regards,
Derek.

1,423

(11 replies, posted in General)

Hi Sibprogsistem, Hi Thezimguy,
I think the problem that has been identified is that in previous versions of MVD, you didn't have to use a script and so it was much simpler - you could set the sort sequence of the combobox just by using the 'filter' property (see attached screen shot).
I've had a quick look and I can't think of any easy solution.
Derek.

1,424

(9 replies, posted in SQL queries)

Hi Agusecc,
Does this help you?  (the combobox selection only shows those subjects that have not already been chosen by the specified student).
Regards,
Derek.

1,425

(10 replies, posted in General)

Hello Eyeman
Happy New Year to you too.
I think your problem lies with your data,  There are records in AA_001_REC_PATIENT_REG and AA_005_REC_BILLING with missing foreign keys and missing data (please see the screen shots in the attachment).  Or use something like SQLITESTUDIO to have a look at the raw data and you will see the problem.  If you delete these records, you no longer get the error.
Why the data had missing key information is, of course, the more important issue (although perhaps it was just test data you were using and that's why it's incomplete - let's hope so).
Regards,
Derek.