Saturday, October 1, 2016

Adding Meta Description & Keywords to Blogger - By Wide Info Blog

Blogging is one of the simple, easy & an interesting way to share your ideas, technology, tricks, tips & information with the world. Blogger.com provides free blogs & templates. Now you can easily make your free blog with the help of blogger. 

There are millions of people who are writing blogs & are also liked by the readers. This blog - Wide Info Blog provides blogger tips, tricks & tutorials. Previously we have discussed - Show Post title before Blog title in Blogger.

Here are the steps for adding meta description & keywords to blogger.
Step - 1. Login into your blogger account & select the blog to which you want to add meta description & keywords.

Step - 2. Now, go to "Template" tab & click "Edit HTML" as shown below
Step - 3. Now search for <head> in the template using ctrl+F, & paste the following code right after <head> as shown below.

<meta content='Your Blog Description' name='description'/>
<meta content='Keyword1,Keyword2,Keyword3' name='keywords'/>


Replace :: 

Your Blog Description                  :: by your blog description

Keyword1,Keyword2,Keyword3 :: by your blog keywords

Now save your template & enjoy. For latest blogs keep visiting - WideInfoBlog. If you like, please share it with your friends.
Read More »

How to Use NVL, Decode & to_char in Jasper Reports - By Wide Info Blog

This blog - Wide Info Blog provides blogger tips, tricks & tutorials. Previously we have discussedHow to Add QR Code in Jasper Reports. Today we are going to discuss about NVL, Decode & to_char in Jasper Reports.

NVL Function :: NVL function is basically used to replace "null" by our own keywords like - NA, Not Available in Jasper Reports.

Syntax::  NVL(CUSTOMER_NAME, 'NA') as CUSTOMER_NAME,   

CUSTOMER_NAME  is the column name on which NVL function is applied. If this column will be blank or null the 'NA' will be displayed in place of null or blank in results. we can also change 'NA' to as per our requirement.

Decode Function ::  Decode Function is used to decode the flags used in the database. Suppose we have used 

N = NO
Y = YES

But default results will show only N & Y, which may be difficult to understand for others. So, we use the decode function like-

Syntax ::  decode(VERIFICATION_REQUIRED, 'N', 'NO', 'Y', 'YES')VERIFICATION_REQUIRED

VERIFICATION_REQUIRED is the Column name to be decoded.  Here 'N' is decoded to 'NO' & 'Y' is decoded to 'YES'.

TO_CHAR Function :: This function is basically used to decode date in Jasper Reports. default format of date in jasper reports is like --  1/16/15 12:00 AM

So to avoid this we use the to_char function.

Syntax ::  to_char(FILE_DATE, 'DD-MON-YYYY')FILE_DATE

FILE_DATE = column name

DD-MON-YYYY =  Date format (10 - DEC - 2015)

or we can use

DD-MM-YYYY  =  Date format (10 - 12 - 2015)
Read More »