I'm turning into Joe Celko... time for a break.
Please help us to help you and read this article. 

June 6, 2017 at 12:41 pm

#1945679

Why not just the table stuff you posted?  Simple create table script, maybe a dozen inserts. Done.

Can't run a SQL statement against a picture.  If you want help, provide consumable data.

I meant that...
1. Don't use that diabolical stored procedure to do something this simple. You just don't need anything near that complex. (with lots of NO LOCK / READ...

Use an IF statement to determine if the value is 'Choice_Added', and overwrite the RowNumber value.  Then filter on the very outside to eliminate the values you don't want.

Do you have a database diagram for this part of the database?  It's hard to tell from the temporary tables how things are related, because there are so many foreign...

Creating datasets is trivial. You have a connection (DataSource), and then you build a DataSet by executing a stored procedure against that DataSource and it returns your dataset. Then you...

This appears to work for the data provided:
SELECT *
FROM test_table2 t2
WHERE t2.ID NOT IN (SELECT ID FROM test_table1)
AND t2.condition = 'Used';

As I see it, you have two options with the (CalendarID, StudentCounts) duplicates.  If you don't need grand totals, you can leave them in your underlying dataset, and then just...

I'm just going to snip off this piece... (this thing is mind-boggling!)

Bascially the counts are repeated a lot for the same calendared.
Could you show me how...

Are you adding the data to a tablix? I can't tell from your report design. If you're doing that, you can just add a totals line outside the group(s).

is there a way to check for page numbers that are even or odd?
MOD() ?
=IIF(Globals!PageNumber MOD 2 = 0, "Even", "Odd")