Search Results: Code

• 
  Add Code39 barcode generation function into local reports

  The RDLC barcode library is used for adding Code 3of9 generation features into local reports. To generate Code 39 barcode images in RDLC reports, the Code 3 of 9 barcode library should be used as a custom assembly into the local reports Code section for V

  Author:  KeepDynamic     Date: 12/13/2012     Section: Forum

  tags : barcode, Reporting Services
• 
  Convert Address to Spatial Data - Geocoding for SQL Server R2

  If you want to use the new mapping feature in SQL server R2. You may want to get the Spatial data for the address data you have. There are several websites that can do this for you. Here are a few: http://batchgeo.com/ http://www.findlatitudeandlongitude.

  Author:  MikeDavis     Date: 5/5/2010     Section: Blog

  tags : Address, Geocoding, R2, Spatial, SSIs
• 
  How to create Day,Month,yearwise Cube in SSAS

  Well, there is a lot of concepts that you should take in consideration. 1st of all, you will need a fact table. In this table you should have a day code. This day code typically has YYYYMMDD format so it can be a integer and benefict from many advantages.

  Author:  marcoadf     Date: 2/10/2012     Section: Forum

  tags : code, day, month, quarter, table, time dimension, year
• 
  SSIS 2008 Setting proper case with a Script Component

  There is a command in VB that can be used to character data to proper case. This is the first letter of each word is capitalized and the rest is lower case. This is a great way to clean up a data base or is great to use when loading a data warehouse. Drag

  Author:  MikeDavis     Date: 2/17/2010     Section: Blog

  tags : .NET, 2008, c#, ProperCase, Script Component, VB, sss
• 
  Using Messages to Navigate in an MVVM Structure

  As a C# Noob, I've pretty much thrown myself in head first with my latest project. However, to do it right, I wanted to use the MVVM structure that's all the rage these days (and for good reason). I won't go into detail about what MVVM is, or why it can h

  Author:  RCharCox     Date: 2/21/2013     Section: Blog

  tags : C#, GalaSoft, MVVM, navigation, programming, XAML
• 
  Barcode Font in Reporting Services 2008 R2 When Printed From the RS Button Won't Scan

  I have a strange scenario, I'm using SSRS 2008 R2 native Report Manager to surface reports to warehouse managers. These reports contain barcodes so that the person can walk around and count goods while scanning, report is literally 2 text fields, the prod

  Author:  m3crast     Date: 4/29/2011     Section: Forum

  tags : barcode, SSRS 2008 R2
• 
  Commenting Best Practices and How to Improve Your Code's Readability

  When writing T-SQL, like most code, there’s a good way, a bad way, and a short way to do things. Sometimes, the short way and the bad way are synonymous. To assist in being able to write truly ACID (Atomicity, Consistency, Isolation, Durability) Com

  Author:  RCharCox     Date: 5/24/2012     Section: Blog

  tags : Code, Commenting, T-SQL
• 
  SSRS - Custom Code with External Assemblies

  In a previous post I wrote about how you can use embedded custom code to extend the capabilities of Reporting Services. This week I will show you another method of using custom code but this time with external assemblies. Ideally when using custom code yo

  Author:  DevinKnight     Date: 1/26/2012     Section: Blog

  tags : Custom Code
• 
  Jacksonville Code Camp 2012

  Hello one, hello all. It has been quite a while since I have blogged. I am looking forward to starting back up and get in full swing of the things again. This is going to be a short blog post as I am just letting you all know about a local Code Camp that

  Author:  briankmcdonald     Date: 10/4/2012     Section: Blog

  tags : Brian K. McDonald, Code Camp, presentation, sqlbigeek
• 
  Intro to MDX Session at Jax Code Camp 2010

  Well Jacksonville Code Camp 2010 is upon us and yours truly will be hosting a session. On Saturday, August 28th, 2010, Jacksonville Code Camp registration opens up at 7 a.m. The event will be held at the University of North Florida , which has a fantastic

  Author:  DustinRyan     Date: 7/22/2010     Section: Blog

  tags : Learn MDX, Jax Code Camp 2010
• 
  Run SSIS Package through Store Procedure

  Hi guys, I am kinda old question. I want to run my ssis package through Store Procedure. Please anyone can guide me. Here what i am doing and getting error/problems. First Step USE master GO EXEC sp_configure ' show advanced options' , 1 GO RECONFIGURE WI

  Author:  Mike     Date: 10/10/2011     Section: Forum
• 
  MDS Error: MDMMemberStatus does not de-activate members through the StgMemberAttribute table

  Master Data Services provides a way of de-activating entity members using the StgMemberAttribute table as described in Books On Line http://msdn.microsoft.com/en-us/library/ee633772.aspx This is a somewhat straightforward approach and requires for you to

  Author:  JoseChinchilla_SQLJoe     Date: 10/11/2011     Section: Blog

  tags : Data, De-Activated, Error, Master, Master Data Services, MDMMemberStatus, MDS, Services, StgAttributeMember
