Tags » SSRS

SSRS: Sum() LookupSet Function

Here’s a handy piece of coding which might help you:
http://salvoz.com/blog/2013/05/27/sum-result-of-ssrs-lookupset-function/

You may use the SumLookup function to sum the results from LookupSet:
=Code.SumLookup(LookupSet(Fields!Parent_Number,Fields!Parent_Number.Value,
Fields!StoreCount.Value, “StoreCount”))
91 more words

SSRS

SSRS Report Deployment with BIxPress

You want more SSRS content? Ask and you shall receive. In today’s blog we will take a look at report deployment. If you have ever deployed an SSRS report before you know the process is straight forward for most part, minus permissions issues etc. 490 more words

Pragmatic Works

Making sense out of the Data

Data about everything is everywhere. You can’t escape it. These days the biggest challenge I see around is to manage Data and making sense out of it. 112 more words

SQL

SQL Server Reporting Services Tip: How to capitalize just the first letter of text?

Attention to detail is a key in creating SSRS reports/dashboards that look like a work of a professional; To that end, here’s a tip: How to capitalize the first letter in your string? 47 more words

Microsoft Business Intelligence

Filter Second lookup based on First Value - Ax 2012 SSRS

Hi Folks,

I got one requirement to get invoices of a customer on the particular month range in SSRS Report Dialog. I have achieved that and want share. 665 more words

Ax 2012

SSRS Parameter Expression: Previous Workday

Depends on whether your company works on a Saturday, but one of these SSRS Expressions will do the trick:

Basically WEEKDAY() will return the day number of the week, which will return: 108 more words

SSRS