Lun

hi   i have peculiar problem. have main report has sub report. sub report in turn has subreport. in preview mode of main report , screen blank. when export report format able see report in exported file. why preview shows blank screen if report available after exported/? ravi.s chennai, tamil nadu, india hi ravi,   thanks post.   i suggest verify whether 2 subreports work normally. if both 2 subreports work fine, suggest delete subreport in main report , recreate it; otherwise, suggest recreate subreports in each report( sub-level top-level).   if have more problems, please feel free let me know.   thanks, bill lu please remember mark replies answers if , unmark them if provide no help. SQL Server  >  SQL Server...

i used using mysql mysql workbench. there an equivalent piece of software can use remote odbc connection microsoft sql server. in other words have remote connection via odbc. set through windows control panel. workbench! thanks!  hi, sql server managemnet studio provides same kind of functionality. can connect remote sql server using ip or machine name it. to need install sql server client tools. - chintak ( my blog ) SQL Server  >  SQL Server Tools

hi guys, i'm new here , here's question. why .net reflector vs extension not working? have visual studio windows desktop , downloaded the .net reflector vs extension, double-click extension said: installation failed the installation unable install extension selected products. more information, click install log link @ bottom of dialog <button>close</button> view install log install log: 10/18/2014 10:01:35 - microsoft vsix installer 10/18/2014 10:01:35 - ------------------------------------------- 10/18/2014 10:01:36 - initializing install... 10/18/2014 10:01:37 - extension details... 10/18/2014 10:01:37 - identifier      : 04e215d3-4dfd-4ae4-b72c-d5ef91dc603b 10/18/2014 10:01:37 - name            : .net reflector visual studio extension 10/18/2014 10:01:37 - author          : red gate 10/18/2014 10:01:37 - version         : 8.4.0.1 10/18/201...

hi all we have 4 reports has parent child relation. if navigate customer summary>customer project summary>milestone summary>explore silo , stay idle close 10 secs on explore silo report, automatically report getting refreshed , moved 1st parent report . dont have refresh property set @ ssrs reports level. what reson behaviour . needs set @ sharepoint level ? surendra thota hi surendra, do pass parameters between these reports? are these reports working in designer? regards, black SQL Server  >  SQL Server Reporting Services, Power View

