Creating SSRS Parameters—From Simple to Complex

As you know, adding parameters to a SSRS report gives users the ability to filter and format data. In this post, we’ll show you an easy way to add parameters in SSRS, how to add drop-downs and how to allow users to select multiple parameters.

While there are a number of ways to add parameters in SSRS, one of the quickest is directly from Query Designer.

Use the form @variable_name. This will automatically create parameter objects in your report:

Read more

Finance vs. Sales—Why Your Data Marts Don’t Tie Out

iStock_000029300212SmallIn this blog post, I describe a challenge we’re having with SSAS cubes. In this case, the challenge isn’t caused by technology. It’s caused by data.

Here’s the situation: Our client has used SSAS to build several cubes for reporting, which they’re using to replace a no longer supported version of Business Objects. We’ve been asked to review the Business Objects reports and create new reports using SSRS with these cubes as a data source.

While my client has some technical challenges and room for optimization, my technical folks are handling that aspect of the project well. But the project also has a larger challenge: The client has two different SSAS cubes, one built from sales data from the order processing system and one built from general ledger data. And the two cubes don’t always agree. This is a problem. Only the sales cube can give information by product. And only the financial cube can give true profitability.

Read more

On the Limits of Human Metrics

My friend Dianna Huff responded to my recent post on hiring techies who fail. She sent me a link to a Wall Street Journal article about how some companies are asking for SAT scores as part of their application process. Dianna noted that, given this screening practice, she would never get hired today.

I suspect most of my consultants did well on their SATs, but I’m not going to ask. (And for those of you wondering, I’m enough of a Jewish, competitive, neurotic geek that I remember my score.) Although SATs measure the kind of cognitive ability you need to work with systems, it strikes me as a very limited measure of capability for most corporate positions. Judging someone’s basic intelligence has never been my challenge. I can usually figure out whether people have the mental capacity to do what I need by using a combination of interview questions and, more importantly, problem-solving questions related to the work we do.

Read more

SSRS Tabbed Reports

Everybody who’s online these days uses tabs (even Internet Explorer users!). Yet SQL Server Reporting Services doesn’t natively support tabs for its reports. It does, however, support all the building blocks necessary to create tabs yourself. In this post, we’ll post show you one way to do it.

So when would you want to use tabs? Let’s say you have multiple companies within your organization. Perhaps you’d like the first tab to show consolidated results for the company and then subsequent tabs to show results for each subsequent company. Or perhaps you’d like different tabs for each line of business or sales person?

In our example, we use data from Lawson GL where company is a legal entity and Acct Unit is a profit center.

Let’s use a simple report created by the SSRS report wizard to illustrate:

Read more

123102

Contact Us:

646.736.0060

Sign up for our reporting tips newsletter:

First Name
Last Name
* Email
* required