Monthly Archives: February 2013
First Report – The Output
We’ve done a lot up to this point. Let’s Run our report and see the results. Click Run You’ll now see this screen: See the Last Update box? That’s the Parameter we set up a while back. Click the Calendar … Continue reading
First Report – Grabbing data
So far we’ve defined the basic data we want to bring back. Now we get to tell it how to behave. Click Next to get to the Arrange Fields step of the Wizard. Another section to practice on. Here’s what … Continue reading
Reports from CW Marketplace
I’ve learned enough that it’s time to see what others are doing. I know there are SQL queries in the forum, but I want to see a finished product from Report Builder. Best place to start is the CW Marketplace. … Continue reading
Uninstalling and Reinstalling Reporting Services
I finally got frustrated trying to figure out permissions in SSRS. I appear to have users in all the right places, but still couldn’t get network accounts to run reports via the web interface. My last ditch effort was to … Continue reading
First report – The Filter!
Meet your new friend, The Filter: A quick gotcha…. When you click the Add Filter icon, it defaults to the first Select Field in the list above. Click on the Field Name in the Applied Filters box to select the … Continue reading
First report – Design the query
Moving on to the fun part… Welcome to the “Design a query” window The basics Here’s what I’ve done for my report (Remember? All tickets not updated in the last 10 days.) The v_rpt_Service report tells me a bunch about open tickets. … Continue reading
Not encouraging
I know I’ll be gleaning all of my knowledge from the Internet and fine readers like YOU, but thought I would jump over to Amazon to see what resources were available for SQL Report Builder. Scrolling down, I hit this…. … Continue reading
First report – Start the wizard and define the data source
1) Create a New Report using the Table or Matrix Wizard 2) Create your dataset (I’m trying to figure out how to save a dataset so I don’t have to create it for every new report…. Doing this slowly, I … Continue reading
First report
My plan was to start documenting something super-simple (like Current Open Tickets by Member) and tweak from there, but I got a list of report requests this morning and felt like tackling one to see how much I understood at … Continue reading
CW Reporting 101 