My fan

hi, a quick one, due change servers soon, , wondered on strategy companion analyzer if there way bulk change connections rather having go into 100's of reports manually , change server name.  in example we are moving chh-bilive server. i don't know strategy companion analyzer, in visual studio possible find/replace on server name code property can find in code view. SQL Server  >  SQL Server Reporting Services, Power View

hi my package running file. downloading file, import in database , processes.   problem occures when there no file on ftp ssis failed , give me message "an error occurred in requested ftp operation. detailed error description: connection server not established  .  end error  error: 2014-09-12 02:30:41.29     code: 0xc002918f " regards shahid you can use script task before looping task , check if ftp folder has files. based on can set value boolean variable 9say @[user::fileexists]) link script task loop using expression based precedence constraint ie use option expression , constraint, set constraint onsuccess , expression as  @fileexists == true and not throw error. please mark answer if helps solve issue visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/vmblogs SQL Server ...

hey guys, i have project, contains silverlight-enabled wcf service, , working fine, can use service retrieve data silverlight app fine, but im wondering if there way listen event in service, when special method called in service, service delivers data silverlight. actualyl need way service contact silverlight :)    hope has example or advice. hi, you can visit blog http://blogs.msdn.com/bobfamiliar/pages/rich-internet-applications-ria-s-using-silverlight-2-0-part-2.aspx thanks hitesh if answer que plz mark answer Silverlight  >  Programming Silverlight with .NET – General

hi want give path animation. i want move circle on outer circle border. please suggest have to i'm not sure if easiest way, i'm open constructive critisism... i've illustrated button inside usercontrol called page, vs default ... c# code // setting dependency property  private readonly static dependencyproperty angleproperty = dependencyproperty.register(             typeof(double), typeof(page), new propertymetadata(onvaluechange));         public double angle         {             get{ return (double) this.getvalue(angleproperty);}             set{ this.setvalue(angleproperty,value);}         }   // transforming         private s...

i've been dealing permissions keep changing objectsid. reported in dfs gui i'm able run cmd "dfsutil property acl \\dfsroot\share" on server and returns correct group names instead of generic sid seen in gui (s-1-5-21-<domain>-2). i've looked here ( http://msdn.microsoft.com/en-us/library/cc980032.aspx ) , don't see appended "-2", itself, anywhere. knew wouldn't find anyways due fact occurring on multiple folders under namespace , giving same objectsid each time... machines having issue new 2008 r2 sp1 boxes new 2008 namespace. i've applied hotfix  http://support.microsoft.com/kb/2464365 these boxes no change in behavior. sysadmin bryan ciaraldi hi, posting in microsoft technet forums. trying involve familiar topic further @ issue. there might time delay. appreciate patience. thank understanding , support. regards. we trying better understand customer views on social support experience, participation in ...

we updated user office 2007 o2010 uninstalling o2007 , installing o2010.  user had custom dictionary set and located on network home drive.  see custom dictionary in dictionary list word recognize of entries listed in dictionary when spell checking. when open custom dictionary see contents its in jibberish.  when open original default dictionary can see words.  custom dictionary corrupted if how can uncorrupt. thanks! when open custom dictionary see contents, opening from: c:\users\<user name>\appdata\roaming\microsoft\uproof.  once there, open custom.dic fil , see if displays correctly in notepad? if not viewable correctly there, word cannot see correctly either. if add word custom dictionary, word show correctly? please remember click “mark answer” on post helps you, , click “unmark answer” if marked post not answer question. can beneficial other community members reading thread. thanks! adri...

have 2000 server , when remote connect using pcanywhere , try open website, address bar begins enter "=" sign , not let me type anything.  not happen if enter url directly web browser, when use laptop pcanywhere server. any appreciated. thanks. hello,   i highly suggest contact symantec efficiently resolve problem, because seems related pcanywhere , in better position able assist this. sorry have little knowledge on pcanywhere , may not offer correct information on this.   thank understanding , hope resolved soon.   best regards, chang yin Windows Server  >  Windows Server General Forum

