Who is online?  0 guests and 0 members
Home  »  Blogs  »  SMcDonald

Communifire Blogs

Blogs RSS Feed

SMcDonald : Most Recent postings

SMcDonald

Execute a SSRS subscription based on new records in a table

1/15/2014 by SMcDonald  -  Comments: 0  -  Views: [706]

As many developers state in their blogs, "this is one way of several ways to handle a task/request". In the below example I am going to demonstrate how you can have a report execute based on new records being found in a table. The instructions provided below assume you have some experience navigating around BIDS. I am using SQL Server 2012 and the data source is AdventureWorksDW2008R2 database. In the first execute sql task, I am going to create a table and load sample data in it by using an exe...

Read More

SMcDonald

SSAS Definitions

4/5/2013 by SMcDonald  -  Comments: 1  -  Views: [3553]

A quick view of common SSAS Definitions: I used the definitions from the Microsoft's website and added the images to it.

Read More

SMcDonald

Scrolling Column Headers / Static Header Columns

2/12/2013 by SMcDonald  -  Comments: 2  -  Views: [7946]

It is often the common misconception that if you right click on the top left corner of your tablix and select tablix properties or even right click on the grey box to that is left of all the column names: Then select options for repeat header rows on each page or keep header visible while scrolling , that it will in fact do just that. Ah ah ah, not so fast. Unfortunately, it’s not that easy. What you need to do is click on the column row: Then you need to is click on the black upside down ...

Read More

SMcDonald

New Partnership with the Pragmatic Works Foundation

1/11/2012 by SMcDonald  -  Comments: 0  -  Views: [1716]

First and foremost, we were just interviewed by the Jacksonville Times Union and are hoping to have it printed on the front page of the Money section. I am also really excited to announce our latest partnership with Resume Rocketeer a local Jacksonville, Florida business owned by Cathy Eng. Often time’s people make the mistake of putting everything on their resumes or not really knowing the best way to articulate what experiences they do have. Resume Rocketeer is volunteering to help the s...

Read More

SMcDonald

The Foundation In The News

12/12/2011 by SMcDonald  -  Comments: 0  -  Views: [1852]

I am really excited to announce that we have been interviewed by multiple tv outlets as we continue to offer our free training class through the Foundation . Please see the below links: Media Outlet 1 Media Outlet 2 Look what Microsoft is saying about us: http://blogs.technet.com/b/dataplatforminsider/archive/2011/12/08/help-the-sqlfamily-give-back.aspx . Please contribute a story to the site and Microsoft will make a donation to the Foundation. If you are interested in applying click here .

Read More

SMcDonald

TSQL for the Absolute Beginner Series 1 of hmmm....not for sure

11/29/2011 by SMcDonald  -  Comments: 0  -  Views: [3614]

Let’s learn a little T-SQL. Yes, I am doing a series on T-SQL for the absolute beginner who is interested in understanding how to get specific pieces of information for their company’s data. Do you know what are the top selling products or who are the best sales people or maybe even who the best customers are? We are going to start from the ground up learning the environment of Sql Server Management Studio: , Connecting to a Database Engine , Querying your Database , Tables , etc. To...

Read More

SMcDonald

Why can't I make a data driven subscription?

11/21/2011 by SMcDonald  -  Comments: 0  -  Views: [3528]

The other day I was trying to create a data driven subscription for a specific report and I couldn't. For some reason after I applied my stored credentials to the data source in Report Manager, I could only create a New Subscription, but not a Data Driven Subscription. I honestly was baffled as to why I was getting this below error. I took all the necessary steps. I created the stored credentials in SSMS. Selected the database I wanted the access to and then applied the credentials on the data s...

Read More

SMcDonald

What's Next for Foundation

11/11/2011 by SMcDonald  -  Comments: 0  -  Views: [1474]

WOW! I can’t believe it’s that time already. The Foundation is now holding interviews for our upcoming class that will be held the week of December 5 th . There have been a lot of great things happening with the Foundation in the past 4 months. Our classes went from being held twice a year to every quarter and now they are held every other month. Brian Knight and I were interviewed by NPR News which will be airing soon. Also part of that interview was one of our student’s, Mitc...

Read More

SMcDonald

The Rewards of the Foundation

10/26/2011 by SMcDonald  -  Comments: 0  -  Views: [1925]

Hi All, My name is Sherri McDonald and the instructor for the Pragmatic Works Foundation. When I first started teaching the Foundation class, it was a nice addition to my current responsibilities. As I have facilitated the class for a year now, it is so much more to me than a "nice addition". In a quick elevator speech, our mission is to give new skills to people who have a passion about getting into the technology field. We offer this opportunity for free training to people who have served in t...

