I had this kind of fun just today on SSRS 2012. I went into the dataset and re-ran the query from within SSRS. that fixed it for some...

I need to change the code so the report selects data 14 days before and 14 days after the selected date.

WHERE [DateColumn] BETWEEN DATEADD(days,-14,@DateParameter) AND DATEADD(days,14,@DateParameter)

not sure about the sequence...

What are you trying to do? (Explain the business part, not the math.)

Can you give a really simple example? Do you have a table you're trying to join...

Short answer - you need to turn this into a totals query and group by everything but the date. Get MAX(Date). Or use a subquery to return only...

Maybe it's the lack of coffee or something, but the basic matrix is simple, but getting the % of Internal at the bottom as a pain. (I'm starting to think...

make a copy of the report.

in the new copy (for the restricted folks), change the parameter to single value. (turn off Allow Multiple Values).

I'm pretty sure you can leave everything...

Finally dug up Itzik's book on T-SQL 2008...

-- from p.458 "Inside SQL Server 2008 T-SQL Querying" By Itzik Ben-Gan

SELECT 01.empID,

CONVERT(VARCHAR(7), o1.ordMonth, 121) AS toMonth,

o1.qty AS qtyThisMonth,

SUM(o2.qty) AS totalQty,

CAST(AVG(1 * o2.qty)...

Check out this article by Dwain Camps...

https://www.simple-talk.com/sql/t-sql-programming/calculating-values-within-a-rolling-window-in-transact-sql/

there's an example using 2008 that doesn't use windowing functions.

This is my attempt at applying what he wrote... maybe it's because it's stupid late,...

I would probably do it this way:

Package---(1,M)--Contains--(M,1)--Items

CREATE TABLE Contents (

PackageID INT NOT NULL,

ItemID INT NOT NULL,

Qty INT

FOREIGN KEY fkItemID ItemID REFERENCES Item(ItemID),

FOREIGN KEY fkPkgID PackageID REFERENCES Package(PackageID));

I'm assuming that the...

To create a variable...

1. Under the Report menu, choose "Report Properties".

2. Click on the Variables Tab (in the left pane).

3. Click the Add button.

4. Give the variable a name.

5. click...

I created the variable to store the aggregate value to divide by. If you're doing "% of total" then you would store the total value in the variable, and...

Hmm... wondering where my post went... Turns out I did the thing wrong. 😀

The way I got it to work was to create two datasets - one of the...

I know this is a super old post, but I just thought I would update this a little, in case there's some other person out there in my place.

While Rob...

I am trying to get a count of lead_ids where row_description value is "Leads Referred" and DIVIDE that by count of lead_ids where row_description value is "All Leads"

KK,

I did something...

This article might give you some ideas... Partitioning in SQL Server[/url]

It sounds like this is a good use for it, but I'm not a partitioning expert... and it depends on...