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...

CREATE TABLE Tally2 (n INT

CONSTRAINT Tally2PK PRIMARY KEY (n));

GO

DECLARE @num INT = 111

WHILE @num <=955

BEGIN

INSERT INTO Tally2(n) VALUES (@num);

SET @num = @num + 1;

END

GO

Could you please post the scripts for the two tables in the problem and enough inserts statements to recreate the problem you are having? If you ask a question and...

Does each customer have his own logo? is the logo stored in the database (in a VARCHAR(MAX) field)?

Not sure if it will work for you, but the easiest way would be to make a copy of the report and then in the copy, remove the filters. ...

TRANSFORM in Access does a pivot, but I'm not clear on what the pivot is even supposed to do in this case.

Could you post some original data (well the data...