Read More

SMcDonald

Post Webinar: SSRS What Not to Wear...Reporting Services Style

10/3/2011 by SMcDonald  -  Comments: 0  -  Views: [2162]

I want to thank everybody who participated in my webinar “What not to Wear”…Reporting Services Style on September 29 th. Click here to download the zip file for the report that was created. You will also see other reports that are included in that zip file because this was an AdventureWorks reporting project. Here is the link to the instructions for replication. You will need to have the AdventureWorks2008(R2) database installed. If you need to download the databases you can g...

Read More

SMcDonald

What Not to Wear - Reporting Services Style Webinar This Thursday

9/27/2011 by SMcDonald  -  Comments: 0  -  Views: [1878]

Please join me this week as I discuss some of the WORST practices of Reporting Services Designs. Please join us for a 1 hour interactive webinar where your reports will go from leopard spandex print to Louis Vuitton. Learn about the options you have to improve your report design and rendering time all the way from the query level to the Report Manager. To register for the event that takes place this Thursday, September 29th, click here .

Read More

SMcDonald

SSRS: Use single transaction when processing the queries

9/20/2011 by SMcDonald  -  Comments: 0  -  Views: [11734]

September’s SSRS Classroom Question Today in our Day 1 SSRS class, a question was posed when we were setting up the Data Source. Question: “What is the Use single transaction when processing the queries?” Answer: You would use it to reduce the amount of open connections to the database. For example, if you have a report with 3 datasets and you don’t have this option checked, a new connection is made to the database for every single dataset. However, if you have it checked...

Read More

SMcDonald

Want a Chance for FREE Training @Pragmatic Works

9/2/2011 by SMcDonald  -  Comments: 0  -  Views: [3027]

I am super excited to announce that there is a strong demand for the Foundation Training to be held more frequently. Our last one was held in August and several people were hired for Jr. DBA and Report Writing opportunities. We also have more companies interested in looking at the candidates that go through the Foundation as well. It has gained so much attention that it was even recently featured in the newspaper. We try to offer this opportunity to individuals that have served our country, who ...

Read More

SMcDonald

Viewing Header / Footer Values in Excel after Exporting from SSRS

8/24/2011 by SMcDonald  -  Comments: 0  -  Views: [5922]

Today’s question in my SSRS class warrants a blog. The question was: “Why can’t I see my text box that I placed in my footer of my report, when I export the report to Excel?” Well, after much research today I realized that it was a common issue that many people are having. I did place a sample text box with “Test Text Text” in the footer. I exported it to excel. At first glance, you can see the header objects, but not the footer objects. I did a print preview ...

Read More

SMcDonald

My Foundation Class 8-15-2011

8/15/2011 by SMcDonald  -  Comments: 0  -  Views: [1334]

Today was the first day of our 3rd Pragmatic Works Foundation Class for 2011. We have a great group that is incredibly interactive. It's an interesting environment when you are teaching live compared to virtual training. The obvious is you will have more questions asked because the student is feeling a little more comfortable with you. We've been able to progress pretty well and will be on course for our Join conversation tomorrow. I have fortunately found and gave them a pdf of Pinal Dave's joi...

Read More

SMcDonald

Defaulting the Ruler option to On

8/4/2011 by SMcDonald  -  Comments: 0  -  Views: [7178]

SSRS 2008 and 2008R2 Default Ruler to On!!! In my last webinar, somebody had asked me if there is a way to set the ruler to on by default. First, if you haven’t accessed the ruler before, you will be able to find it near the zoom: When you have turned it on, it will appear like this: This is a nice feature to have for when you are trying to make sure that report is the appropriate size needed, i.e. printing in landscape or portrait. I did some research and this is what I found. You are only able...

Read More

SMcDonald

Value Displayed vs. Grouping

7/13/2011 by SMcDonald  -  Comments: 0  -  Views: [1457]

In the example below, I want to group on StateProvinceName, City and ResellerName. What I also want to do is have the Value display the State Code along with the StateProvinceName. Here is what I did to produce the desired results. 1. First you can see from the image below that I am grouping on 3 of my columns. 2. Here is what it looks like in my table now: 3. Remember, I want to display the StateProvinceName and StateProvinceCode. What I want do from here is Right Click on the StateProvinceName...

Read More

SMcDonald

SSRS 2008 Snap to Grid

7/13/2011 by SMcDonald  -  Comments: 0  -  Views: [10376]

