Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

25425 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

SSRS: Report Creation

Part of Microsoft Reporting Services Basics

sql SSRS: Report CreationSSRS: Report Creation

We have so far configured, designed (albiet by wizard) & deployed our first report. Are we ready to create a report from scratch? Well this video will cover the basics of creating a report without the aid of a wizard.

Why create an SSRS report manually?

The more important question is why wouldnt you? Wizards are dumb, they are a fast way of creating a report that do not follow:

  1. Company Standards
    The looks are basic off a wizard, you may want a standard logo, standard font or any other standard format you want your SSRS report to look like
  2. User Criteria.
    If the user wants to filter the report the SSRS wizard performs filtering the easy way (also known as the WRONG way).  Filtering in with the SSRS wizard filters the data AFTER all records are returned.  I.e. if your data could should 1000 rows the wizard would happily return all 1000 and then filter.  This is sub-optimal.  You should instead filter the rows at source.

This will cover all the elements that a wizard does automatically(or not as teh case may be!) for you. What you will soon learn is the wizard is not that special, as you will be able to produce more acurate and professional SSRS reports without the aid of this safety net!

Related Posts

456 Comments

  1. Homero says
    10 Sep 14 at 3:20am

    This is just amazing! So simple and covering so many aspects at the same time. You have selected just the right topics to talk about, without going through booky stuff. I couldn’t afford not to leave my most sincere congratulations on the message board for your great work with these videos! This will boost my career big time.

    Hi from Mexico!

  2. evan wilder says
    04 Oct 12 at 7:44pm
  3. PCTeachME says
    01 Sep 11 at 10:34am

    Hi Mariusz, Firstly thank you for taking the time to put your feedback at length to me. I understand where you are coming from & only wish I had the time to go down a path which would facilitiate all requirements. There are some limiting factors which stops me from doing what you describe. These are; length of video I can post on YouTube, time to produce & finally the demand. If you require detailed information then purchasing MS books on the subject would be the best approach.

  4. PCTeachME says
    01 Sep 11 at 10:34am

    [..YouTube..] Hi Mariusz, Firstly thank you for taking the time to put your feedback at length to me. I understand where you are coming from & only wish I had the time to go down a path which would facilitiate all requirements. There are some limiting factors which stops me from doing what you describe. These are; length of video I can post on YouTube, time to produce & finally the demand. If you require detailed information then purchasing MS books on the subject would be the best approach.

  5. PCTeachME says
    01 Sep 11 at 10:34am

    [..YouTube..] @aristosamar Hi Mariusz, Firstly thank you for taking the time to put your feedback at length to me. I understand where you are coming from & only wish I had the time to go down a path which would facilitiate all requirements. There are some limiting factors which stops me from doing what you describe. These are; length of video I can post on YouTube, time to produce & finally the demand. If you require detailed information then purchasing MS books on the subject would be the best approach.

  6. PCTeachME says
    01 Sep 11 at 10:34am

    @aristosamar Hi Mariusz, Firstly thank you for taking the time to put your feedback at length to me. I understand where you are coming from & only wish I had the time to go down a path which would facilitiate all requirements. There are some limiting factors which stops me from doing what you describe. These are; length of video I can post on YouTube, time to produce & finally the demand. If you require detailed information then purchasing MS books on the subject would be the best approach.

  7. PCTeachME says
    01 Sep 11 at 10:34am

    @aristosamar Hi Mariusz, Firstly thank you for taking the time to put your feedback at length to me. I understand where you are coming from & only wish I had the time to go down a path which would facilitiate all requirements. There are some limiting factors which stops me from doing what you describe. These are; length of video I can post on YouTube, time to produce & finally the demand. If you require detailed information then purchasing MS books on the subject would be the best approach.

  8. PCTeachME says
    01 Sep 11 at 10:34am

    @aristosamar Hi Mariusz, Firstly thank you for taking the time to put your feedback at length to me. I understand where you are coming from & only wish I had the time to go down a path which would facilitiate all requirements. There are some limiting factors which stops me from doing what you describe. These are; length of video I can post on YouTube, time to produce & finally the demand. If you require detailed information then purchasing MS books on the subject would be the best approach.

  9. PCTeachME says
    01 Sep 11 at 10:34am

    @aristosamar Hi Mariusz, Firstly thank you for taking the time to put your feedback at length to me. I understand where you are coming from & only wish I had the time to go down a path which would facilitiate all requirements. There are some limiting factors which stops me from doing what you describe. These are; length of video I can post on YouTube, time to produce & finally the demand. If you require detailed information then purchasing MS books on the subject would be the best approach.

  10. PCTeachME says
    01 Sep 11 at 10:34am

    @aristosamar Hi Mariusz, Firstly thank you for taking the time to put your feedback at length to me. I understand where you are coming from & only wish I had the time to go down a path which would facilitiate all requirements. There are some limiting factors which stops me from doing what you describe. These are; length of video I can post on YouTube, time to produce & finally the demand. If you require detailed information then purchasing MS books on the subject would be the best approach.

  11. PCTeachME says
    01 Sep 11 at 10:34am

    @aristosamar Hi Mariusz, Firstly thank you for taking the time to put your feedback at length to me. I understand where you are coming from & only wish I had the time to go down a path which would facilitiate all requirements. There are some limiting factors which stops me from doing what you describe. These are; length of video I can post on YouTube, time to produce & finally the demand. If you require detailed information then purchasing MS books on the subject would be the best approach.

  12. PCTeachME says
    01 Sep 11 at 10:34am

    @aristosamar Hi Mariusz, Firstly thank you for taking the time to put your feedback at length to me. I understand where you are coming from & only wish I had the time to go down a path which would facilitiate all requirements. There are some limiting factors which stops me from doing what you describe.  These are; length of video I can post on YouTube, time to produce & finally the demand. If you require detailed information then purchasing MS books on the subject would be the best approach.

  13. PCTeachME says
    01 Sep 11 at 10:34am

    @aristosamar Hi Mariusz, Firstly thank you for taking the time to put your feedback at length to me. I understand where you are coming from & only wish I had the time to go down a path which would facilitiate all requirements. There are some limiting factors which stops me from doing what you describe. These are; length of video I can post on YouTube, time to produce & finally the demand. If you require detailed information then purchasing MS books on the subject would be the best approach.

  14. PCTeachME says
    01 Sep 11 at 10:34am

    @aristosamar Hi Mariusz, Firstly thank you for taking the time to put your feedback at length to me. I understand where you are coming from & only wish I had the time to go down a path which would facilitiate all requirements. There are some limiting factors which stops me from doing what you describe. These are; length of video I can post on YouTube, time to produce & finally the demand. If you require detailed information then purchasing MS books on the subject would be the best approach.

  15. PCTeachME says
    01 Sep 11 at 10:34am

    @aristosamar Hi Mariusz, Firstly thank you for taking the time to put your feedback at length to me. I understand where you are coming from & only wish I had the time to go down a path which would facilitiate all requirements. There are some limiting factors which stops me from doing what you describe. These are; length of video I can post on YouTube, time to produce & finally the demand. If you require detailed information then purchasing MS books on the subject would be the best approach.

  16. PCTeachME says
    01 Sep 11 at 10:34am

    @aristosamar Hi Mariusz, Firstly thank you for taking the time to put your feedback at length to me. I understand where you are coming from & only wish I had the time to go down a path which would facilitiate all requirements. There are some limiting factors which stops me from doing what you describe. These are; length of video I can post on YouTube, time to produce & finally the demand. If you require detailed information then purchasing MS books on the subject would be the best approach.

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security