i plan upgrade office 2003 on our windows 2008 terminal server / citrix server. have 2003 volume licensing , 2007 volume licensing available, plan upgrade 2003 install 2007. on terminal server, there need aware of? can upgraded or recommended 2003 uninstalled , 2007 installed. user settings etc? thanks in advance hello as it's nice have test-environment test these kind of thing :) usually there shouldn't issue direct upgrade, should aware of any 3. party plug-ins , whether these compatible office 2007 or not, otherwise may run lot of trouble :) if users have outlook profiles, these upgraded during logon, once done, there no way back. meaning that the outlook profile no longer used in outlook 2003. other can't see other issues. maybe should let thread open day or two, there might other people who are willing share experiences direct office 2003 upgrade Windows Server ...

hi, current cluster using storage a. have planned migrate storage storage b while retaining cluster environment. possible doing d2d data in storage? impacts on production environment , cluster itself? re-installation of cluster needed in case point new storage b? *storage , storage b both san storage. yes, possible migrate new storage...but must ensure copy on disk signature storage storage b. russ kaufmann wrote nice overview of proceure here: http://msmvps.com/blogs/clusterhelp/archive/2005/08/05/moving-a-cluster-to-a-new-san-original-posted-jul-22-2005.aspx visit blog multi-site clustering - http://msmvps.com/blogs/jtoner Windows Server  >  High Availability (Clustering)

hi technet, i not deep dns , got research request 1 of colleagues: we planning automated deployment of virtual machines , have following problem, regarding dns registration: example: we deploy single vm (lets call dummy) 2 nics, 1 our administrators anic(admin-nic / dhcp) , 1 users cnic(corporate-nic / dhcp). the vm can access our dns through anic, automaticly register ip of it's anic, not cnic. or worst case: both! the problem is: users can access vm through cnic. if dns entry not available - or if can toggle between anic , cnic in dns, because of round-robin resolution multiple entries - our users go crazy. is there way manualy (with script?) register cnic ip through anic connection? possible questions side: why don't use static dns entries? --> talking automated deployment , deletion of 100+ vms. want automate process , save time our administrators, not create more. why don't give cnic access dns? --> corporate network security restric...

i m using last build of windows 10. when click on disconnect in users , accounts - profile nothing happends. add user doesn t work. tried in safe mode , there adding users working there no option disconnect user. idea solve it? :) you can try fix windows corruption errors using dism or system update readiness tool . remember report bug in feedback app. best of luck, hessam windows outreach team- pro windows pros on technet Windows 10 Insider Preview  >  Windows 10 Insider Preview Feedback

hi, i have hyper-v cluster 2 nodes. storage in netapp. my vms in 2012 r2 et 2008r2. network card same vms. of vms slow. when make copy of file, copy @ 10mo/s. not vms. i see when copy file in vms not slow, have cache memory : but not on slow vms : regards. try this, on nodes/host servers: 1. set power options "high performance" 2. disable vmq 3. check settings of vm (network adpater) in failover cluster manager bandwidth management 4. install hyperv recommended hotfixes (optional) Windows Server  >  Windows Server 2012 Setup

hi there, i getting error continuously : the windows log on process has unexpectedly terminated. server configuration is os:windows server 2008 standard edition 64 bit service pack 2 if have solution pl. share yogi hi yogi, thank posting in windows server forum. error might caused 1 of following conditions:  •  system resources inadequate or unavailable. •  the windows registry corrupted. •  a service failed start. please check below article solution implement in case. event id 4005 — windows logon availability  http://technet.microsoft.com/en-us/library/cc734097(v=ws.10).aspx hope helps! thanks. dharmesh solanki Windows Server  >  Remote Desktop Services (Terminal Services) ...

hello everyone,   we have shared folder on windows server 2003 r2 sp2 standard edition. noticed files copy on not aligned. try explain: overwrite file on our shared folder, example sample.doc; when colleague try open it, see old 1 , not new 1 overwritten.   could me resolve problem: know information not detailed, behaviour.   -- regards,   marco mangiante i tested that, , not see behaviour, using 2003-r2-sp2 file server , windows 7 clients (1 copying new file, , 1 opening copied file) are sure not using "offline folders" or dfs or other additional tool filesharing ? Windows Server  >  File Services and Storage

hello i'm trying configure email alerts tfs whenever "send test email" following error.  this log file in error says. [info   @05:07:35.833] ==================================================================== [info   @05:07:35.833] team foundation server administration log [info   @05:07:35.833] version  : 12.0.30324.0 [info   @05:07:35.833] datetime : 01/27/2015 10:07:35 [info   @05:07:35.833] type     : configuration [info   @05:07:35.833] activity : settings [info   @05:07:35.833] area     : applicationtier [info   @05:07:35.833] user     : win-nobgfm4gtaf\administrator [info   @05:07:35.833] machine  : win-nobgfm4gtaf [info   @05:07:35.833] system   : microsoft windows nt 6.1.7601 service pack 1 (amd64) [info   @05:07:35.833] ==================================================================== [error  @05:09:20.580]  exce...

