Building your first SSRS Report --- How create to SSRS by using text editor OR C# Code

Earlier we have read how to create SQL Server Report by using wizard.Now we are going to learn creation of report by code or text editor.This might take time some time and patience so please be relax and start.

SQL Server included a services called "SQL Server Reporting Service in short SSRS".It helps in design, development,testing and deployment of report.It is developed by using Business Intelligence Development Studio (BIDS) in Visual Studio.

SSRS includes programming features which help you to customize reporting functionality.It provide comprenhensive functionality for a variety of datasource.

you can create interactive graphical or free from reports from multidimenstional datsource or XML-based datasources.You can see the report over web-based conncetion, Windows Application and over Share point site.


Click Here For More Details

Creation of SQL SEVER REPORTS BY USING BIDS FEATURE OF SQL

In all organization Reporting is used either Crystal Report or SQL Server Reporting Service.Here we are going to discuss creation and use SQL Server Report.We can develop  both static as well as dynamic report by using parameter.Generally we use stored procedure to create SQL Server Report.\

                                     Before  starting we should write a stored procedure which will used in data retrieving.

For developing SQL Server Report we have to follow following steps :

Step 1: Open Visual Studio.
Step 2: Click File ->New - > Project
Then you will get wizard having two columns :
a) Project Types & b) Visual studio Installed  Templates
From project types choose Business Intelligence Projects from left side and  choose Report Server Project Wizard.
Step 3: From Solution Explorer Right Click On Shared Data Source - >Add Shared Data Source
In this open wizard provide name of Shared Data Source and also provide connection strings.
Step 4: Now a blank panel will be open here you can use your own custom controls like table for rendering of data.
before attaching any control first we should create dataset.
Step 5: Creation of dataset :
Click on View in  Menu bar  -> Click On report data (The last of item View)
You will get a new tabbed  window namely Report Data.In this window we shall get three fields namely DataSource , Dataset etc.
Step 6: Right click on data set -  >  Add New dataset -  > click new datasource then a new wizard will be open.In this new wizard choose Shared Data Source which you have created earliar.Also choose query type either Text Query Or Stored Procedure.Here we are going to use stored procedure.
Choose name of your procedure from dropdown list.
After this you will get all the field of your table which is used in procedure.
Step 7: Now again come back to your reports design view.
Step 8: Drag & Drop table in which data will be rendered.
Step 9:Provide Header & Footer of Report
Step 10: Right Click on table's cell -->> Choose Expression -
->A new wizard will be open --> Choose Dataset -->> Choose fiels value-->> Click OK
Step 11 : Repeat this step untill your is not completed.
Step 12: Click on preview to view your report.
Step 13 : Provide parameter of the stored procedure.
Step 14: You will get your report also you can download it in any desired format.

For more upates stay connected.

How to become a good Programmer ....

Every IT - Professional wants to know How to become a good Programmer ....

 Good programming skills are essential to success and in discovering the joys of programming. As seen with many successful programmers over the past, here are some points that can be followed by those who are in pursuit of a successful career in programming.

Follw following essential steps f

or this.......

Work on Basics

As it is true for any industry and any job, the conceptual understanding is the key for success. Unless one has strong conceptual foundation, he/she can never be a good programmer. The core conceptual understanding helps you in designing and implementing the best solutions in the best possible way. If still you feel gap in core computer science and your programming language specific concepts, it’s never too late to go back and review the basics.

You learn more by helping others
Most of us have a common tendency of turning our heads towards forums or groups only when we need help. And again a clear separation between the good programmer and rest that the formers visit these places more often to help others. This makes them learn more then they learn getting their problem solved by someone else. Within a team as well, help others to solve their problems. Believe me, understanding others’ problem in their context, investigating on that and providing solutions; will leave you much more learned than before.

Write simple, understandable but logical code

As in almost every aspect of life, the formula of ‘Keep it simple and short’ works in programming as well. Write more logical code and avoid complexity. Sometimes people do write complex code just to prove their capability to write such codes. My experience says that simple but logical codes always works well, resulted in fewer issues and are more extendable. I remember an excellent quote

Spend more time in analyzing the problem, you’ll need less time to fix it

Spend more time in understanding and analyzing the problem and designing solutions for it. You will find the rest of the things quite easily doable. Designing not always mean using modeling languages and tools, it can be as simple as looking at sky and thinking solution in your mind. Those who have habits of pressing keyboard (for coding) the moment get the problem, usually ended us something different than the requirement.

Be the first to analyze and review your code

Although a bit difficult, but try to break your own code before others can and with the time you will learn to write close-to-bug-free code. Always do a close and unbiased review of your code. Also never hesitate to take others view on your code. Working with good programmers and taking their feedbacks will surely help you become a good programmer.

Don’t dismay yourself by looking at changing technology world

