Lun

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

SUM or AVG using multi-value parameter in Expression

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

Import Design from Doc to the SSRS

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

EntitiesInError does not contain failed deletes

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

Calculated Measure And Drill Through

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

ReportBuilder. Centering image in Report

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

How to write a SQL statement which can hide Duplicate values during query output

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

Is this a bug in TextBlock?

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

Parameter Data Type and Image format

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

SQL Azure Backup Strategy

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

VS 2012 Designer Exception from Xaml Editor

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

How to let 3rd party access to our code

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

Can Azure SQL be part of Azure VNET?

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

Report with between date filter is creating a report per date instead of calculating all the totals

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

Ria using EFExtensions to get Multiple Result Sets from Stored Procedure in a single call ?

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

Could not load the DLL xpstar90.dll

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

What is smaller when saving to SQL database?

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

Browser Crashed while close Silverlight Application

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

SSIS and Collation

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

Paging issues when setting Table visibility.

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

Tabluer Model-DirectQuery can we use for OLAP system for good performance

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

sql server connection problem

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

No key on MSDN to upgrade from SS 2012 trail to dev edition

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

Available Destination Column not updating new column

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

Backup older partitions to alternative storage

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

Sql Case or IF or Temp Table or ???

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

SQL support for PCI Complaint

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

TFS user migration from one domain to another

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

SQL mail and SQL Server 2005 RTM 64-bit

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

Small Database Question

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

Linq query in sql ce with Ado.net Entity Framework problem

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

any one know whats wrong with it

[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() ...

Error Loading Task. The Contact Informaiton For the Task is "". This Happens When Loading a Task Fails.