Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hatemgamil

    Sorting in Crystal report when supressing group header

    my conditoin based on a paramter IsAccOfficerChecked and i put it in grp header and footer section as a supress condition to hide both header and footer if it's false and show them if true.. My problem that i am having a group by AccOfficerName field and i am sorting with forumla. Every thing is...
  2. hatemgamil

    Sorting in Crystal report when supressing group header

    i have grouping in my cyrstal report with Field AccOfficerName and i am sorting inside the group using a formula.i am using a supress condition to supress the group header and footer to disable showing group based on a paramter. My question is how can i sort when supressing the grp header and...
  3. hatemgamil

    String is Reversed

    Dear All,, i have an issue when adjusting the reading order to 'Right to left' and having a string in a formula like that '??? ??????: + 202 3535 707' the numbers in this string is reversed when populating the report .. can you please help me with this Thanks
  4. hatemgamil

    exporting data from sql server to Ms access

    i know i can import data using Ms Access from sql server ,,but i wanted to know how can i do it using a file.. thnx simi
  5. hatemgamil

    exporting data from sql server to Ms access

    greetings hi wana know how can i export data from table on sql server to MS access through SQl job i am using sql server 2008 and Ms access 2007 thnx
  6. hatemgamil

    exporting xml from sql server

    thnx bugslayer can u please give me more details about bcp i mean an example thnx
  7. hatemgamil

    exporting xml from sql server

    Greetings lets say i have a table Employee like this EmpID,EmpName 1 ,hatem and i write a query that select * from Employee for xml auto so the out put will be in xml format i want some help to know how can i export the result to a xml file to be saved on my computer as i need to read...
  8. hatemgamil

    how to get old/new guid of a row?

    thnx bugslayer for ur answer ,,ur query works so fine
  9. hatemgamil

    how to get old/new guid of a row?

    Greetings ,,, i have read about guid recently and i found that it helps to find the version of a row now lets say i have a row with columns empID,,EmpName and a row 1,hatem if that row is updated then we will have a new version of this row ,,so it will have 2 GUIDs old & New i want...
  10. hatemgamil

    Sql Server Service Broker

    Greetings,, i want to make bi-diretctional replication between 2 databases each is one sql server instance,,after searching for the best way to do bi-directional replication i found that i can use service broker to exchange messages between 2 databases ,,but i have a question about conflict...
  11. hatemgamil

    Bi-directional Replication Confllct

    Greetings,, I have 2 servers where i want to setup a bidirectional transactional replication setup.and i want to do know how can i handle conflicts and resolve them .conflicts like: 1-If you insert a record that has a key into a table on one of the servers and another record that has the same...
  12. hatemgamil

    Bi-Directional Transaction Replication

    i want some help to know about Bi-directional Trans Replication,,,how does it works and how to cinfigure it on msmm and how to detect and resolve conflicts thnx
  13. hatemgamil

    Bi-directional Replication

    thnx BugSlayer for ur replu,,i need some data about conflict in p2p replication and how to resolve that conflict i know in sql server 2008 enables to detect conflict but i want to know how can i merge if conflicts occurs or what is the best practise to deal with that conflict thnx
  14. hatemgamil

    Bi-directional Replication

    hi all i want to know Bi-Directional Replication in sql server 2008 and how to solve conflict and what kind of replication that supports bidirectional rep. so anyone has tutorials ,articles ,demos or anything related to that topic please share thnx
  15. hatemgamil

    create a bullet list in a field

    thnx all thnx lbass i did what u sent and it works perfectly
  16. hatemgamil

    create a bullet list in a field

    i have did something that gives what i am looking for creating a formula "• "&replace({dt.MainCauses_En},',',chr(13)&"•") chr(13) which means Enter button but the problem in this solution that it adds a bullet like this: •brake defect •wrong signal •kkkllkl •dsd •
  17. hatemgamil

    create a bullet list in a field

    hi all i have a field name "Main Causes" and it's value in my report always looks like that Main Casuses --------------------------------------- brake defect,wrong signal,kkllk,dd i want to make it looks like a bullet list •brake defect •wrong signal •kkkllkl •dsd i want some help to do so thnx
  18. hatemgamil

    how to get summary for HH:mm field???

    thnx IanWaterman for ur valuable post it works fine ,,i will edit ur answer after fixing syntax errors : create a new Formula Field: @min tonumber(left({dt.DelayTime},2)) *60 + tonumber(right({dt.DelayTime},2)) then create another one @Total: local numbervar Days:=0; local numbervar Hours :=...
  19. hatemgamil

    how to get summary for HH:mm field???

    i think u mean (tonumber(left(DelayTime,2)) *60) +(tonumber(right(DelayTime,2))
  20. hatemgamil

    how to get summary for HH:mm field???

    @mins (tonumber(left(DelayTime,2)) *60) =(tonumber(right(DelayTime,2)) i got and error when creating this formula

Part and Inventory Search

Back
Top