Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Sunday, 24 September 2017

How to view computer hidden files in Windows 10, 8.1, 8, 7 and XP?

In Windows, to view hidden files are quite easy. In this article, we will see how to view hidden files and folders in Windows 10, 8.1, 8, 7, and XP.

Note: Hidden files and folder appear lighter in color than normal files.

Windows 10/8.1/8

To view hidden files in Windows 10/8.1/8 follow these steps:
 
Hidden files image 1

1)    Open My Computer or Press Window key and E.
2)    In the Menu Bar click ‘View’ tab located in top left corner of the screen.
3)    Check the Hidden items field.
4)    And you are done. The hidden files automatically become visible to you in a lighter color.

Windows 7

To view hidden files in Windows 7 follow these steps:
 
Hidden files image 2

1)    Open My Computer or Press Window key and E.
2)    In the Tool Bar click ‘Organize’ button located in top left corner of the screen. Select folder and search options.
3)    A Folder Options dialog box open. Click the ‘View’ tab.
4)    Select show hidden files, folders, and drives. Click ‘Ok’ button to save the settings.
5)    And you are done. The hidden files automatically become visible to you in a lighter color.

Windows XP

To view hidden files in Windows XP follow these steps:
 
Hidden files image 3

1)    Open My Computer or Press Window key and E.
2)    In the Menu Bar click ‘Tools’ tab located in the top left corner of the screen and then Folder options.
3)    A Folder Options dialog box open. Click the ‘View’ tab.
4)    Under Advanced settings. Select show hidden files, folders, and drives. Click ‘Ok’ button to save the settings.
5)    And you are done. The hidden files automatically become visible to you in a lighter color.


Hope you find the article helpful.


For any query, comment us below.

Previous – Top 10 Run Commands #6


Click imagination hunt to read latest blogs.


Keep learning and sharing...
Read More »

Saturday, 23 September 2017

How to create the SSRS Report using SQL Server and Report Builder?

In this article, we will learn how to create a SSRS Report step by step. But first we need to see what are the software requirements: -

(1) First, we need to have a MS SQL Server. Download SQL Server.
(2) Second, we need Report Builder. Download Report Builder directly from here.

Database

For this article, I am using the tblTeacher table of MySchoolDB database. Click to read more about How to create the table in SQL Server.

Report Builder

For this article, I am creating Teacher Report using the above the tblTeacher table. I already wrote down all the SQL queries please do copy the queries to proceed.

We will proceed step by step to understand better.

Step-1: Open the Report Builder with Administrator permission.
SSRS Creation Image 1

Step-2: Create a new blank report. Once you click blank report, a new report window open.
SSRS Creation Image 2

As you can see the below image I have marked important four points.
SSRS Creation Image 3

(1) Click on the Insert menu to get the options how you can design your report. For this you can use Data regions(Table, Matrix, List), Data Visualization(Chart, Guage, Maps, Data Bar), Report Items(Line, TextBox, Image, Rectangle), Sub-reports(means report in a report) and suitable Header and footer.
(2) This shows the report design window. I am using Line, Textbox, and Image to create my first report. What you have to do is double-click this item and the item will add-up to your design window.Once added arrange these items as per your report design.
(3) In this region, you will add the data source, dataset, image, and parameter.
(4) And last is the Run button to preview your report.

Step-3: Add the data source see image below. For that R.Click Data source -> Add Data source -> Change the data source name -> Select Use a connection embedded in my report. -> Select Connection type as “SQL Server” -> Click Build button -> Add up the credential -> Select database name as “MySchoolDB” -> Click Ok -> Test Connection it must give “Connection created successfully”. If it failed then maybe your credentials are not correct or check whether the database service is running or not. Not sure how to check database service is running or not. -> Click Ok. Your data source is created.
SSRS Creation Image 4

