Lun

hi guys, hi have requirement build master detail report in ssrs. using 2012 version. please me building report same. new ssrs employer: abc companies                           year 2003                             name job sal dept                   total no of records: 4                       abc se 5000 it                   xyz sse 3000 sales                   abc1 tl 2000 marketing                   xyz1 pl 1230 sales                                                                             year 2004                             name job sal dept                   total no of recor

what best practice insert data table clustered index ?? - sql azure required it. mean programically scharp ?? i´m friend guid aren´t int :-(. create guid, check exist in table - if no: insert - if yes: create new , check again... for insert statements there no difference if (clustered) index exists or not, it's same. a candidate primary key + clustered index integer column identity property, generates auto-incremented values. olaf helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * wenn ich denke, ist das ein fehler und das beweise ich täglich blog xing Microsoft Azure  >  Azure SQL Database

hi, thanks in advance. this want do: let's have web project web1.csproj within solution file web.sln . if project has aspx page page1.aspx code behind page1.aspx.cs . want have web.sln , web1.csproj , page1.aspx.cs within 1 folder , page1.aspx within seperate folder. way when deploy production, can copy aspx files without copy code behind files, etc. your deliverable should sample solution solution, project , code behind files in 'code' folder , aspx pages in 'web' folder. should able work solution file in visual studio .net, , when compile, dlls should placed in bin folder within 'web' folder. could please me how resolve issue? regards, thankaraj i'd recommend posting question at: http://forums.asp.net/ they in better position are. brian Archived Forums V  > 

dear all,   i have started using sql server management studio requires server connection access database file. know if ssmsee function basic sql 2005 edition can open .txt or csv file extract necessary information. sorry if such lame question or if question not make sense.   thank all.... hi, welcome our sql server forums , post! sql server management studio express edition (ssmsee) graphic tool , used accessing, configuring, administering , developing components of sql serve express edition. if have not installed sql server express 2008, can download , install microsoft sql server 2008 express microsoft download center. once have sql server 2008 express installed, can use ssmsee 2008 connect , import files (such .txt/.csv/.xls) sql server databases using sql server import , export wizard. more information, please refer sql server 2005 import/export wizard . if more queries, please feel free let know. thanks, chunsong please remember mark replies answers

i trying put webbrowser control within accordion control oob app nothing shows up. changed app not an oob app , ran code expecting see "html enabled out-of-browser mode" message no show either.  is webbrowser control supported within accordion control. below code: <toolkit:accordion verticalalignment="stretch" selectionmode="zeroorone" horizontalalignment="left" expanddirection="right" > <toolkit:accordionitem header="report" > <stackpanel width="300" > <webbrowser x:name="wb" /> </stackpanel> </toolkit:accordionitem> </toolkit:accordion>   private void textblock_mouseleftbuttondown(object sender, mousebuttoneventargs e) { var apn = ((textblock)sender).text; str

as knows when creating project in tfs based on template reports created.  question has out created reports on top of out of box?  handy know out there , available. hi tumatawhero,   thanks post.   you can download tfs 2010 administrative report pack at: http://blogs.msdn.com/b/granth/archive/2010/07/12/administrative-report-pack-for-team-foundation-server-2010.aspx . , can try find more information grant holliday’s blog.           john qiao [msft] msdn community support | feedback us get or request code sample microsoft please remember mark replies answers if , unmark them if provide no help. Archived Forums V  >  Team Foundation Server - Reporting & Warehouse

in windows phone 8, can play audio under lock screen? hi gettinghelp , as mark yu - msft  said can play audio under lock screen. more details on:  http://msdn.microsoft.com/en-us/library/windowsphone/develop/jj206940(v=vs.105).aspx#bkmk_lockscreen regards. - chris. Silverlight  >  Silverlight for Windows Phone

hi, i looking t-sql to  list user databases size instance in sql server 2005 try code select d.name, round(sum(mf.size) * 8 / 1024, 0) size_mbs sys.master_files mf inner join sys.databases d on d.database_id = mf.database_id d.database_id > 4 -- skip system databases group d.name order d.name please click mark answer button , vote helpful if reply solves problem SQL Server  >  Getting started with SQL Server

hi all, i have table. time mo ncalls 12152 int 0 12152 tra 0 12152 iexstt 342 12152 sostt 6812 12302 int 0 12302 tra 0 12302 iexstt 304 12302 sostt 7509 how sum ncalls column according formula? inc=int+tra regards, /darus assuming name of table table1 . =calculate(sum(table1[ncalls]),table1[mo]="int" || table1[mo]="tra") SQL Server  >  Power Pivot

hi all, i creating report whereby data may overlap year. have got 2 categories; year , month. they in number format , when displaying graph numbers appear fine. want have month name. seeing thread  ( http://social.msdn.microsoft.com/forums/en/sqlreportingservices/thread/d28d07a8-a837-4339-9870-6c301d3ab96d ) tried memostone's suggestion , have changed axis format custom , made; =monthname(fields!month.value) however when view report, months january (the years still correct). i not sure whether i've put formatting in wrong place or if it's me using month.value wrongly, or else entirely! suggestions? thanks, student programmer hi, instead of putting formatting on axis, put on series. right click field mapped in category fields of chart -> category group proeprties -> label -> use same expression: =monthname(fields!month.value) regards, asim bagwan kindly mark replies answers if help!

hi all, per title, have ssrs report summary tablix @ top. body cell has action: go bookmark. the target second tablix set drilldown. groups hidden default. when action occurs, report jumps drilldown tablix rather bookmark. if groups manually shown, action jumps correct part of drilldown tablix. what action open hidden groups in bookmark target has parent context. can help? hi philmorrisblackrose, according description, after add go bookmark action go drill down report, if detail information expanded, can jump target position without problem, otherwise jump drilldown tablix. after add go bookmak action report, when preview report, jump taget position according bookmarkid design, there no event handle in report. not go hidden bookmark use go bookmark action. if have more questions, please feel free ask. thanks, wendy fu wendy fu technet community support SQL Server

 we have 2 server (2 computers)  , 1 sharepoint 2010 , second ms sql server , >> when try integrate sharepoint report server through sharepoint central administration --> report sevices integration .. go error " failed establish connection report server hi turki, welcome technet forum! which version of sql server reporting services using? if use sql server 2008 r2 reporting services or lower version, please first make sure report server switched sharepoint integrated mode through reporting services configuration manager. more information, please see: http://blogs.msdn.com/b/dynamicsgp/archive/2012/03/01/moving-sql-server-reporting-services-from-native-mode-to-sharepoint-integrated-mode.aspx   if use sql server 2012 reporting services, don’t configure sharepoint integrated mode through “reporting services integration” page of sharepoint central administration. since ssrs 2012, reporting services sharepoint integrated mode has been changed windows service sh

i'm trying loop through text in textbox word in order spellcheck it. i've split contents of textbox array, , loop through each word in array , run through spellchecker. when misspelling found, have popup listbox inside display can choose correction. issue i'm having, loops through whole array , ends showing last correction needs done. how pause loop waits selection made , resume? here's code loop:   foreach ( string checkedword in articlewords )         {             bool success = _spellchecker . checkword ( checkedword );             list <string> suggest ;             if (! success )             {                 suggest = _spellchecker . getsuggestions ( checkedword );                 spellchecklistbox . items . clear ();                 foreach ( string s in suggest )                 {                     spellchecklistbox . items . add ( new listboxitem () { content = s });                 }                 spellcheckerpopup

  hey want call javascript function website on selection of ctrl + m key not working as below::    private void layoutroot_keydown( object sender, keyeventargs e) { if ( keyboard .modifiers == modifierkeys .control && e.key == key .m) { htmlpage .window.invoke( "keycombo" ); e.handled = true ; }   } thx , got solution with keydown  able this   if ( keyboard .modifiers == modifierkeys .control && e.key == key .m) { htmlpage .window.dispatcher.begininvoke( delegate { htmlpage .window.invoke( "keypressed" ); }); }     Silverlight  >  Silverlight Controls and Silverlight Toolkit

hi i developing application in silveright 4. application has popup. i put popup window border , set cornerradius value appears rounded corners. wanted give custom gradientbrush border. created lineargradientbrush this. gave me lineargradient paint on border, not concept. let me explain   silverlight default gradientbrush behavior. parallel filling    this happens. gradientbrush not dependent shape   but want apply gradient window border. painting behavior must one...  here can see gradientbrush comes perpendicular shape. need perform kind of painting on border appears custom border graphics. there way create such gradientbrush or workaround can provide kind of brush resource?   i need stick requirement because window border.. , believe microsoft has done make real. can guys tell me how can achieved? appreciated. thank you   i created in expression design, think tweek need. <canvas xmlns="http://schemas.microsoft.com/winfx/2006/xaml/pre

hi , iam new area , having hard time getting the query run can on please throw light  part of sp tried import data excel sheet table in db run script never completes nor gives me error  declare @vfilenamewithpath   varchar(100)          ,@vsql               nvarchar(3000)  set @vfilenamewithpath = 'c:\clads\client list additions  records.xls' set @vsql = 'insert clientlist_temp_testdba              ( account)              select  [account]                   openrowset                    (''microsoft.ace.oledb.12.0'',                     ''excel 8.0;hdr=yes;database=' + @vfilenamewithpath + ''',                     ''select * [client list$]'')'  print @vsql  begin transaction exec sp_executesql @vsql   import import export wizard every thing works fine ,please help  in advance..... jack hi jack, i run query in machine. since mentio

  currently run database millions of records, , data continually being added. reports have created database generated slowly, , believe database has been optimised as possible.   in reading around believe generating cube possible solution, after reading advantages/disadvantages of cubes listed at:   http://businessintelligence.ittoolbox.com/documents/popular-q-and-a/advantagesdisadvantages-of-molap-rolap-and-holap-2934     and   http://forums.microsoft.com/msdn/showpost.aspx?postid=2444151&siteid=1   i not sure best our scenario. questions are:   1. can achieve increase in performance using cube?   2. given data isn't static (new data added daily) have regenerate cube if use molap or use have use rolap , suffer poor performance?   3. able reuse existing reports against cube or have create them again?   4. users requesting ad-hoc reporting. using cube offer advantages? hi! here answers!   1. yes can depends on questions being made to m

hi, i'm doing silverlight solution , in need set page orientation printed in landscape or portrait user's choice.  i've tried print using printdocument class, not find parameters allow type of customization @ time of printing. know if there way make class, or if there better way print documents in silverlight? need export content pdf if user wishes. hi jpovoas, if want print or export pdf silverlight, may take @ project in below link: http://silverlightpdf.codeplex.com/ further information on silverlight pdf library , printdocument class, please refer here: http://silverpdf.codeplex.com/ http://msdn.microsoft.com/en-us/library/system.windows.printing.printdocument(v=vs.95).aspx hope helps. best regards, Silverlight  >  MVVM / ViewModel Pattern with Si

hi attempting create .net framework 3.5, silverlight 4 application (with wcf ria services enabled) using visual studio 2010. however, when open web.config file, targetframework attribute set 4.0 (even though set project use v3.5) i cannot use .net 4.0 server app based on not support this. is bug vs2010? does silverlight 4 require .net 4.0? it's wcf ria services creating requirement. i'm pretty sure requires .net 4.0 have this. server supports 4.0 never thought check. Silverlight  >  Programming Silverlight with .NET – General

i have ria services project functions correctly, have web project , client project linked , web project startup.  run f5  the web project has silverlight debugging enabled. however when set breakpoints in client code never hit (symbols not loaded)  is there else needs setup enable client debugging?  thanks  rob usually, debugging right of bat, when install .net ria services. breakpoints not hit usually means wrong installed bits. provide more information:  which version of .net ria services (most our mix release) , silverlight have on machine? do breakpoints work in places (mainpage.xaml.cs) , not others (shared code)? can set breakpoints if create new project? does debugger.break() work if run in debug mode? usual checklist (most true): have asp.net , silverlight debugging enabled in server project (project properties-->web)? have <compilation debug="true"> in web.config? building in debug mode?

hello sorry if stupid question, but..... i have upgraded sql2005 , have local database containing 30 stored procedures, , cant find how upload these live server. in sql2000 there used import/export option copying objects, no longer there. cheers pie sorry, in addition when use copy tables , data tool, doesn't maintain increment fields. this same sql2000, why used copy objects tool. pie SQL Server  >  SQL Server Tools

i have listbox constantlly refreshing data. what options apply filtering? the listbox self don't have support of filtering data, display data in order data present in data structure bind it. need explicit filtering , linq easy way filter data, if data source of type ienumerable, can use linq custom filtering. you can use inotifypropertychanged make sure ui updated based on changes property (will update controls binds specific property), , use observerablecollection<t>: http://msdn.microsoft.com/en-us/library/ms668604.aspx  which can notify when collection changed , update ui automatically, example listbox or datagrid etc. can provide use more specifc problem want solve, example when want filter data, , when want listbox updated, kind of filtering want use, can give real scenario? give or different solutions problem. Silverlight  >

hi,  i have question regarding installation of sql 2005 express. have installed sql 2005 on backup box , in future change backup box production. however, question during installation, sql server 2005 created sql group in windows local user group.  such sqlmgrsever$computername...   how change group name when change computer name?  of registerd backup server name wanted know if there way can run scripts change computer name. i appreciate help   thanks   SQL Server  >  SQL Server Setup & Upgrade

hi, we've installed tfs 2008, created out own process templates , seems have been working fine. can create tfs projects using our templates , standard ones. however noticed couldn't access project portals via visual studio, option grayed out! if tried access portal site directly entering in url share point returned informing didn't have rights access site. i have noticed when looking @ group membership dialog, , clicking on windows sharepoint servers site administration link following error returned: 'the team foundation server not locate online site administration application team project portal in windows sharepoint services. cause of error language settings on team project portal not match current language of visual studio client. location of site administration specific language of project portal. contact team foundation server administrator availability information of site administration project portal. more information, see windows sharepoint services administrat