i have bunch of people in list column in same list has birthdays. need create report states following. under 40 40-45 45-50 50-55 55-60 on 60 need know how many, based on birthdays, people fit different categories. life of me, cannot figure out how this. advice appreciated. bm you can use datediff function age in years: =datediff(dateinterval.year,fields!birthday.value,today()) then use count number in each group: =sum(iif(datediff(dateinterval.year,fields!birthday.value,today())<40,1,0) < gets count of people under 40 for categories high , low limit need specify both criteria joined and: =sum(iif(datediff(dateinterval.year,fields!birthday.value,today())>39 , datediff(dateinterval.year,fields!birthday.value,today())<45,1,0) < gets count of people age 40 through 44 SQL Server  >  ...

hi all, info: 1. virtual machine 2. there 64gb physical memory 3. sql server 2008 r2 on windows server 2008 there tens of thousands of following errors in error log: appdomain 245 (mssqlsystemresource.sys[runtime].262) unloaded. a significant part of sql server process memory has been paged out. may result in performance degradation. duration: 327 seconds. working set (kb): 9819232, committed (kb): 20354456, memory utilization: 48%. checked following query , got: -- physical_memory_in_use_gb stands physical memory sql server uses select physical_memory_in_use_kb/(1024) physical_memory_in_use_mb     ,virtual_address_space_committed_kb/(1024) virtual_address_space_committed_mb sys.dm_os_process_memory physical_memory_in_use_mb    virtual_address_space_committed_mb 10972    20199 checked sys.configurations: object_name    counter_name    instance_name    cntr_value sqlserver:memory m...

hi all, i new ms environment. have purchase  microsoft server 2012 r2 enterprise licenses , sql server 2014 enterprise licenses. may know can i contact/submit service support request microsoft should encounter technical or setup issue ?is there portal or specially ? do i need purchase software assurance in order raise tickets ? p.s. sorry if asking in wrong place. please point me right place if possible thanks! hello, you can find ms support main page here: https://support.microsoft.com/en-us you can raise support case without having issurance, pay per call, if issue wasn't caused software bug; otherweise money back. olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  Getting started with SQL Server ...

how can filter field has multiple values 1 value eg. 'contractor' , if there other values, let choose of others, eg, owner, support etc.   don't want pick contractor , if that's not available defaults to nothing. hi kittycat101, based on understanding, field contain values “contractor” , other values. if field contains “contractor”, want display field nothing. if contains “contractor” , other values, want display other values, right? if case, can add filter condition below: if misunderstand requirement, please share report design , expected resulst our analysis. if have question, please feel free ask. best regards, qiuyun yu qiuyun yu technet community support SQL Server  >  SQL Server Reporting Services, Power View ...

when sql-azure pricing details state 10gb of storage $100 per month before or after file level compression , sql server has applied multiple data compression tricks? my understanding recent sql server release can lot more beyond using o/s compressed volume e.g. field level value tokenization , cross row tokenization down specific column. hi camelcase,     thank interest in sql azure. not support data compression in v1 of sql azure , hence no data compression done. thanks, abi Microsoft Azure  >  Azure SQL Database

how programmatically tfs group current user in work item? name , windows group user can through: m_workitem.store.teamfoundationserver.authenticateduseridentity sanya,   have tried using isecuritygroupservice? if not, refer following link gives better picture tfs groups , how can programmatically ...do same..   http://blogs.msdn.com/jmanning/archive/2007/03/09/get-memberships-ps1-programmatically-finding-the-groups-you-re-a-member-of.aspx   moreover, have read following post talks same... http://forums.microsoft.com/msdn/showpost.aspx?postid=1325911&siteid=1   hope helps.   thanks, kathir Archived Forums V  >  Team Foundation Server - Project Management & Work Item

hi,        how use file stream in sql azure????         is possible use file stream? if yes how? if no alternative file stream???        thanks in advance. hi,     if querying data t-sql, can use varbinary(max) instead of filestream. provides equivalent functionality t-sql query point of view. i.e. create table [dbo].[kb_content]( [contentlength] [int] null, [contenttype] [varchar](100) null, [content] [varbinary](max) null, [extension] [varchar](10) null, ..... -- srini Microsoft Azure  >  Azure SQL Database

  hi all,   i want create program runs build type. the program chooses , changes solution path in proj file according user input. now, question is: must i perform check out , in proj file before running build or can change build type in workspace , run my workspace?   the thing have version folder in sc tree contains branches and want run same build type different branches..   thank help, roy.   hi roy,   you should able overwrite tfsbuild.proj file locally on build machine in <afterget> target. how user provide input? have figure out how propogate user input build machine. you can choose write custom task makes copy of tfsbuild.proj file in local workspace , updates solutions build.   thanks, madhuri   Archived Forums V  >  Team Foundation Se...

i have clean copy of windows server 2008 r2 64-bit.  downloaded 2 files microsoft: sql server 2008 express w/ advanced tools (sqlexpradv_x64_enu.exe) & sql server sp1 (sqlserver2008sp1-kb968369-x64-enu.exe).  both of them 64-bit version.  installed basic engine installation , sp1.  both worked fine.  problem occurs when want add feature, let's full text search.  open sql server installation center , click install & add features link in install submenu did when first installed sql server 2008.  when did that, revived error message says object reference not found.  @ point, decided run sqlexpradv_x64 again same error occured.  @ same time, went uninstall programs in windows 2008.  when clicked uninstalled same object reference not found message appeared. thinking might bug install, used clean copy of w2008r2 , installed basic engine & full text.  sp1.  both worked fine.  wanted add feature, management studio....

hi, i had jump url in report(ssrs 2005 rdl),to url appending unique number.i want encrypt unique number  and after redirecting page want decrypt unique number .how can this?   hi anusha, please refer following articles url encoding in reporting services, please see: http://social.technet.microsoft.com/forums/en/sqlreportingservices/thread/9d09156c-f133-4473-ba16-1163c8603238 http://www.experts-exchange.com/microsoft/development/ms-sql-server/ms-sql_reporting/q_26713813.html http://social.technet.microsoft.com/forums/en/sqlreportingservices/thread/974d8211-c2e7-472a-9096-e24969d9eb48 thanks, bin long please remember mark replies answers if , unmark them if provide no help. SQL Server  >  SQL Server Reporting Services, Power View ...

we've had query running in production several years on sql2000 takes 2 minutes run.  long query (in lines) i'll grant that. when upgraded sql2005 same database w/ same indexes , same query takes 1 hour complete. we have 1 section of query 'where not in [set of items] ' - may it. however, again worked fine in sql2000. rather post query (which do), there way can debug this? i've used queryanalyzer , not suggest additional indexes.  can point me tools or utils help?  tia although there queries slower in 2005 2000, not norm. i have experienced long query times in 2005 self reverencing views, , extremely long in lists (over 300 items).  reducing size of in list little fixed problem.  reported on ms connect, have not seen fix posted. SQL Server  >  SQL Server Database Engine ...

hello, does inscope function work inside aggregate function? using matrix control , want use following expression data cell. =sum(code.getmevalue(inscope("matrix1_rowscope"), inscope("matrix1_columnscope"), fields!productsalesid.value, fields!sales.value)) function getmevalue written in code block of report gives me proper value hashtable according scope. getmevalue takes 4 arguments. first , second arguments boolean , decide scope. observed is, inscope returns false if use inside sum aggregate. can please throw light on this? regards, hi sisvis allscripts, clarification. according description, suspect show values in 4 different zones below: 1 : matrix cell within scope of both: row scope , column scope. 2 : cell within scope of row, outside of column scope. 3 : cell within column scope, outside of row scope. 4 : subtotal cell outside both grouping scopes. actually, define expression in matrix cell using following ge...

i've had happen couple of times different sl4 solutions, , i'm absolutely stumped might be. the problem is: when use action delegate type, visual studio starts complaining there needs using statement added though   using system; is present.  has not a problem action<t> , non-generic version.  intellisense, builds fine, have intellisense warnings on show saying it's unknown type. i'm stumped.  far know, action is basic part of of mscorlib , , that's referenced, , nothing's been changed regards taht.  has else seen quirk? now i've seen happen on more 1 solution thought i'd ask.  everyone! hi,    havn't seen this. happen follow sort of patten?    mean if you things in particular order happens. best regards    Silverlight  >  ...

hi, have problem on vs2008 , cant seems figure out what's happening. wanted uses webclient class download xml silverlight project cant seems webclient class use. error 1 the type or namespace name 'webclient' not exist in namespace 'system.net' (are missing assembly reference?)  have try using system.net.webclient , system.net namespace no avail, system.dll there. knows happening? thanks just tip system.net.webclient in system.net.dll assembly... might help... Silverlight  >  Programming Silverlight with .NET – General

i want bind combobox data sql server table. in table id , name. when combobox success binding want to, in application choose combobox , button "ok" insert sql server table value int (i'm using sql procedure). public observablecollection < comboboxpw > readcomboboxpw ( int id_pw ) { observablecollection < comboboxpw > result = new observablecollection < comboboxpw >(); string nwconn = system . configuration . configurationmanager . connectionstrings [ "myconnectionstring" ]. connectionstring ; sqldatareader dr ; sqlconnection conn = new sqlconnection ( nwconn ); try { sqlcommand cmd = new sqlcommand (); cmd . commandtype = commandtype . storedprocedure ; cmd . connection = conn ; cmd . commandtext = "combobox_pw" ; cmd . p...

hi, working on project transfers data dbf files sql.  need check see if tables proposed table name exist in sql.  have code check if table exists , deletes it.  however, somehow figure out if table exists, return value based on existence, , give user option of either dropping , replacing table if exists, or stopping process avoid replacement.  below code have check if table exists.  have been trying work executescalar have never worked not sure how use properly.  appreciated. using (sqlconnection myconnection = new sqlconnection( "server=cmiclosed2;database=" + database + ";trusted_connection=true;" )) { myconnection.open(); stringbuilder exists = new stringbuilder( "if exists (select * dbo.sysobjects id = object_id('[dbo].[" + sqltablename + "]'))" + " drop table [dbo].[" + sqltablename + "]" ); string sql2 = exists.tostring(); sqlcommand cmd2...

i have run small problem. have dimension identifies types of bills. have measure reports how many bills have been issued. there several types of bills. 1 of these adjustment bill. correction existing bill. these represented "a" bills in db i need count number of unique bills, that's count of bills other "a" bills. i've looked @ calculated members struggling mdx syntax. anyone have pointers or articles should read?   it should this:` with member [measures].[num] as 'sum(except([bills].[level name].members, [bills].[ ]), [measures].[numbills])'   hope helps, santi SQL Server  >  SQL Server Analysis Services

hi, i using as 2000 foodmart 2000 db . problem when run below query getting error. query 01 select  {[measures].[unit sales]} on columns,             {[product].[all products]}  on rows from             [sales] where             [product].[all products].[drink] “ duplicate dimension across (independent) axes when calculating query axis ” but understood can use other slicing dimension where clause filter instead of product dimension, below query: select      {[measures].[unit sales]} on columns,                 {[product].[all products]}  on rows from                 [sales] where       [customers].[all customers].[usa].[ca]        this query works fine. my point know 2000 not use same dimension in 2 axes, @ same time have requirement filter selected dimension same dimension's members. refer query 01. for example, when run below query 266,773.00 unit sale all products . select          {[measures].[unit sales]} on columns,                     {[product].[all products]}  on rows ...

we using visual studio team foundation server 2010 manage our builds process. enabled analyze test impact option in order in order generate impacted tests in build summary. however, after making change build abort on impacted tests step message: team foundation services not available server <team foundation server>\<team project collection>. technical information (for administrator): operation has timed out. the log indicates operation times out after 5 minutes , 6 seconds (+/- second or 2 in other builds). total time of build 6 hours, 6 minutes , 22 seconds. we have run build diagnostic logging enabled , did not provide additional information source of error. the events logs team foundation server, build agent , sql server are clean , not show issues @ time of build failure. unsure source of timeout or how fix it.   h m.jegen, thank question. this issue has beed submitted in our connect site: http://connect.microsoft.com/vi...

hello everyone, hope doing good! company had refreshed windows 2003 servers 2008 r2 last year. along server refresh, database team had upgraded sql server 2005 sql server 2012 sp2 , database set (sql server 2012) 110 compatibility level. playing sql developer role here , have below questions, 1. stored procedures/functions/views/indexes developed on sql server 2005 work same way in sql server 2012?  2. there way/any method identify 2012 sql db, need make code changes , how, suit current db compatibility level , take full advantage of it. saw below useful links on https://technet.microsoft.com, difficult analyze each , every stored procedures/views/functions/indexes etc..in database. method pull out these details database helpful. fyi - don't have of server sql server 2005 db @ moment. https://technet.microsoft.com/en-us/library/ms144262(v=sql.110).aspx https://technet.microsoft.com/en-us/library/ms143179(v=sql.110).aspx https://technet.m...

for example, if want see queries executed @ specific date such 03/29/2011, there way that? have daily db backup , hourly transaction log backup. someone correct me if i'm wrong, can't find out queries executed during time frame. the sys.dm_exec_query_stats dmv (in concert sys.dm_exec_sql_text dmf) tell when plan created in cache , when last executed , how many times executed, won't tell every single time executed. the way can find out queries executed running trace (either server-side or via sql profiler) during time frame you're interested in... far time in past, information not recorded.   --brad ( my blog ) SQL Server  >  Transact-SQL

is there a way automate auditing where specific security principals -- sa or a domain service account -- are being used in sql instances accross multiple servers?  example, mydomain\myserviceacct have access databases, linked servers, jobs, operators, etc.?  thanks. i think might asking multiple questions. does account abc have access xyz? has account abc been used access xyz?  to answer when account has ability access can check permission tables , sql server role memberships. have posted queries on sql server wiki can started. see effective database engine permissions http://social.technet.microsoft.com/wiki/contents/articles/15180.effective-database-engine-permissions.aspx can complicated when windows user member of windows group , group has sql server login, member of sql server role, , role has permissions, etc. as has used permissions, sql server audit designed that. full fine-grained auditing requires enterpri...

hi, let me explain issue. i restored ssas 2005 cube (which connected database oracle 10g) on windows 2003 64bit server. @ beginning had connection's problems data source in bids resolved doing : - installation of 32bit , 64bit drivers of oracle 10g. - create of batch file launch bids , management studio. now when i'm testing connection in bids, can connect. in data source view, can explore data... when try to process cube or project, have following error : "errors in high-level relational engine. connection not made data source datasourceid of 'dwh', name of 'dwh'." is there here have idea resolve problem ? summarize, have ssas 2005 cube connected oracle 10g database, on windows 2003 r2 64bit sp2 server. thanks lot answers. regards changed of provider , seems work. used microsoft oledb provider oracle , i'm using oracle provider oledb , can process cube. SQL Server...

hi i have got sql server 2008 installed on machine. trying open dts packages under management studio. getting following error "sql server 2000 dts designer components are required eidt dts packages. install special web download, 'sql server 2000 dts designer components' use thi feature. (microsoft.sqlserver.dtsobjectexplorerui)" after this, downloaded , ran following 2 files sqlserver2005_dts.msi - sql server 2000 dts designer component sqlserver2005_bc.msi - sql server 2005 dts backward compatibility component then restarted machine , again tried open dts packages in sql server 2008 management studio. still getting same error. could me resolve issue? i have windows xp sp3 installed 2 gb ram. has got ms .net framework 3.5. it has got visual studio 2008 well. please let me know if need execute other file   thanks keyur         hello, please see following post: http://blogs.msdn.com/b/karthick_pk/archiv...

hi,                     using transactional replication updatable subscriptions in sql server 2005 . in our case both publisher , distributor same server. the subscription type pull subscription. set run in continuous running mode .                   can have more 1 publication in same distributor? please refer link below : http://msdn2.microsoft.com/en-us/library/ms152471.aspx this link has recommendation of following under heading " queued updating subscriptions" " there 1 queue reader agent each distributor. recommended each distributor, configure @ 1 publication enabled queued updating subscriptions. " in our case need have 6 publications 4 subscriptions each (totally 24 subscriptions). pls provide reply asap. thanks , regards, swapna.b. hi,               can have more 1 publ...

i ran mdx query on sql 2012 looking products , shipping status the code given below:                    with  set date1 as       strtomember( "[time].[2014].[q4].[2014-jun].[" +format(now()-2, "mm") + "/"+format(now()-2, "dd") + "/" +format(now()-2, "yyyy") + "]") set item1 as { [item].[itemid].allmembers} select non empty { [measures].[shipped qty], [measures].[shipped amt], [measures].[ordered qty], [measures].[ordered amt] } on columns,  date1*[item1] on rows [abcd]  where (               [channel].&[ol],               [geography].&[a.9]) the query gives desired output when run in sql. when run same query in while pulling data in powerpivot, dimensions i.e. date , item populated mea...

i have table looks this: ccy security pnl usd aaa 100 usd aaa 200 usd bbb 500 eur ccc 100 eur ccc 300 eur ddd 100 i'm trying create report looks this: ccy security pnl usd aaa 300 bbb 500 total 800 eur ccc 400 ddd 100 total 500 in order collapse multiple lines security description, i've grouped pnl subtotals security description , have report looks i'm unable create totals ccy: ccy security pnl usd aaa 300 bbb 500 eur ccc 400 ddd 100 hi milestogobeforeisleep, from description, have added group grouping ccy, , add child group grouping security. in case, if want add total row calculate sum of pnl each ccy, can refer following screenshot: report achieve req...

i trying write app show these points of data qa lab installer; rack (set of servers), server, project, branch, component, , build number. tell users software builds installed where. have written manually, want use data binding automatically pick updates our sql server. treeview ui design looks this: + rack --+ server ----+ project - branch - component - build number with rack , server treeviewitems, header set string, final node, tree leaf, uses stackpanel, textblock each of 4 values; project, branch, component, , build number. there functionality have different colors different install states plus tooltip shows user started install, start time, , stop time. additionally, there mouse left-click event on final tree leaf show log particular install. need ability have tree branch , tree leaf nodes handled differently. looking @ binding examples find, show bind string, know header can framework element. changed binding class use observablecollection have stac...

  hello,   in execute sql task, run following query:   declare @idlist varchar(max) select @idlist = coalesce(@idlist + ', ', '') + id from dbo.ids where rownumber >= 1 , rownumber <= 5 select @idlist idlist   it returns this:  014023, 418738, 42108, 420109, 041592   the result set set single row, , have result name in result set set idlist.   the variable trying put result string , following error:   error: 0xc002f309 @ execute sql task 1, execute sql task: error occurred while assigning value variable "idlist": "the type of value being assigned variable "user::idlist" differs current variable type. variables may not change type during execution. variable types strict, except variables of type object.   i'm guessing doesn't return value varchar , variable string.  have tried change variable char , had no luck.  not sure next.   thanks in advance help.   d i answered same query in sql cen...