Show!!
Many thanks ehwagner. It worked!
Your tip helped me a lot in my project.
Thanks
51 2018-08-22 23:01:54
Re: using a "Filter" on Sql Report (4 replies, posted in Reports)
52 2018-08-22 17:09:15
Re: Calculate or count fields with text. (13 replies, posted in General)
Hi Derek
Thank you very much for your support.
That's perfect, but I can not generate a report.
Instead of adding it, it's putting the QTY in line.
I searched for a way to do it in SQL and found the CAST function ... I do not know if it would do.
Thank you
53 2018-08-21 20:50:49
Re: Calculate or count fields with text. (13 replies, posted in General)
Wow, amazing
That's exactly what I need, works perfectly. I'll use it on my project.
I'm using combobox in my project with every proc in a table ... Will it work?
Where do I learn this code that you used in the calculated field?
I had not seen him here in the forum yet.
Then I'd like to learn other ways to do that.
Many, many thanks Derek
by Google Translator
54 2018-08-21 12:58:51
Topic: Calculate or count fields with text. (13 replies, posted in General)
Hello friends.
I would like to know if it is possible to do the sum of fields with text and that gave me the result QUANT and TOTAL in numbers as shown in the image.
Each individual who receives a PROC action that will be added to the next PROC if it suffers more than one action.
I searched for a SQL code but did not find it.
Thank you
55 2018-05-07 17:39:49
Re: Tchart (6 replies, posted in General)
Great Mr. Dmitry. Hopefully it will work on my project. Thank you so much!
56 2018-04-13 14:14:56
Re: Tchart (6 replies, posted in General)
Hello Mr. Dmitry
How to make to only months or/and years?
Thaks
57 2018-03-09 17:50:19
Re: Group by with calculated field (4 replies, posted in Reports)
Hello Friend.
It is perfect.
I traded 'atendimento.id_espec' for 'atendimento.id_medico' and it stayed the way I wanted it.
Thank you very much.
58 2018-03-08 17:36:10
Re: Group by with calculated field (4 replies, posted in Reports)
Hello Friend,
I do not speak English, that's why I'm using the google translator. Sorry, I'll try to explain:
I was trying to make the report so that the records with the same 'id' summed up:
Nº MEDICO ESPECILIDADE AGENDADAS FALTAS EXTRA TOTAL
1 Medico_1 Cirugia 12 3 2 11
1 Medico_1 Cirugia 6 1 2 7
2 Medico_2 Pediatria 12 1 3 14
like this:
Nº MEDICO ESPECILIDADE AGENDADAS FALTAS EXTRA TOTAL
1 Medico_1 Cirugia 18 4 4 18
2 Medico_2 Pediatria 12 1 3 14
Thank you very much.
59 2018-03-05 18:25:24
Topic: Group by with calculated field (4 replies, posted in Reports)
Hi folks. I need some help.
I can not make a "GROUP BY" with a "CALCULATED FIELD" in the table.