That someone would be me =).

No, I didn't install SSAS. I was just trying to see how much I could do in PowerPivot without using T-SQL. When I...

create a calculated column in your T-SQL to evaluate to 1 or 0 based on your rules, and then sort by that. (Although the sort order in your report will...

I would create a dashboard in Excel or PowerBI Desktop. Doing it in SSRS would be a lot harder.

Drill through in PowerBI Desktop is automatic. No programming or anything...

Maybe this will help?

Displaying Sorted Hierarchies[/url]

FirstDelim and SecondDelim are just (intermediate) Calculated Fields in my SSRS dataset. The result you're interested in is the third one that use FirstDelim and SecondDelim. You could...

I created two fields in my dataset

"TwoFields" is the name of the field containing the raw data

FirstDelim = INSTR(Fields!TwoFields.Value,"=")+1

SecondDelim = =INSTRREV(Fields!TwoFields.Value,"=")

=CDBL(MID(Fields!TwoFields.Value,Fields!FirstDelim.Value,Fields!SecondDelim.Value-Fields!FirstDelim.Value))

If you can, I would probably do as Alan suggested...

DATEADD(qq,DATEDIFF(qq,0,GETDATE())-3,0)

... returns a DATE value.

'2015 01' is a STRING value, not a date. You would have to turn that into a date... maybe split off the year, and add...

This worked with the data you posted:

CDBL(MID(Fields!TwoFields.Value,INSTR(Fields!TwoFields.Value,"=")+1,INSTRREV(Fields!TwoFields.Value,"=") - INSTR(Fields!TwoFields.Value,"=")+1))

I would design the tables in SQL Server and then maybe use Visio to document the relationships... and draw the pictures, but I'm not sure MS left that in the...

About the best you can do is once you add one field from your dataset to the tablix/matrix, then you can choose the other fields by clicking on the next...

Or you could install Reporting Services and do the reporting there... Kind of depends what kind of reporting you're doing. One thing that Access doesn't do well is crosstabs/matrix...

do it in your WHERE clause.

WHERE MyTable.MyDate>DATEADD(yyyy,-1,GETDATE())

Must be getting rusty...

FirstDelim =INSTR(Fields!TwoFields.Value,"=")+1

SecondDelim = INSTRREV(Fields!TwoFields.Value,"=")

FinalValue=CDBL(MID(Fields!TwoFields.Value,Fields!FirstDelim.Value,Fields!SecondDelim.Value-Fields!FirstDelim.Value))

So without the intermediate calculated columns:

CDBL(MID(Fields!TwoFields.Value,INSTR(Fields!TwoFields.Value,"=")+1,INSTRREV(Fields!TwoFields.Value,"=") - INSTR(Fields!TwoFields.Value,"=")+1))

The CDBL just converts the text string back into a number... only necessary if you're going to...

Alex,

Glad to help. Give it a try and post back if you get stuck. If you need help. post the CREATE TABLE scripts for the Budget and Actual...

Robert,

could you post the create table scripts and insert statements for some sample (representative, not necessarily real) data? Then I think your question would be easier to understand and...