Over these periods in IT industry, I met with many people who are either disappointed by their work or even left it to search new job saying they want to learn and work in latest technologies. I don’t see any problem with this aspiration but the very first incorrect word is the ‘latest technologies’. What we are hearing everyday and mean here is new tools, APIs, frameworks and others means coming up everyday to make the programming easier and quicker. This anyway will continue in technology world. But what needs to be understood is that the core and basic technologies changes with much lesser pace than frameworks, tools and APIs around it. This is like the sea where the surface water moves very rapidly but the deep water is relatively calm and concentrated and most of the aqua lives survive here. So, feel yourself in that deep water and close to core technologies. For e. g. in Java enterprise world, lots of web frameworks exist and new ones coming every other week. But the core concepts of request based client-server communication, MVS pattern, filters/servlets/JSP, resource bundling, XML parsing etc remains same. So spend more time in learning these core concepts rather than worrying about ever changing frameworks and tools around it. Believe me, with the foundation of core concepts, you will always find easier to learn new frameworks, tools and APIs.

Don’t work for longer time

Many times software programmers implement work around solutions (may be because of lack of time, lack of problem understanding or lack of technology experience). But over the period these work around solutions always resulted in corrupting the code, making it less extendible and maintainable and lot of wastage of time later on. Always prefer to implement when you know the in-out of the solution. I understand that it becomes unavoidable in some circumstances, but it’s like, one should speak truth always but you tell lie in some circumstances.

Read documentation

One of the essential habits of good programmer is that they read lots of documentation. May it be specifications, JSR, API documents, tutorials etc. Reading documents helps you creating that essential foundation based on which you program in best of the way.

Learn from others code as well

I interacted with some excellent programmers who actually have java source project inside their IDE all the time and read/refer that in daily work. They do it not only to fulfill their appetite of knowing the basics but also to learn ways of writing good programs. Reading and referring reliable and known open source code or your senior’s code, can also help you making your programming better.

SEO Guide top ranking of website on Google.....

SEO Guide

Step  1 : Register exact match domain , use – or extra word if not available and get good hosting and “EXCELLENT and MODERN” Design on your website.

Step  2 : Write Content ( I copy and paste from other sites ranking on 1st page and modify it nicely ) and create accounts on all major social sites( PINTEREST , FB , TWITTER , LINKEDIN AND GOOGLE+)

Mandatory :

ADD ATLEAST 1 VIDEO.

ADD ATLEAST 1 RELEVANT IMAGE

ADD CONTACT STUFF ( chat , contact form , CLEARLY VISIBLE NAP(Name , address , phone number)

Add Social sharing buttons on all pages.

Add SOCIAL FOLLOW BAR/buttons

Add disqus or Facebook comments.

Step  3 : Modify and optimize ONPAGE OF WEBSITE

(I use Internet business promoter , Add ur website of URL and GET ATLEAST 60% SCORE ON report)

Install YOAST SEO , GOOGLE xml sitemaps for mobile,video and images plugins.

Completely fill out every step of yoast seo

Step  4 : Optimize for PAGESPEED INSIGHTS , There is an excellent chrome plugin for this, download it and it will actually give u optimized compressed images , gives u how to do performance better all stuff in the chrome extension.

Step  5 : Start BETA Testing on the blog , Making clear navigation , ordering pages semantically.l

ON EVERY PAGE ,

Add MICROFORMATS

Add SCHEMA

Increase the readibility by choosing OPEN SANS or ROBOTO Font on ur blog .

Make sure you have

TITLE TAG as keyword

H1 TAG as keyword ( 1 H1 TAG Per page)

H2 Tag as sub keyword ( can be multiple but should be less)

H3-H6 TAGS

Internal links ( Have 1 LINK ON EVERY PAGE link to another page on ur site)

External links ( Have 1 link on every page links to external site)

Step  6 : Now I Just take a list of sites ranking frequently on GOOGLE for many searches Say

YAHOO ANSWERS , ASK.COM , Yellowpages , wikianswers , quora etc

There are around 50-70 of them.

POST ON ALL THOSE SITES CLEARLY POSTING UR URL on relevant pages of these URLS.

Step  7 : Now that i got some links , START PINGING AND INDEXING

Submit sitemaps to google , baidu , bing , yandex.

Add ur site to all webmasters , google analytics

MOST IMPORTANT UPDATE WE OBSERVED IN 2014 :

Go to GOOGLE WEBMASTERS > Add ur website > Go to your website Dashboard > Crawl > FETCH AS GOOGLE >

Now click PREVIEW button and fetch ur URL

UNLESS YOU FETCH UR URL from FETCH AS GOOGLE Your new website will never be shown on search engines EVEN IF u create 10 million of links , You shud definitely fetch as google for new website!!!

Step  8 : Again find the top websites that rank in google frequently and post

Step  9 : Now you can start tracking your rank

YOU WILL HAVE Rankings at 85-105 on 9th , 10th pages.

Google again does some trick here :

Start doing submissions on 30-40 PR4+ Websites and then AGAIN Do fetch as GOOGLE .

Then ull see ur rank increases to 70th – 80th.

KEEP ON SUBMITTING TO HIGH PR , HIGH RELEVANT WEBSITES and do fetch as google until u get to 5th page.

Step  10 : Now just do CAMPAIGNS ON One software per Step 

SENUKEX CAMPAIGN for Step  11

GSA CAMPAIGN FOR Step  12

MAGIC SUBMITTER CAMPAIGN for Step  13

SCRAPEBOX campaign for Step  14

ON Step  15 , you will slight rankings deviation on 1st and 2nd pages.