miércoles, 22 de agosto de 2012

BARCODE PROFESSIONAL FOR REPORTING SERVICES 7.0


REVIEW
MS SQL SERVER REPORTING SERVICES
BARCODE PROFESSIONAL 7.0

INTRODUCTION
NeodinamycBarcode Professional for SQL Server Reporting Services is a high level library component that let you add barcode in your SQL Server reports solutions.

This product is very complete and has the following standards:


  • Lineal barcodes
  • EAN/UPC, Code 39/128, GS1-128, GS1 DataBar (RSS-14), EAN-13 & UPC-A, ISBN, ITF-14, SCC-14, SSCC-18, GTIN, PZN-8, VICS, etc.
  • Postals
  • USPS Intelligent Mail IM, Fedex, UPS, DHL, Australia Post, etc
  • 2D codes
  • QR Code, Data Matrix, Maxicode, Aztec Code, PDF417, etc.
  • All GS1 EAN/UPC Composite Barcodes (CC-A, CC-B &CC-C)
  • MICR E-13-B


Barcode professional has many more barcode standards and is compliant with the official
standards and specifications from organizations like GS1, ISO/IEC, AIM, EAN/UPC, and so on.


ADVANTAGES
  • Barcode image generation and printing support for 71 Linear/1D & Postal Barcode Symbologies
  • Barcode image generation and printing support for 25 2D Barcode Symbologies
  • Automatically computes checksum or check digits for all Symbologies
  • Automatically validates the value to encode
  • Written and handled in C#
  • Strong named assemblies for Reporting Services 2012, 2008, 2005 
  • 64-bit assembly for SSRS version 2005, 2008 & 2012
  • Barcode image formats support for the following formats  GIF, BMP, PNG & JPEG/JPG
  • Black and White 1 bit per pixel barcode image generation support
  • DPI support
  • Barcode rotation support (0, 90, 180 and 270 degrees)

PROFESSIONAL SUPPORT

This product is made by Barcode experts with strong know-how on .NET & SSRS. You can expect from
them a professional and excellent support with a 24 hours turnaround !

ADVANTAGES

  • GIF, BMP, PNG & JPEG/JPG barcode image formats support 
  • Monochrome (Black and White 1 bit per pixel) barcode image generation support 
  • DPI support 
  • Barcode rotation support (0, 90, 180, 270 degrees)

OTHER PRODUCTS

  • Neodynamic supports the following products:
  • Visual Studio 2005 / 2008 / 2010 & SQL Server 2005 / 2008 / 2012 Reporting Services – Report Server Project (design-time and runtime support) 
  • Visual Studio 2005 / 2008 / 2010 ReportViewer Local Reports (RDLC) (runtime support) 
  • ASP.net 
  • Windows Forms 
  • .NET Compact Frameworks 
  • WPF 
  • SDK for .NET 
  • Silverlight 
  • Windows Phone 
  • Report Builder 3.0
DEVELOPMENT
To perform the test of Barcode Professional, first we must install the BarcodeProfessionalSSRS70 in Windows Server 2008 R2 that has the Visual Studio 2010 Shell, SQL Server Data Tools and MS SQL SERVER 2012, the wizard install is very fast and easy.
Once in Windows Server 2008 click on 'Start' and then another click on the 'SQL Server Data Tools' as shown in Figure 1.

 
Figure 1

Once Visual Studio 2010 is opened, create a new project; choose 'Report Server Project' and select 'Business Intelligent' as shown in figure 2
Figure 2

Configure the barcode item for the toolbox, choose 'Tools' menu and click on 'Choose ToolBox Item…' as shown in figure 3
Figure 3

Select on the tab '.NET Framework Components' the option Barcode Professional as shown in figure 4 and save the changes.
Figure 4

Add a data source in your project, right click on the project, click in 'Add' and click 'New Item' as shown in figure 5.
Figure 5

Select 'Data Source' option in type Report Project as shown in figure 6.
Figure 6

After the select the name for data source and select the type Microsoft SQL Server choose change the Connection String with button Edit as shown in figure 7
Figure 7

Then configure the correct Connection String as shown in figure 8, in my case my server is named SERVERTEST, I use Window Authentication and my database is named dbTest01 and realizes the test with button Test Connection, if you get the connection status succeeded then you can continue.

Figure 8




Add the Report Item like figure 5 and choose 'Report Wizard' Option in type Report Project as shown in figure 10
Figure 10

This is the initial step and you can see the configuration that will be execute in the wizard as shown in figure 11.

Figure 11


In this step you can select the data source that you are created before; in my case my data source is called Database Test as shown in figure 12.


Figure 12



In this step you build the query for the report, as shown in figure 13.
In my case I have a table called products with the columns name_product, serial_product and id_product.
The serial_product column will be a barcode.
If the query is correct then you can continue.




Figure 13



In this step you can select the Report Type, I choose Tabular as shown in figure 14.


Figure 14

In this step you can design correctly your report, I choose the default configurations and I can finish the wizard with name report in default as shown in figure 15



Figure 15

Finally you can select the name of the Report as shown in figure 16 and finish the wizard


Figure 16

After the wizard you can see a design of your report as show in figure 17 where can changes the report title and Columns titles
Figure 17

In the toolbox, drag and drop the barcode professional item to serial_product column as shown in figure 18
Figure 18

Right click on serial_product column, click on Properties as shown in figure 19
Figure 19

You can choose the barcode symbology/standard as shown in figure 20 with preview of barcode and many configurations more.
Figure 20

You can see on the preview tab the preview of your report as shown in figure 21
Figure 21

Finally you can choose any barcode symbology/standard and generate the preview as shown in figure 22 with QR code selected
Figure 22

CONCLUSION
The Barcode Professional is a tool that generate reports with specific features for our barcode without that the client requires something extra in his/her computer, is very easy to use and is compatible with many Reporting Scenarios.

 It is a great tool to create barcodes.

REFERENCES


Publicado por en 16:25 0 comentarios
Etiquetas: , , ,
Suscribirse a: Entradas (Atom)