Recent content by bestmakis

Thank you for your help. I will check both options and I be back to you with best option for me. Again thank you all for your help

Hi How I can create one application that get results from one MS SQL Server query compare them with one MYSQL Server query and if it is equal then do update else do insert. For example, let say I have my source sql query Select ID, FName, LName From TBNames Results: ID | FName | Lname...

Thank you all.... Both are perfect solutions....

Hi I have a table called Remote_Item with some records like Code fBaseBOMGID Description 64167 C5F2EA4A-A374-464B-A001-BBBCA2EAFF8D Ear Plugs (5 Pairs) 64082 Null Ear Defenders 27940 9CF5E211-9A1F-42EA-B26E-C6693CED200D...

Great example jebenson Thank you, it is all I need.... You the best

Hi I have one asp.net page when I pass it as a parameter one sql query return as string the result. For example if I pass a query like that in my browser: https://xxxxx.yyyyyyyy.zzz/CONN.ASPX?QUERY=select * from Trade where code = 27000003093 The result is...

Thank you for the help lbass I try what you say but it doesn't help :(

Thank you for the help. I use the With CTE SQL command and I solve the problem. You can find info here.

Hi I use crystal reports XI I try with no success to repeat the detail section as many times as a value of a field. My dataset gives me a field with a number.... let say the number 4 I want the detail section repeat him self 4 times with all the info i have in detail section. For example. If...

I want the page footer info repeated in every page. I can't move them to report info.

Sure... no problem. Here what I have until now.

I have try all that. It didn't work Just reapet the Main report as many times as many pages the sub report have to print

I try with shared variables. I didn't think that. I let you know..

I have tried that but it doesn't work. The report when inserted in the first report footer printed in the middle of the report.

The third report is getting Cash reserves info and send them to the second report witch is a receipt. The first report has the second report as sub report three times so I can get three copies of the same receipt.