i'm looking powershell script remove logon scripts (scriptpath attribute) user profiles in given ou (and child ous). in advance. a powershell script similar vbscript solution posted in other forum follows. partially tested:   $ads_property_clear = 1 $ou = [adsi]"ldap://ou=west,dc=mydomain,dc=com" function clearscriptpath($parent) {     foreach ($child in $parent.get_children())     {         if ($child.class -eq "user")         {             $child.putex($ads_property_clear, "scriptpath", 0)             $child.setinfo()         }         if ($child.class -eq "organizationalunit")         {  ...

i've been playing these few lines of script while no success. i believe issue in syntax of directory paths trying replace. can point me in right direction. script @ bottom self explanatory in case - want able change directory path of default queue database in exchange 2010. script reads line line content of config file looking $current , should replace $new. any appreciated. nick  i following error on execution: invalid regular expression pattern: d:\sw\exch14\transportroles\data\queue. @ d:\buildscripts\setqueuedb.ps1:14 char:32 + $content | foreach {$_ -replace <<<<  "$current", "$new"} | set-content $str     + categoryinfo          : invalidoperation: (d:\sw\exch14\transportroles\data\queue:string) [], runtimeexception     + fullyqualifiederrorid : invalidregularexpression   #################################### #change locat...

hi all i domain administrator i have many continued problem user profile ms word can not open document , ask user name , can not find printer, , specially problem scanner techniques (fujitsu 6130) user try scan documents acrobat professional , can't find scanner in list of scanners, our procedure log-in local administrator user , change profile name keep settings , passwords saved in profile , log out , log in again user account create new profile work again without problem. my question why problem been happens, , solve inside user profile reset profile out change profile keep documents, setting, password, favorite , other things saved in profile? thank listing me thank sir answer first user under domain controller, i'm not deleting user delete user profile created in pc (c:\ documents , setting\the user profile) solve problems in profile driver of scanner. second scanner in high speed usb scanner. my question can reset profile without delete keep setting ...

hi, not able connect opc server non admin user in windows server 2003. runtime error '-536608665(e0040067)': "failed connect opc server. system returned following error message: access denied"  i have given launch , access permissions non admin user in decom config (service name opcenum). can connect non admin user opc server in windows xp possible non admin user connect opc server in windows server 2003? opc server , client on same system please give me feedback thanks! ramesh hello, which microsoft server opc, please use full name opc can't find within microsoft. if not microsoft software please use vendor support pages. to connect windows server have add domain users remote desktop users group on domain/local machine. best regards meinolf weber disclaimer: posting provided "as is" no warranties or guarantees , , confers no rights. ...

when executing commands interactively works should executing same commands via scriptblock using invoke-command returns failed execute: not enough quota available process command my particular case using regsvr32.exe register dll's , ocx files.  i can run single command in interactive remote session 1 one , works.  bur running on directory recurse register dll's gives me error. something gci c:\somedir -recurse | where-object {$_extension -eq ".dll"} | foreach (regsvr32.exe /s $_.fullname}  fails not enough quota error.  so there remote buffer filling up? clear out? if did get-childitem , found dll's , registered them 1 one works fine.  when in loop register 3-5 error start on registering again 3-5 error again , on. after finished leaves regsvr32.exe process running each 1 failed. when run locally in loop - not remoted in - works on files without problems has pssession i'm @ loss right now. any appreciated. hi kevin, please try cmdl...

