Not near enough information to help.

What does the signature of the stored procedure form Oracle look like?

storedproc_name

@param1 <datatype>,

@param2 <datatype>

If the stored procedure already has paramters, are you trying to use...

By far the easiest way of dealing with stuff like this is by using a Calendar table. Then you can get ANY day of ANY week...

SELECT ..

FROM CalendarTable

WHERE WeekNumber...

Why not just cascade the parameters?

First one is Elementary/Middle/High School

Second filters based on that.

SELECT Grade FROM src WHERE Level = @Parameters!Level

Think if it this way:

T-SQL does all the data manipulation

VBA does the front end stuff (if you're using something like an Access FE and a SQL Server BE) -- pretty...

Not sure if it's possible, but one way might be to use an ADO connection from inside Excel to push the results to SQL Server...

This looks like a pretty good answer:

https://answers.laserfiche.com/questions/48435/SQL-Transaction-Log-is-taking-up-all-drive-space

Then read Gail's articles:

http://www.sqlservercentral.com/articles/64582/

http://www.sqlservercentral.com/articles/Transaction+Log/72488/

John,

Any chance you can upload a copy of your report? The fun part is that you have to provide some data for it. So you have two options:

1....

If you're using a matrix, you need at least one Row Group and one Column Group as well as one Aggregate...

So... this worked for me:

Row Groups: [PeriodEnd] (or the date...

Might sound like a dumb question, but what happens if you add a table to the report and drop the fields into a tablix but don't filter it. Just...

Okay, I was going to use a Calendar table to force the dates to exist. DAX is just still kind of mind-boggling.

I figured out the solution after the...

Not much for details. BOL (Books On Line... hiding under the F1 key) is your friend. Check out this article on CHARINDEX. It should get you started. ...

Here's the cool thing with DAX. You don't need a "proper" data warehouse. it works better if you have one, but it's not necessary. There are a...

If you have a copy of Office Professional Plus, then you can do a bunch of stuff with DAX and PowerPivot. Check out Kasper de Jonge and Rob Collie's...

and it takes a fair amount of time to learn... =) Not to be a wet blanket, but you get out what you put in.

I would imagine there is. Kind of depends on how good you are at SSIS, SSAS and sometimes SSRS. Ask Koen... he does it every day.