Step-4: Add dataset see image below. For that R.Click Datasets -> Add Dataset -> Change the Dataset name -> Select Use dataset embedded in my report. -> Select DataSource1 -> Click Quick Designer button -> Click “Edit as Text” on top left corner -> Write your sql query ” select * from tblTeacher where teacherCode=1” and click Ok button -> Click Ok. Your dataset is created.
SSRS Creation Image 5

Step-5: Now, prepare a design for the report. Once completed your report will look like this.
SSRS Creation Image 6

Step-6: Once completed. Click the Run button to preview your report.

Step-7: You can download the report in available format.
SSRS Creation Image 7

Hope you find the article interesting.


For any query, comment us below.



Click imagination hunt to read latest blogs.



Keep learning and sharing...
Read More »

Thursday, 21 September 2017

Creating table in SQL Server

In this article, we have prepared queries to design database and table.



We have designed this table as per our need to create SSRS report.

--Creating database
create database MySchoolDB

--Using database
use MySchoolDB
Go

--Creating table
create table tblTeacher
(
TeacherCode int identity(1,1) primary key,
TeacherName varchar(50),
Address varchar(50),
City varchar(50),
State varchar(50),
Pincode varchar(6),
Designation varchar(50),
DOB varchar(10),
AdditionalInformation varchar(300),
Salary money,
CurrDate varchar(10),
Remarks varchar(100)
)

--Inserting records in table
insert into tblTeacher(TeacherName,Address,City,State,Pincode,Designation,
DOB,AdditionalInformation,Salary,CurrDate,Remarks)
values('Vijay Singh','Sector-100, H.No-1000, ABC Society, XYZ Nagar','Nirman Vihar',
'Delhi','100000','Head PE Coach','21-09-1979',
'Vijay Singh holds a BPE in Physical Education from Delhi University. He was assigned this job in 2003 as Assistant PE Coach.',
70000.00,'21-09-2017','This is system generated report.')

--Retrieving records from table
select * from tblTeacher



Use above records in our following SSRS Reporting article series.


For any query, comment us below.



Click imagination hunt to read latest blogs.



Keep learning and sharing...
Read More »

Monday, 18 September 2017

Soaked Chickpea (Chana) are the new beneficial to eat apart from almond.

Soaked Almonds? Remember your mom asking you to eat soaked almonds every day in the morning.

Soaked Chickpea (Chana) are the new beneficial to eat apart from almond. Chickpeas are both high in protein and fiber with starch elements; thus making you feel full and curb your heart’s desire for junk food and unhealthy sugar cravings.



Chickpeas are full of nutrition; it is full of high levels of vitamin B, phosphorus, folate, zinc, and iron; all of which are important if you are a vegetarian or a vegan and not missing out on the nutrients and protein.



Chickpeas can also be great evening snack or a running breakfast for those with a fast-paced life. You can combine chickpeas with a little of black pepper and salt, also add some tomato and onion to put some added flavor to the much-needed protein.
Read More »

Friday, 15 September 2017

Gifts Section: Period edition | Gifts For Women on Their Period

Are you a guy with less than a dime’s clue as why is it good to gift something to your girlfriend, wife or your mother when they are on their period.



Have you been in the problem for a small mistake during her period? Is she calling and not talking to because of the smallest mistake you did while she is on her period.

Fear not mate, let us help you in this section of “Gift section”

1.Chocolates: Every girl on their periods love some sugar and gifting her the favorite chocolate with some added donuts and a hot coffee will brighten up her mood and will win u a cute smile and some more level of trust. Sugar also boosts mood in general, just like a run; it boosts the level of happy hormones in the body.

2.Perfume: Buy her the special fragrance which just hit the market, because who doesn’t love a perfect fragrance around themselves. The power of smell is high psychological wise due to the fear of smelling bad during the period.



3.Punch Bag: Girls scream in pain, an upheaval of emotions and always have the urge to hit something or someone, trust us, if given a chance every girl will punch because of the pain. Be a bit innovative and set up a punching place dedicated her during her period to ease her pain, emotions and putting her at peace.
Read More »

