Lun

i'm trying edit textbox control template, when paste template http://msdn.microsoft.com/en-us/library/cc645035(v=vs.95).aspx  i error on line indicated: <storyboard> <objectanimationusingkeyframes storyboard.targetname="validationtooltip" storyboard.targetproperty="ishittestvisible"> <discreteobjectkeyframe keytime="0"> <discreteobjectkeyframe.value> <sys:boolean>true</sys:boolean>  <!-- error here sys:boolen not found --> </discreteobjectkeyframe.value> </discreteobjectkeyframe> </objectanimationusingkeyframes> </storyboard> i'm including namespace artice required. any ideas? hi michaell..., you'd better add this reference in xaml file. xmlns:sys="clr-namespace:system;assembly=mscorlib"   we highly recommend use blend edit template.  mush easier ui related work.  thanks. best regards, jonathan

hi, current setup / situation: four server farm bi portal: sql server instances ssas instances sharepoint apps (ssrs, central admin ...) sharepoint frontend three different environments (dev, test, prod) same configuration (servers, versions, cpu/ram,...) kerberos configured (as far can see) pushing current user credentials forward sharepoint frontend ssrs integrated service app ssas olap cube. problem: when connect report on dev dev cube, report execution time 7 seconds. in execution log can see in additional info field, have connectionopentime of couple of milliseconds (~ 20-40). when connect report on test test cube or dev cube or dev report test cube, have runtimes of 60 seconds connectionopentime of little bit more 2000 ms. when change data source connection fixed windows account, runtime drops down 7 seconds. when switch "use current user credentials" runtime stays @ 7 seconds 1-2 hours, in drops 60 seconds. question: what can cause huge connec

i having problem requirement report that i cannot figure out in mdx.  i hope there can me this. have following requirement.  i to display move a dimension member on time and see have been moving to. show in visual way:   month february-2010         month attribuut member 1 2 3 4 5 january-2010 1 20           2   34   2     3     45       4   4   23 1   5         60 example: i want compare january 2010 february 2010. if you @ grid see instance attribute member 2 january has 34 items same in february , 4 items have moved 2 4. i have been breaking head on how in mdx. can sombody show me how this? remond     hi remond, please provide further details. what's layout of fact-table ? about 2 time-dimensions on grid, did (or intention to)  setup so-called role-playing dimensions this  ? is intention deploy using ssrs, excel, els

hi there! i have ready-for-use dataset, have mutli-value parameter (integer type) use calculate sum or avg: =sum(iif(fields!end_prd_id.value=join(parameters!avg_month2013.value, "," ), fields!fact.value, nothing )) read lot join , split , array string used in multivalued parameters, code above works if 1 value selected in multi-valued parameter. in case choose 2 values values "" or blank, whatever... in case choose 3 parameters #error. what need is: correct expression calculation based on multiple choice in multi-value parameter. i know expression: sum(iif(fields!end_prd_id.value=parameters!month_calc.value(0),fields!fact.value, nothing )) works fine if there 2 selected values in multi-parameter. please advice me way out! i`m going crazy :) thanx alot in advance! hello, in case, if choose multiple values in report, expression: join(parameters!avg_month2013.value,",") return string value. field end_prd_id integar