• 
  SQL Server “Denali”: SQL Server Developer Tools, codename ‘Juneau”

  Juneau is the code name for the new SQL Server Development Tool (SSDT), to be released along with the next version of SQL Server, codenamed " Denali ". Its purpose is to provide a single development environment for all database-related project types by br

  Author:  jamserra     Date: 7/6/2011     Section: Blog

  tags : Juneau, SQL Server, SQLServerPedia Syndication, SSDT, Visual Studio 2010, Denali
• 
  .net app to rendor SSRS report

  I've done something similar in a VB.Net ( 2005 ) windows application. I dropped a "ReportViewer" control onto the form and then set the following ( these are the 'main points' - not all of the code in between ). I only have to run this once per server tha

  Author:  KeithHyer     Date: 3/4/2011     Section: Forum

  tags : automation, report, report viewer, vb.net
• 
  Code and Slide Deck from Intro to MDX Session at JaxCodeCamp2010

  So if you missed JaxCodeCamp 2010, you missed one heck of a free training event! Each session I attended was incredible and I learned all kinds of new things even in some of the areas that I consider myself strong in. Any ways, my session Introduction to

  Author:  DustinRyan     Date: 8/30/2010     Section: Blog

  tags : Introduction to MDX, JaxCodeCamp, MDX
• 
  Error Code 0xC020907F - The Conversion returned status value 2 - error code 0xC0209029

  I finally finished creating my flat file test data for a series of SSIS practice exercises. While trying to create the finished project to break it down into smaller problems I ran into this error message: [Data Conversion [212]] Error: Data conversion fa

  Author:  MitchellPearson     Date: 11/22/2012     Section: Blog

  tags : DataFlow, Pragmatic Works, ssis, task factory
• 
  Semi-Additive Measures

  I think what you want is to navigate in your date hierarquie. In my SSAS I have this hierarquie: [Date] --> Year --> Semester --> Quarter --> Month --> Day With hierarquie functions you can easily navigate throw them. Some of the most used

  Author:  marcoadf     Date: 1/29/2010     Section: Forum

  tags : lag, nextmember, parent, prevmember
• 
  Map drillthrough works in VS2008, but breaks once deployed to reporting server

  Hi. I'm using Sql Server 2008 R2 for my reporting server, and for the BIDS environment. I have a map that displays just the count of customer locations. It uses 2 parameters, an AsOfDate (goes against a customer activity begin and end date), and a custome

  Author:  kenyayvette     Date: 4/5/2011     Section: Forum

  tags : bids, Reporting Services, sql server 2008 r2
• 
  JAX Code Camp 2011 Review and Slide Deck

  Y esterday, my wife (twitter: @sherrilmcdonald) and I spoke at JAX Code Camp 2011 in Jacksonville, Florida. The event was well organized and gave me the idea that a lot of time was spent in making sure that nearly all of the 300 attendees (approx.) were w

  Author:  briankmcdonald     Date: 8/28/2011     Section: Blog

  tags : andy warren, Brian K McDonald, brian knight, JAX CODE CAMP, sara hand, stan schultz
• 
  How to find Logistic Regression coefficient using SSAS (data mining)

  http://msdn.microsoft.com/en-us/library/cc645906.aspx#bkmk_Query3 By using the VALUETYPE enumeration, you can return only the coefficient for the regression equation, as shown in the following query: Copy SELECT FLATTENED MODEL_NAME, (SELECT ATTRIBUTE_VAL

  Author:  MMilligan     Date: 11/21/2011     Section: Forum
• 
  ssrs expression

  Do you have the date type column? If so, you can use format as this: =FORMAT(Fields!month_name.Value, "MMM") returns Jan =FORMAT(Fields!month_name.Value, "MMMM") returns January If you do not have the date type column, then you must do that for each and s

  Author:  marcoadf     Date: 2/22/2012     Section: Forum

  tags : case, code, expression, format, month
• 
  Get ready for the Third Annual SW Florida .Net Code Camp!

  Hey there database folks! Don’t be scared off by a little .NET. The SW Florida code camp is getting underway I’ll be there and so will a lot of other great speakers and Microsoft resources. Get all the details at http://codecamp.swfldev.net/ Thanks ! – Ho

  Author:  AdamJorgensen     Date: 9/6/2010     Section: Blog

  tags : Speaking, SSAS, Code Camp
• 
  Crap Code?

  Do you have Crappy Code? Do you live in London or UK? Come and participate in CrappyCodeGames evening in London on 31st Mar 2011 . Winners will be awared in SQL Bits 8 Register here

  Author:  meganathank     Date: 3/27/2011     Section: Blog

  tags : SQLBits8, CrappyCodeGames
• 
  SSRS - Embedded Custom Code

  When developing reports in Reporting Services you will often use the built-in expression language to make report data and formatting dynamic. The expression language can do a lot to within Reporting Services but any gaps in functionality that it has can b

  Author:  DevinKnight     Date: 1/5/2012     Section: Blog

  tags : Custom Code
• 
  Additional xml code appears in my SSRS 2008 report when saving it

  Currently I am having a problem with a report which I have been developing with SSRS 2008. My platform is Windows 7. The reports was created in BIDS a while back and so far it has been working well. Yesterday, after I made some small modification to it an

  Author:  sibir1us     Date: 5/24/2010     Section: Forum

  tags : 2008, additional xml code, bug, SSRS