Click here to Skip to main content
16,021,004 members

Comments by drvfn (Top 4 by date)

drvfn 4-Apr-18 8:45am View    
i cant find the solution , someone can help me with this?

first is to add the page number in the PDF before its créate,
second is to group ítems by one column and when the ítem is different show this row/rows in a new page, something like group row by colum in diferent pages.
drvfn 26-Mar-18 15:20pm View    
thank you for your answer CHiLL60, the sql is 11.1 and my expected results are like:

Normal / Urgent / Descr / DthUlt / P.Idpain / IP / E.IdPan / k.Idpain
12 / 10 / tuve / 02-02-18 / 12 /10.18.1.1 / 12 / 12
0 / 1 / tuve2/ 02-02-18 / 13 /10.18.1.2 / 13 / 13
14 / 0 / tuve3 / 02-02-18 / 15 /10.18.1.8 / 15 / 15
0 / 0 / tuve4/ 02-02-18 / 17 /10.18.1.9 / 17 / 17

with your last solution i have:


Normal / Urgent / Descr / DthUlt / P.Idpain / IP / E.IdPan / k.Idpain
12 / 0 / tuve / 02-02-18 / 12 /10.18.1.1 / 12 / 12
0 / 10 / tuve / 02-02-18 / 12 /10.18.1.1 / 12 / 12
14 / 0 / tuve3 / 02-02-18 / 15 /10.18.1.8 / 15 / 15
0 / 0 / tuve3 / 02-02-18 / 15 /10.18.1.8 / 15 / 15

i hope this will be helpfull four undestand it
drvfn 26-Mar-18 13:28pm View    
Thank you CHill60, your solution Works perfect but as you said i need this in one row,
this is for a datagridvies in a Windows form application , make this will be very helpfull for me, i tryed to use case when end but i didnt find how,
drvfn 7-Jan-18 17:57pm View    
I have a textbox for make searchs in a specific column, but now i have to modify This code to add always 0000 at the start of the search for example:

I need that, If i wrote 00001234 in the textbox it would find 1234 on that column. All the numbers on my column has 4 digits, but the bar code i use to find has 8 digits becouse of that , in the search i need to add four ceros.

Please, someone can help me?