Thursday, 14 September 2017

Best Ways to Relieve Period Cramps | Menstrual Pain

Managing Pain: Period. Have you started to live comfortable in that bubble for 5 days of the month?
Are you feeling blue and want to stay hidden those few days?
Do you have constant pain where you want to cry or hit someone?



Let us help you with some tips to tackle the pain

1. Massage your tummy and mostly your back to help the flow of muscles and blood is in a smooth
way, clearing all the obstruction.

2. Have ajwain with warm water to ease the pain.

3. Drink ample amount of water for bloating and easement of the flow through your body.

4. Though many people ask to have hot things while on periods, avoid coffee as it adds to the
cramp pain.

5. Try covering up your feet and legs, it keeps your body a bit hot.



6. Keeping your body temperature a bit hot, you can use hot water bottle with putting it on your
tummy, back.

7. Do a bit of stretching or some yoga for not putting your body in stiffness.
Read More »

Tuesday, 12 September 2017

Pipe and Cistern Short trick | Part 2




Read More »

Saturday, 9 September 2017

Pipe and Cistern Short trick | Part 1

Read More »

Thursday, 7 September 2017

Free Discount Coupons code: Cashback, Offers and Promo code


Flight Booking Coupons/Offers save large using our flight coupons



MobiKwik Coupons/Offers



Nearbuy Offers/Coupons


Pizza Hut Offers/Coupons


Read More »

IBPS Examination for Clerical Cadre Across India I Last Date to apply: 03 Oct 2017

IBPS Clerical Notification 2017- Apply Now

Date of Posting:07/09/2017

Company Name and Type: IBPS has given notification for recruitment of clerical cadre job.

Nature of Job: Bank job


Last date of submission: 03-10- 2017

Hiring Process: Selection will be made by online written test

No. of Vacancy: not mention yet

Qualification
: Any Graduate




Age limit
: Minimum 20 Year and Maximum 28 Year

Application Fees: For General Candidate- Rs. 600

                               For SC/ST/PWD Candidate –Rs. 100

                               For OBC Candidate-Rs. 600

How to ApplyClick on link to apply online

All the Interested candidates who fulfill the above eligibility criteria may Apply Online by visiting the website during 12-09- 2017 to 03-10- 2017 and no other mode of application will be accepted.

Website: www.ibps.in

Notification: Click Here

Start date for Online Registration: 12-09- 2017 to 03-10-2017

Last Date of Payment Application fees: 30-06- 2016

Download Pre Examination call letter: November 2017




Online Pre Examination date: 02-12-2017,03-12-2017,09-12-2017 & 10-12-2017

Online Main Examination date: 21-01-2018

Provisional Allotment: April 2017




For any query, comment us below or read the full advertisement.



Keep learning and sharing...
Read More »

Monday, 4 September 2017

Love to see your skin glow with radiance? I Love when people compliment you?

Love when you can’t stop looking at yourself in the mirror?

We want you to glow more than ever this summer. And we are here to make this possible through some healthy and tasty diet changes.


1. Berries: Strawberry, blackberry, blueberries are all beneficial for your health and skin with an additional low sugar count. They are high in vitamin C, helping you glow and maintain the elasticity of your skin. U can find frozen berries in India and can make some yummy and healthy smoothie for your appetite cravings.

2. Avocados: They are rich in vitamin E and acts as a fat soluble. If you cannot find avocado as a whole, u can have bottled juice instead.


3. Walnuts: Walnuts are high in Vitamin B and helps in anxiety, stress management, mood control and prevents skin disorder. It also contains elegiac acid which help the body in fighting against cancer.
Read More »

Featured post

Think that makes you rich and richer

 Napolean said: “You can think and grow rich, but if you can be brought up like most people with work and you won't starve, this wil...