Today in my reporting services class, I was asked how to get the Snap to Grid dots to appear in the designer. Here are some of the areas I checked to see if I could get them to appear: 1. I went to Tools / Options / HTML Designer and from there I chose Ruler and Grid. I changed the Line Style to Dots and altered the spacing to 10 and I didn’t see them appear. 2. I also went to Windows Forms Designer / General and changed the LayoutMode to SnapToGrid. ShowGrid and SnapToGrid is set to True and I ...

Read More

SMcDonald

Rotating Text Values for Vertical Text

7/11/2011 by SMcDonald  -  Comments: 1  -  Views: [5373]

A long time ago, Microsoft added a great feature to their Excel product. It allowed the capabilities to rotate text. Regrettably, this has been a long time waiting for reporting tools such as SQL Server Reporting Services. Another great addition to the SSRS 2008 R2 release gave us this same ability. We can now Rotate text. With that being said, here is a before look at the placement of our text value: What I want to do is take the text for Fiscal Year and rotate it for Vertical alignment. Here a...

Read More

SMcDonald

SSRS 2008 R2 June Webinar Details

7/1/2011 by SMcDonald  -  Comments: 2  -  Views: [4282]

Today I gave a presentation on how to create some awesome reports using the Sparkline, Map and Data Bar (all R2 features). I also discussed some of the different areas you could use expressions and showed some different examples. I am really excited that I had so many people join us today for Training on the T’s. First I want to share the TSQL script that I used for the my Sparkline report as well as the expressions used for that specific report. Queries (AdventureWorksDW2008R2): USE [AdventureW...

Read More

SMcDonald

SSRS: SIGN-UP for a Free Webinar Scheduled Tomorrow, 6/30/2011!!!

6/29/2011 by SMcDonald  -  Comments: 2  -  Views: [1820]

Webinar: How To Create Awesome Reports!!! I am really excited to announce that I have a webinar tomorrow (6/30/2011) with Pragmatic Works, Training on the T’s. This is going to be an exciting 1 hour event that will be packed with how too’s for some pretty cool features of SSRS 2008R2. Want a teaser? C’mon, you didn’t think I would really tell you too much, did you? Today and early tomorrow morning is the last chance to sign-up for the event. https://www1.gotomeeting.com/register/789320928 I am m...

Read More

SMcDonald

Can’t Access Report Manager

6/22/2011 by SMcDonald  -  Comments: 2  -  Views: [6399]

I want to thank one of my more recent students for giving me blog topic. I am not going to mention names, so thank you……… Hopefully, you are reading this and know who you are. After his question, I thought to myself, SELF I should share this with the WOOOORRRRRRRLLLLLLLLLDDDDDDDDDD!!!!!!!! Here is the question: I had to reinstall my SQL-Server 2008 server and now when I am trying to go to the URL http://svrsqlrpts/Reports/Pages/Folder.aspx , I am getting the error: User 'SVRSQLRPTS\AdminDBA' doe...

Read More

SMcDonald

Continuing Education with Free SQL Training

6/15/2011 by SMcDonald  -  Comments: 1  -  Views: [3100]

The first week of June I facilitated the Foundation class at our office. This is an opportunity for a free week of TSQL and SSRS training for individuals who have been displaced due to the economy or for military personnel who has recently gotten out of service or has retired from the service. One of the big concerns for individuals who participate in the training is how do I continue this training? How will I be able to afford to pay to get more intense training? What if I get a job, how will I...

Read More

SMcDonald

FREE WEBINAR - SSRS: How awesome are my reports!!!

6/8/2011 by SMcDonald  -  Comments: 0  -  Views: [2580]

That’s right, I said it. Do you want to look like an over achiever? Do you want your reports to stand out above the rest so your boss thinks you spent all night at home adding some personal touches? Join my session to learn how to use some of the cool R2 features and raise the bar report writing. Ok, that sounds a bit arrogant and it’s mostly humor behind it all. The purpose of this FREE webinar to take some of your basic skills and add to them by learning how to use some of the newer objects th...

Read More

SMcDonald

SSRS: AutoRefresh Property

6/2/2011 by SMcDonald  -  Comments: 1  -  Views: [23818]

Report Services Auto Refresh Option In one of my Virtual Training classes that I taught, I had a student ask a question that I felt was a great question and would be good to share the answer with the community. T he question was, “How do I get my report to automatically refresh so the end user of the report doesn’t have to constantly click the refresh button?” That is a great question, because I am sure that people commonly have to set their reports up in that fashion. I will show you two differ...

Read More