hi,    have report design created in .doc file.   want copy , paste design in ssrs report.is there way so?   ssrs report design should match design in doc. i using bids 2005 thanks ~sr. database analyst~ hi, for requirement, suggest 2 possilble ways: 1. embed these word docs database: 1) use sql commands(...openrowset...) embed these word docs in database image data. 2) use .net language (c#, vb) convert data image. 3) use image control show these images, word document embedded in database. see article describes how embed pdf document in reporting services, http://www.codeproject.com/kb/reporting-services/rs08embeddingpdfdocument.aspx (not microsoft's), similary while using word documents. 2. upload these word documents in report server, access them using url. 1) can upload these word documents in report manager. 2) add hyperlinks reports link these word documents stored on report server. for using url access in reporting service, see

when checking entitiesinerror after submit, failed updates , inserts captured, if entity fails delete (due foreign key constraint in db) entitiesinerror empty. why? understand it's bit different technically because entity validates ok on client, should marked somehow when database says cannot deleted. if have multiple deletes it's impossible (as far can tell) see entity failed. have solution this? all entities have entityconflict object has isdeleted property. property set true when try delete entity , doesn't exist in db anymore. in case, no exception thrown. when try delete , foreign key error occurs exception thrown , error submitoperation display. you can check sql error number or name foreign keys "fk_xxxx". whenever error occurs when submitting you can check if message contains "fk_" , in case know why happened. Silverlight

i getting the error below in proclarity: "error accessing drill detail information xxxxxxx  in dimension measures calculated member." ---can as2005 support drill through calculated member, if not there work around? thanks the answer pretty easy you might not like it: drillthough not supported on calculated measures or calculated members. not sure expect drillthoguh calculated measure or member. calulated member totally unrelated facts in cube. how drillthorouh that? can can come simple case of calc measure being sum of 2 measures in same measure group, narrow , not practical case. edward melomed. -- this posting provided "as is" no warranties, , confers no rights. SQL Server  >  SQL Server Analysis Services

hello everybody, i need in centering image in report. thanks http://firebird-vbnet.blogspot.com/ hi giovannigiorgio, according description want know how centering image in reportbuilder, right? before centering image, should clear of position related properties, after have done proper setting of them can able make image display in center of page. for physical page renderers, it's important keep in mind concept of usable area.  usable area amount of space left on page report drawn after reserving space margins, headers , footers, , column spacing (for multi-column reports). horizontal usable area: x = page.width - (left margin + right margin) vertical usable area: y = page.height - (top margin + bottom margin + header height + footer height) i suppose there image in page. please following steps below check related properties of size , center image. right click on report area , select report properties make note of values page width(8.5), page height

hi, a. not related sqlserver reporting services. i writing complex join query bring following output. enquiryno, clientname, state, city,        orderno, orderdate, itemname,  qty. 1 ,                xxxx ,        mh,  mumbai,       1 ,       1/1/2000,       item1,     2 1 ,                xxxx ,        mh,  mumbai,       1 ,       1/1/2000,       item2,     5 22 ,              xxxx ,        mh,  mumbai,       2 ,       1/1/2001,       item6,     15 22 ,              xxxx ,        mh,  mumbai,       2 ,       1/1/2001,       item7,     20 30 ,              yyyy ,        mp,  bhopal,         45 ,     1/1/2005,       item10,   2 30,               yyyy ,        mp,  bhopal,         45 ,     1/1/2005,       item11,   1 30,               yyyy ,        mh,  pune,            46 ,     1/1/2005,       item11,   1 want modify sql query such that can output below. enquiryno, clientname, state, city,        orderno, orderdate, itemname,  qty. 1 ,       

i trying scrollbar work text blocks.  not find option turn on or off scrollbars on textblock control embedded textblock in scrollviewer control, not work.  know how this?  text stops when run out of room instead of growing vertically fit contents.    <scrollviewer horizontalalignment="stretch" margin="125,48,16,72" verticalalignment="stretch">       <textblock text="simon: hello!" textwrapping="wrap" fontsize="12" x:name="textblockchat" height="104" width="232"/>    </scrollviewer> when add text my textblock can in c# add event add arbitrary height using textblock.height += 50; gets out of sync actual text size since there no way know height should or how need add.  textblock should grow hight of text in it, doesn't.  know how overcome this? all need place textblock (withtextwrapping="wrap") in grid. make sure not set explicit height textblock

i have image embbed in header want display based on true or false. need know data type use image in parameter. background please read on. i have created report parameter @image values 1 true 0 false. assigned visability of image. have set default value show. if parameter set false don't show. when run report it the hidden experssion used in image returns data type not valid. have data type of image in parameter text. have tried types in list , not work of them. need know data type use image in parameter   hi greg, in sql server reporting services, can use image control show image. image image control can come 3 ways: external, embedded , database. below syntax obtain image each source(value property of image control): external: http://mysite.contoso.com/image.jpg embedded: imagename (the name of image. image must imported report project, , deployed report server) database: =fields!field.value (the value stored in binary data type) however, in case, seems want sh

my database size 32gb already. and quite take time backup using create database copy. the last time, create backup command (to different server). with size of 27gb, takes 6 hours finish. the database size keep growing , backup time seem take more , more time.   i know guy, how do you backup on database? how long take? is other way can make backup process more faster?   actually, make fast possible. currently before deploy changes in database, have wait until backup process finish. take 6-7 hours. , after deploy changes, want our tester have time smoke test on prod server. if backup process take longer time mean tester have less time test.     check below link there various resources , option available backup database. http://blogs.msdn.com/b/davidmcg/archive/2011/09/29/data-backup-strategies-for-windows-and-sql-azure.aspx Microsoft Azure

apologies if not right section. went through rest of forum sections , 1 matched, has since been locked down. i've got clean install of windows 8 on x64 machine. installed vs 2012. added new windows store project -> blank app double clicked on mainpage.xaml file project open it. wait 30 seconds designer load , exception in designer microsoft.expression.designhost.isolation.remoting.remoteexception process has exited, requested information not available. @ system.diagnostics.process.ensurestate(state state) @ system.diagnostics.process.get_virtualmemorysize64() @ microsoft.expression.designsurface.designerservice.onprimaryprojecttargetfilechanged(object sender, eventargs args) @ system.eventhandler`1.invoke(object sender, teventargs e) @ microsoft.expression.designhost.isolation.remoting.localevent`3.<>c__displayclass19.<invoke>b__18() @ microsoft.expression.designhost.isolation.remoting.stamarshaler.call.invokeworker() @ micr

hi experts, we trying let 3rd party vendor access our code audit security. towards purpose, them able read/download code local machines not able check in files. how can achieve that? thanks, s hi s,    thanks post.   in source control explorer, right-click on collection node(or other folder/node) , select advanced >> security… , in opened permissions dialog, can deny check in permission group or user in there. we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey. Archived Forums V  >  Team Foundation Server - Setup and Administration

greetings, i prevent azure sql instance available public internet. is there way have azure sql part of azure virtual network , define firewall rules through azure vnet? thank you, hi, simple answer; no can't connect azure sql server vnet. the sql instance not available public internet; can add ip addresses server or database firewall need access sql db public internet. if don't define ips, traffic internet blocked. floris van der ploeg - www.florisvanderploeg.com if post helpfull, remember click "propose answer" button. Microsoft Azure  >  Azure SQL Database

hi, i had report calculation of sales revenue of 1 day. had 1 parameter @date. working perfect. have created copy of report , added parameters @startdate , @enddate,within data set query added following line: where     (datum between @startdate , @enddate) the filter working correctly. problem creates page per date instead of data on 1 page totals. how can avoid this? kind regards, bart timmermans bart timmermans | consultant @ inovativ follow me @ blog | linkedin | twitter please mark answer, if post answers question. vote helpful, if helpful you. i little bit when opening topic. problem solved deleting grouping. bart timmermans | consultant @ inovativ follow me @ blog | linkedin | twitter please mark answer, if post answers question. vote helpful, if helpful you. SQL Server  > 

 hello, i trying solution following problem: a. silverlight client loads query entity , related entities. (i have declared [include] in metadata) b. domainservice uses efextensions materializer entity , related entities single call 1 stored procedure returns entities in multiple result sets. c. domainservice shall return entity , related entities silverlight client. here problem. when add .include("...") gets related entities again database don't want because stored procedure returned related entities , materializer bound them context.  does has solution problem? thanks bernd  ok, figured out. in scenario domainservice function has have return type ienumerable<t> instead of iqueryable<t>. to force domainservice return related entities context not enough add [include] attribute link entity, has set other related entity metadata. this result in nice , simple "all @ once" transfer single stored procedure call silverligh

i have inherited sql server 2005 installation (not working) , although can connect server using studion express, try create new database loads of errors claiming 'could not load dll xpstar90.dll'. the dll exists , appears have reasonable set of security set on it, stumped go next disnose problem. any suggestions? regards themightypuzzled hi i'm new working whith sql server 2005 , have same error too. what do resolve error whit de xpstart90.dll?? pd: don't find xpstart90.dll on specific folder.. regards. cesar... SQL Server  >  SQL Server Setup & Upgrade

when saving blank column sql database, of these 2 options uses least amount of space on hard drive?  null or "" would there benefit using 1 on other? might silly question when databases large think can make difference. thanks not laughing hard. dave  ideally, should using null  "" value - though not contain value still value where null undefined , has no value. i not have excat metrics storage wise null better data type  if of data in column null, can make column sparse--it have better savings in storage refer this  http://weblogs.sqlteam.com/mladenp/archive/2007/09/06/how_does_sql_server_really_store_null-s.aspx r efer links in post(3rd reply)  http://www.sqlservercentral.com/forums/topic585323-80-1.aspx hope helps!! SQL Server  >  Gett

hi guys,                 i have created  custom tab control in silverlight. have used dispatcher.begininvoke(...) method in onapplytemplate() function.after add tab control in silverlight application, can  interact properties in xaml not problem. other , handling event or properties in code behind creating ie crash issue while close browser. add tab control in silverlight app , run it. functionalities working fine browser crashed when close browser. have spend more time fix on it.                 can hav idea tis issue?       thanks in advance regards,  suresh quit double posting, it's annoying behavior, have question you: my car broken, it's green , has 4 seats, can be? Silverlight  >  Visual Studio & Silverlight Development Tools

hi, what happens if have source database collation sql_latin1_general_cp1_ci_as , target database collation latin1_general_ci_as ? will ssis automatically convert destination collation ? can understand lookup , merge joins might fail, in case copying data. constantijn the issue copying data code page of collations.  in case, both collations use code page 1252 no character conversion necessary. select collationproperty(n'sql_latin1_general_cp1_ci_as', 'codepage'); select collationproperty(n'latin1_general_ci_as', 'codepage'); dan guzman, sql server mvp, http://www.dbdelta.com SQL Server  >  SQL Server Integration Services

hi all... ok using ssrs 2005. my report has: - chart component called main_summary (at top of body section) - a table component called main_details (directly underneath main_summary) - main_details table set new page appears before it. this report has been working correctly main_summary chart being displayed on 1st page , main_details being displayed pages 2 , onwards. *** now want give user option of geneating report will: - show both summary , details (value = 0) - show summary (value = 1) - show on details (value =2) i added parameter to prompt user wanted see , using parameter control visibility property of both main_summary , main_details.  using following experesion main_summary:  =switch(parameters!displayflag.value = 0, false,parameters!displayflag.value = 1, false,parameters!displayflag.value = 2, true,true,false)  * use similar expression visibility of main_details.  my problem once add these expressions main_summary , main_details components , generate report... report gener

hi all, tabluer  model-direct query can use olap system performance. i have around 50gb of data. real time reporting purpose can use tabluer model direct query regards, manish hi manishcal16pps, since directquery mode retrieve data directly relational data source, can't performance using in-memory mode. in scenario, depends on environment , hardware. if 50gb data large amount in environment, , analysis services database will consume half of memory on machine hosting analysis services instance, consider directquery. otherwise, performance, it's use in-memory. please consider a hybrid mode: in-memory directquery or directquery in-memory. use mode default client side can choose mode. please refer links below: tabular query modes: directquery vs in-memory directquery mode (ssas tabular) regards, simon hou technet community support SQL Server

hi guys when trying connect sql server management studio express edition 2005 gives like below error ...... please me in advance.....   a network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name correct , sql server configured allow remote connections. (provider: named pipes provider, error: 40 - not open connection sql server) (.net sqlclient data provider) please take @ link http://blogs.msdn.com/b/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx SQL Server  >  SQL Server Data Access

hey! before had access developer version of sql server 2012 installed trial one, relying lateron can enter key. now the msdn site says there no key needed 2012 developer version download! (my employer has big account ms!) does mean need uninstall trial , reinstall dev edition? thx g. hello, product key may pre-pidded on media. perform edition upgrade using following procedure: http://msdn.microsoft.com/en-us/library/cc707783.aspx on product key page, may noticed product key there. hope helps. regards, alberto morillo sqlcoffee.com SQL Server  >  SQL Server Setup & Upgrade

i have package pulling 3 separate databases of today working fine.  however, have request add calculation in query of whether or not commercial account or not.  added in using case statement , on functioning in management studio.  however, when pull code ssis package not able select 'commercial' in available destination columns.  have confirmed in destination table , appears in available input.  i've refreshed , tried adding manually advanced editor no success.  read on thread union might issue wasn't before don't think problem.  reason isn't reading case statement destination column.  ideas appreciated.  code below. declare @end as datetime declare @yesterday as datetime declare @window as datetime set @end = datediff (dd,0, getdate ()) set @yesterday = dateadd (dd,-1,@end) set @window = dateadd (dd,-5,@end) print @end print @yesterday print @window select 'in' as source, cast ( cast (lastmoddate as varchar ) a

hello, i have db abou 20 cubes. number of partitions in these cubes vary between 4 , >20 partitions, depending on size of data inside these cubes. since has been collecting data long time, move partitions has data older 18 months "tape" , leave partitions data newer 18 months. , when required, restore data tape if ever needs accessed. what's best way this? have manually move .prt folders (and corresponding xmls) inside .cub/.det folder tape? if so, happens these partitions showing in ssis? there issues not thinking about? restore, need copy .prt folders? thanks! using sql server 2005 - planning upgrade 2008r2 hi rickkh, as far know there no method backup/restore partition separately. post, concern long time process , storage issue. if so, i'd suggest set storagelocation to the large storage device partition holding data older 18 monthes , select "process incremental" option process partition, option process new data instead of e

i have table contains recno, ctype, date.  few typical rows: 20, agtrmp40, 2010-04-08 00:00:00.000 20, firarm, 2010-04-08 00:00:00.000 what i'm trying accomplish able extract date agtrmp40 when have providing date agtrmp40 more recent firarm record, otherwise, firarm record newer , i'd use that.  can't seem work.  initial select information above is:  select trnhst.recno, trnhst.crsid, min(trnhst.date) trnhst crsid in ('qsr','firarm','agtrmp40') , status in ('comp','pass') , trnhst.date >= '2010-01-01 00:00:00' group trnhst.recno, trnhst.crsid order recno, crsid any guidance appreciated.  can't figure 1 out! thank you! we can this ; with cte as ( select trnhst.recno, trnhst.crsid, trnhst.date,  row_number () over (partition by recno order by [date] desc ) as row from trnhst where crsid in ( 'qsr' , 'firarm' , 'agtrmp40' ) and status in ( 'comp'

are there specific guidelines make sql server pci compliant, specially if company collects credit card information? in reality, no one can state particular settings make compliant person can defiintely configurations sufficient auditor.  however, there general guidelines available helpful.  i'll refer sql server compliance portal ( http://www.microsoft.com/sqlserver/2008/en/us/compliance.aspx ).  in particular, take @ sql server 2008 compliance guide.  also, there's upcoming webcast on sql server , pci you'll want check out: http://msevents.microsoft.com/cui/webcasteventdetails.aspx?eventid=1032404173&eventcategory=4&culture=en-us&countrycode=us . il-sung. posting provided "as is" no warranties, , confers no rights. SQL Server  >  SQL Server Security

we running tfs 2010 sp1. problem background: recently, due internal reasons, needed migrate several users 1 domain another. actually, "migration" not migration @ - our local ad admins created new user accounts in domain , adjusted acls on file , print servers, after that, we were told use new accounts instead of the old ones, there no sid history attached new accounts. provided, no-one cared migrate tfs users, had log pc old account , use "run as... (new account)" in order connect corporate resources. two days ago tried migrate 1 tfs user "tfsconfig identities /change /fromdomain:<olddomain> /todomain:<newdomain> /account:<olduser> /toaccount:<newuser>" command, ended broken tfs configuration user. when run command, reported success, however, "tfsconfig identities" lists both accounts (old , new one) now, there no changesets associated new account, moreover, new account cannot see workitems in project, plus, at

for sql server 2005 rtm 64-bit installation cannot apply sp. so, in order send email agent job must use sql mail, when execute test in sql server agent, after creating outlook express account, have logon failed error. suggests me, please? thanks hmmm, why cannot apply sp? have enable db email? configured it? best regards, uri dimant http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/ SQL Server  >  SQL Server Database Engine

hi there, i'm trying implement reasonably small database client side in application. use of less thousand bits of data. idea application used when there no online connection available. from understanding silverlight doesn't allow read / write without user permission , isolatedstoragefile can read , write data per instance, ie not storing once application closed. what options excluding hard coding data application itself? thanks help, gold dark.  no not clear each time.  however, there caveats isolated storage on wp7 , have removable sim cards.  isolated storage work on them, if user removes sim card??  think wp 7 applications have lot of storage have account things possibly not having part of items locally , check them every time app loads in case. the reason why ms doing because of hub in cloud model.  didn't see demos of of @ mix, coming settings , options going in windows azure (cloud) , there less emphasis on local databases.

i have simple linq query , var a=from b in myentity.tablea           b.fielda=="title"           select b; but error occured : "the ntext , image data types cannot used in where, having, group by, on, or in clauses, except when these data types used or null predicates" but fielda is  varchar(100)  not ntext type . my database sqlce 3.5sp1 . any advice appreciate . thanks. i suppose query trying out looks similar below one:           // generates paramterized query above query doesn't.           string value = "title" ;            var = from b in myentity.tablea                      where b.fielda == value                      select b;   if so, @ forum more details , workaround issue. http://forums.microsoft.com/technet/showpost.aspx?postid=3746251&siteid=17   or if you are facing issues exact query given sample (which souldn't case), let know more details figure out root cause of issue.   thanks, vamsh

[code]   private sub pulllikehell()         dim cn sqlceconnection         dim rda sqlceremotedataaccess = nothing         dim sqlengine sqlceengine         try             ' create database if doesn't exist             if (not file.exists("\my documents\order.sdf")) then                 sqlengine = new sqlceengine                 sqlengine.localconnectionstring = "data source=\my documents\order.sdf;"                 sqlengine.createdatabase()                 sqlengine.dispose()             else                 ' open connection database                 cn = new sqlceconnection("data source=\my documents" & _                                          "\order.sdf:")                 cn.open()                 dim cmd sqlcecommand = cn.createcommand()                 ' drop fieldmemos table                 cmd.commandtext = "drop table staff"                 cmd.executenonquery()                 ' close

can diagnosis of these errors?   i'm receiving following error when opening ssis package:   error loading task.  contact information task "".  happens when loading task fails.   the task in question custom control flow task.  dll in ...\tasks , ...\v2.0...\ folders.  registered gac , typed.   attempting delete task results in error:   cannot remove specified item because not foun in specified collection.   next, click ok , close package i'm prompted save file.  choose yes , package closes expected.  surprisingly, custom task gone when reopen package.    finally, add custom task control flow.  no validation or other errors presented @ point.   so, i run package , encounter error:   error: 0x0 @ generate snapthot, generate snapshot: parameter validation failed. not possible provide valid values parameters. ---> parameter validation failed. not possible provide valid values parameters. ---> parameter validation failed. not poss