Site sponsored by: Idera The gold standard of SQL Server performance monitoring & diagnostics.
SQL Server Performance

  • Home
  • Articles
  • Forums
  • Tips
  • Quiz
  • FAQ's
  • Blogs
  • Software
  • Books
  • About Us
RSS Feeds
Sign in | Join


Product Reviews

All Reviews
Audit Tools
Backup Tools
Change Management Tools
Clustering Tools
Coding Tools
Design Tools
Diff / Compare Tools
Documentation Tools
Job Management Tools
Log Recovery Tools
Monitoring Tools
Remote Access Tools
Reporting Tools
Security Tools
Testing Tools

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...
Latest Articles

Recover Data Using Database Snapshots
Analyze and Fix Index Fragmentation in SQL Server 2008
Powerful Geographical Visualisations made easy with SQL 2008 Spatial (Part 2) ...
Backup User Databases Using a Maintenance Plan

More     
 
Latest FAQ's

How to alter a User Defined Data Type?
How to unzip a File in SSIS?
How to view previous query plans?
ALTER TABLE SWITCH statement failed because the object '%.*ls' is not ...

More     
   
Latest Software Reviews

Spotlight on ApexSQL Doc 2008
ApexSQL Enforce
Embarcadero Change Manager
SQL Server DBA Dashboard

More     

reviews >> coding tools >> A Solution for Your Bar Coding Needs ...

A Solution for Your Bar Coding Needs From Barcode Professional

By : Dinesh Asanka
Feb 02, 2007

Page 2 / 4



Product Overview

Before looking at the features of this tool, it is worthwhile to review the most common bar code symbologies in use and which bar code symbologies Barcode Professional supports.

As you can see, there are many new bar code types available with this new release, especially mail bar codes from several countries. This is very helpful for those who are developing projects in those countries. MSI, PZN, ISMN, ESBN are the most important of the newly introduced bar code types. Also, there are many variations included in this new release.

Let us imagine a case for this. Assume that to capture physical stock we need to stick a label with stock items in those items. We will assume that it needs a product code, description and bar code.

First of all, we need to create a SQL Server Report Service (SSRS) project in the SQL Server Business Intelligence Development Studio. If we are using Barcode Professional for the first time, we need to add this to the tool bar.

For our purpose, we need to have a tabular report format and we can select needed data from the AdventureWorks database using the following query.

select ProductID,Name,ProductNumber from Production.Product

There will be an additional column to display the bar code of ProductNumber. We can insert a new column, drag the bar code tool from the toolbox and drop it on the column, then attach the column by right clicking on it and selecting properties. Yes, that's all we need to do. When run, the report will be "bar code enabled!"

There are few other advanced features available with Barcode Professional that we will get when we select the properties option of the bar code. Three of the four tabs on the properties dialog are important for us.

Bar Code Tab

This is the most important tab in the tool. Basically, this is where we can control its functionalities.

From this tab, we can select value we want to encode by choosing a field from the available list. Also, we can define the height and width of the bar code.


<< Prev Page     Next Page>>    








Home | Peformance Articles | Audit Articles | Business Intelligence Articles | Clustering Articles | Developer Articles | Reporting Services Articles | DBA Articles | ASP.NET / ADO.NET Articles | DBA FAQ's | Developer Peformance FAQ's | DBA Peformance FAQ's | Developer FAQ's | Clustering FAQ's | Error Messages | Audit Tool Reviews | Backup Tool Reviews | Coding Tool Reviews | Compare Tool Reviews | Documentation Tool Reviews | Design Tool Reviews | Monitoring Tool Reviews | Log Tool Reviews | Reporting Tool Reviews | Clustering Tool Reviews | Security Tool Reviews | Change Management Tool Reviews | Remote Access Tool Reviews | Book Reviews | Security Tool Reviews | QDPMA Performance Tuning | ADO.NET / ASP.NET | Administration | Analysis/OLAP Services | Application Development | Configuration | Components | ETL | Hardware | High Availability | Hints | Index | Misc | Operating Systems | Performance Tuning | Replication | T-SQL | Views


              © 1999-2008 by T10 Media. All rights reserved