Здравствуйте 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.
1,401 2020-01-30 17:48:07
Re: количество знаков после запятой (например, деньги) (5 replies, posted in Russian)
1,402 2020-01-30 11:29:20
Re: Определение дня недели weekday() (6 replies, posted in Russian)
Здравствуйте ABC52, Jean, Sibprogsistem,
Возможно, используйте это как основу для отображения даты.
С Уважением,
Derek.
1,403 2020-01-22 19:52:41
Re: help (8 replies, posted in General)
Hello Amilas, Jean,
Try doing your calculated field like this (please see attached).
Derek.
1,404 2020-01-21 14:43:03
Re: Parent ComboBoxes (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 2020-01-20 18:47:28
Re: Inserting date and time... (2 replies, posted in General)
Hi Adam,
Try this (see attached).
Derek.
1,406 2020-01-19 16:41:12
Re: Possible Error Datetimepicker or am i doing something wrong ? (2 replies, posted in General)
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 2020-01-19 15:55:47
Re: sqldatetime (1 replies, posted in General)
Hi Raheel,
I'd do it like this, but there are probably other ways too.
Regards,
Derek.
1,408 2020-01-19 10:28:03
Re: Parent ComboBoxes (5 replies, posted in General)
Hi Joshua,
Can you add the project?
Derek.
1,409 2020-01-18 00:16:33
Re: Button, Form Icon (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 2020-01-17 10:23:16
Re: Button, Form Icon (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 2020-01-17 10:03:11
Re: Button, Form Icon (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 2020-01-15 14:27:27
Re: database online (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 2020-01-14 21:57:31
Re: [SOLVED] TableGrid Events not working (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 2020-01-14 10:38:37
Re: form error (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 2020-01-14 10:18:31
Re: get value from filter . (3 replies, posted in General)
Hi Agusecc,
Perhaps like this (see attached).
Derek.
1,416 2020-01-13 11:36:21
Re: form error (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 2020-01-12 17:29:10
Re: Help with report grouping (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.
1,418 2020-01-12 14:57:14
Re: Show child rows depending on focus in mother table (6 replies, posted in SQL queries)
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 2020-01-11 20:21:55
Re: Help with report grouping (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 2020-01-11 18:03:26
Re: Help with report grouping (7 replies, posted in Reports)
Hi Joshua,
Can you attach your project?
Derek.
1,421 2020-01-11 18:02:02
Re: [SOLVED] TableGrid Events not working (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 2020-01-10 12:16:49
Re: Settings (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 2020-01-06 19:53:44
Re: [SOLVED] Combobox Filter & TextHint Problem (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 2020-01-05 19:00:56
Re: filter tablegrid by sql query (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 2020-01-05 16:34:46
Re: Invalid character error (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.