please help! use equation editor of time , cannot modify object created equation editor in word documents. can delete existing equations , equation editor , put new 1 in. after cannot modify either new ones or old ones created because dialog box pops "word cannot open document - user not have access privileges." still use windows 7 (don't ask) , worked fine until today. , no, not use norton anti-virus...i use mcafee.   and administrator/owner , sole user of home pc.  hi, what version of microsoft word using? >>but after cannot modify either new ones or old ones created because dialog box pops "word cannot open document - user not have access privileges." when did error? did pop when trying open documents or try open equation editor in document? does issue happen documents (including existing , newly created ones)? >>and no, not use norton anti-virus...i use mcafee. please try disable integration of mcafee in microsoft word (cou...

hi, i upgraded sql server sql standard enterprise , i'm trying setup audits. point of defining server audit specification, cannot find either select, insert or delete in audit action type drop-down. what's wrong? missing permissions or something??? logged sa. paul it seems going server audit specification, go databse audit specification. database -> security -> database audit specification one nice article  : http://www.bimonkey.com/2009/12/sql-server-2008-auditing/ please click mark answer or vote helpful if post solves problem or helpful! SQL Server  >  SQL Server Manageability

hi, i have download vm’s , tried use cases , works expected. however, @ our organization want customize flow, need inputs: 1.        resource center: a.        we want import profiles hrms system includes skills, role in organization, , other details. b.       we want customize view search resources based on skills, past experiences & past projects. c.        we want have workflow on resource assignment if resources belong department in organization, head of department should notification resources allocation , on confirmation the resource should assigned project. d.       do have provision in project server can define role of resources in 1 project senior software engineer , other project project lead? 2.        tfs 2010 integration: a.      ...

have update statement like: declare @p1 bigint, @p2 varchar(8000), ... @p30 bigint update mytable set col1=@p1, col2=@p2 , .. table_id=@p30 (this query extracted trace file) table_id pk of table. however, execution plan not using index seek on clustered pk index. instead, it's doing "range scan" on separate index on table "p30" variable. if change bind variable "p30" type "int", "numeric(18,0)", or "decimal(18,0)", worked fine pk index, except "bigint". table_id column type "numeric(18,0)". if change column type "bigint", worked. it's problem of bigint bind variable vs. numeric(18,0) column type. strange thing tried same statement on different sqlserver instance , pk index used , not able see difference between 2 db instance in terms of data or setup. must of db instance caused difference. has ideas of caused problem? in advanc...

hi folks, i have report preview looks this.... fielda   count +abc      3 +def       2 +ghi       4 lets user clicks ont + sign def.... after expands want 3 more header appear this.... +abc       3 -def         2        fieldc          fieldd              fielde                           john               det                   mich    ...

i have silverlight project start , debug on other users machines not debug on mine. using vs 2013 , ie 11 i have removed project .pdb .uso , .sln files , removed the complete project folder machine. have removed project default web site in iis 8.596. have done a repair on vs 2013 , restarted machine. have added symbols in debug module , made sure debug silverlight enabled. in properties page in web section bebugging silverlight checked. i have tried every suggestion net no joy the error below output window. auto-attach process '[7992] w3wp.exe' on machine 'afstbws214' succeeded. 'w3wp.exe' (clr v4.0.30319: defaultdomain): loaded 'c:\windows\microsoft.net\assembly\gac_64\mscorlib\v4.0_4.0.0.0__b77a5c561934e089\mscorlib.dll'. loading disabled include/exclude setting. 'w3wp.exe' (clr v4.0.30319: defaultdomain): loaded 'c:\windows\microsoft.net\assembly\gac_64\system.web\v4.0_4.0.0.0__b03f5f7f11d50a3a\system.web.dll'. loading ...

hi everybody, context : we restored tfs 2010 backup on new environment. then created new team project through visual studio 2010 verified setting ok. project creation finished ok. problem : although new project accessible through vs (it means able create new workitems, queries, etc),  not able browse through web. when try select project browser, error: the team project specified uri vstfs:///classification/teamproject/... not exist . what tried we trying access user member of: console administrator , team foundation administrators . extras previous "backed-up" team projects web accessible. new project have issue.  is known error? there troubleshooting? solved :) 1. open "c:\program files\microsoft team foundation server 2010\application tier\web access\web\ web.config " file. 2. appsetting: <add key="workitemtrackingcacheroot" value="cache_path\cache_v10.0.30319"/> in environment...

any methodology called zapper or user update while migrating ad? thanks& regards, selpri | india | +91-9986655633 future looks bright... hello mean that? for upgrade ad ds windows server 2008, refer microsoft guide: http://technet.microsoft.com/en-us/library/cc731188(ws.10).aspx     this posting provided "as is" no warranties or guarantees , , confers no rights. microsoft student partner microsoft certified professional microsoft certified systems administrator: security microsoft certified systems engineer: security microsoft certified technology specialist: windows server 2008 active directory, configuration microsoft certified technology specialist: windows server 2008 network infrastructure, configuration microsoft certified technology specialist: windows server 2008 applications infrastructure, configuration Windows Server ...

i have windows server essentials 2012 r2 running dc, dhcp , dns. server can access websites fine , fast. problem on workstations web browsing slow. website load slow. big web pages not load , seem time out , stop loading half way through. there 1 website need order parts on. items on there have few listings , page load fine. if item many listings page never loads , cant order it. same web page load fine on server or computer on same network not part of domain. i have been fighting while or suggestions appreciated. gary: maybe on something.  if testing shows desired result please contact av mfg workarounds.  , let know results.  , if summary helped please mark answer. larry struckmeyer [mvp]-- --if question answered please mark response answer others can benefit. Windows Server  >  ...

g'day, i'm encountering issue freshly created server 2012 wsus box wherein wsusutil import fails error message expandedcabinettodirectory( c:\users\incognito\appdata\local\temp\tmp3a3a.tmp ): not cabinet (13)import failed import updates.  please @ log files error details.  fatal error: unable uncompress package event viewer has error event 12072 the wsus directory not accessible system.net.webexception: remote server returned error (401) unauthorized at system.net.httpwebrequest.getresponse at microsoft.updateservices.internal.healthmonitoring.hmtwebservices.checkcontentdirwebaccess(eventloggingtype typehealtheventlogger logger) at 1 point there 10012 permissions on d:\wsus incorrect, resetting permissions on wsus folder ones specified in implementation guide cleared error any assistance appreciated .  cheers hi loupaloma, what account use import operation? does account on server have permissions read export.cab file? please check followi...

in licensing data sheet for server 2016, says: " essentials edition cloud-connected first server, ideal for  small businesses 25 users , 50 devices. essentials  is option customers using foundation  edition, not available windows server 2016." however, appears cannot run remote desktop services rds cals under essentials.  we have number of deployments using server 2012r2 foundation, rds role , rds cals work size of build. is case server standard 2016 smallest licensable version supports rds? as you've mentioned, remote desktop services (rds) not compatible windows server essentials (installing can wreak havoc on underlying "windows server essentials experience" server role configuration/functionality). therefore, need setup second "application" server running full gamut of rds server roles instead (or, look at "wse remoteapp 2016" add-in windows server 2016 essentials). unfortunately, there isn'...

how create user profile?  how copy , paste ntuser.dat file? iam not getting per copy&paste, not getting rename. hi you not able copy files ntuser.dat user folder. login administrator account , rename user folder .old (ex test.old) and login machine using renamed user account, create user profile automatically.   regards, sreem Windows Server  >  Windows Server General Forum

hi all,   i'd add 2008 core additional dc member (not gc child/replication only) , additional dns. i believe need create unattend file , below guidelines,   for child domain installations, following options apply: [dcinstall] parentdomaindnsname=<fully qualified dns name of parent domain> username=<the administrative account in parent domain> userdomain=<the name of domain of user account> password=<the password user account> specify * prompt user credentials during installation. newdomain=child childname=<the single-label dns name of new domain> sitename=<the name of ad ds site in domain controller reside> site must created in advance in dssites.msc snap-in. domainnetbiosname=<the first label of qualified dns name> replicaornewdomain=domain domainlevel=<the domain functional level number> value cannot less current value of forest functional level. databasepath="<the path of folder on ...

i'm migrating sbs 2003 server sbs 2008 server.  i've attempted several times unsuccessfully apply service packs on source server.  hard drive space limited fear why can't bring sp2.  if go ahead migration sbs 2008 still work?  have ideas?  i'm doing full backup right of source server ensure have image of hard drive , data.  want keep same domain name.  please advise. on issue keeps coming can't verify update.inf.  i've done steps suggested microsoft , others found on net no luck.  hard drive low on space.  frustrating least. hello, please use following guide: http://technet.microsoft.com/en-us/library/cc546034(ws.10).aspx also stronlgy suggest use sbs forum/newsgroup, there sbs experts: http://www.sbs2008.com/ best regards meinolf weber disclaimer: posting provided "as is" no warranties, , confers no rights. Windows Server ...

in security audit of dmz adfs proxys's came iisstart in default documents , makes server appear new build , vulnerable.  we deleted issstart.htm how should secure or should replace with?  would blank htm work? in security audit of dmz adfs proxys's came iisstart in default documents , makes server appear new build , vulnerable.  we deleted issstart.htm how should secure or should replace with?  would blank htm work? page not required adfs work. can remove or replace no problems. this posting provided no warranties or guarantees , , confers no rights. ahmed malek my website link my linkedin profile my mvp profile Windows Server  >  Directory Services

hi i trying apply recommended patches our rds environment , stuck on rds ha connection brokers in particular kb3091411 i have installed prerequisite updates per article still error message "the update not applicable computer" when trying install update 1 of rds connection brokers. https://support.microsoft.com/en-gb/help/3147099/recommended-hotfixes-and-updates-for-remote-desktop... https://support.microsoft.com/en-us/help/3091411/user-connection-fails-when-many-connections-are-made-to-windows-server-2012-r2-based-rd-connection-broker does know if has been superseded update? anyone tried install it? server 2012 r2 (6.3.9600.17196) any help/advice appreciated does know if has been superseded update? the update catalog has been broken 24 hours or so, cannot tell. looks older i'd check file versions have against kb. if have higher versions then hotfix installer would report "not applicable" https://support.microsoft.com/en-u...

hello, i have ad controller happens hyper-v. server dns , dhcp server network. server has 2 network adapters, of 1 allocated hyper-v , host lost control of it. unfortunately, none of vms can contact ad controller anymore or connection drops. having similar issues rdp windows 7 machine on network. ideas might have caused that? task offloading disabled hi lambros, do have errors or warnings in event viewer concerning dns role ? can ping host (that domain controller) virtual machines ? david lachari Windows Server  >  Hyper-V

hi there, have 15 - 20 users on rds server , different users experience several seconds lag when entering text keyboards. we've found cpu usage @ different times averaging 30-70%. have doubled ram , added second processor rds set use exclusive numa node, problem doesn't appear have ceased @ all. looking threads of highest cpu time user processes (often ie11) process explorer, found reference protected mode , being 80% of process demand. i'd test if there performance improvements users having protected mode disabled via gpp. this setting isn't avail in gpp , have win 2008 r2 ie8 latest version listed. i've manually edited ie8 internetsettings.xml http://support.microsoft.com/kb/2733083 add  disabled="1" every xml tag includes following value: name=”2500” set version tag max="11.5.0.0" but... after applying gpo ie still has protected mode enabled , configurable. is there else can here..? you can import ie11 gpo ...

what module or cmdlet create dhcp reservation , set tftp boot server/ file hi jondoe321, please find basics at  http://blogs.technet.com/b/teamdhcp/archive/2012/07/15/bringing-powershell-to-dhcp-server.aspx  ; must install rsat dhcp use it; need import module, please see blog ( import-module *dhcp* lazy ones) . please aware of term windows server 2012 in posting above, may need run windows 8.x or create/import session from your server to have cmdlets mentioned. please let me know if worked you.  regards, martin     Windows Server  >  Windows PowerShell

hi, i've been having difficulty calling powershell scripts the "run task when alert triggered" field under alert task tab when setting perfmon alert in windows server 2012 r2.  there information around windows server 2008 not server 2012.   so possible call powershell script directly field referred above, or is necessary define ps script in  scheduled task , call task above field, defining task arguments , passing them ps script in '$(arg0)'? thanks, rick hi rick, thanks post. i'm liitle bit confused question above, mean you'd use alert generated in performance monitor triger task in windows server 2012 r2? if so, may have check on below article, gave detailed steps configure it: https://www.microsoftpressstore.com/articles/article.aspx?p=2217266&seqnum=2 best regards, elaine please remember mark replies answers if , unmark them if provide no help. if have feedback technet subscriber support, contact tnmff@microsoft.com. ...

hi, i want query users did not visit website past 3 years. how write query this. tried using calculated formula =datediff("yyyy",fields!scheduled_date.value,now())>= 3. calculated column shows false each row , shows error "the value expression field ‘sch_date’ contains error: operator '>=' not defined type 'date' , type 'integer'". and want group report user name. tried using group results weird. each row showed username. any ideas please? thanks hi fadnan, thanks question. based on description, understand type of scheduled_date date/time, compare scheduled_date’s value value of now() function on year level, however, displays error of type conflict. actually, there 2 different actions requirement, 1 in t-sql query level, 1 add filter on dataset, in action, please remember setting expression’s data type of datediff("yyyy", fields!scheduled_date.value, now()) integer, detail steps below, action...