Search results for query: *

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...

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...

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

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

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

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

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...

thnx bugslayer for ur answer ,,ur query works so fine

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...

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...

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...

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

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

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

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

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 •

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

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 :=...

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

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