Heck! Explain the query first.

As far as I can tell...

Copy the data to a new table if you want to keep the original data

Then select top 2000 from source table into new table

Delete top 2000 rows from source table

Repeat...

WHAT :exclamationmark: Are you a bad VB6 programmer now

And after everything you said about CLR sheesh :rolleyes:

p.s. Only joking Jeff, my...

You can nest IIf ie

=IIf(Parameters!ExcelToolbar.Value = 0,IIf(RowNumber(Nothing) Mod 2 = 0, "Gainsboro", "White"), "White")

Are "apples" and "oranges" rows or columns?

What do you mean by "but that only apply to when it is Initially run"

If they are rows then setting the row visibility expression...

Jeff Moden (11/16/2013)

---

You have to use CASE instead of IF and you have to use CAST or CONVERT instead of CSTR (if it means "convert to string"). You also...

Well done Koen 🙂

Don't think I'll ever reach...

WITH cte (MainGroup,EmpLevel,NumberOfstaff) AS (SELECT CASE WHEN EmpLevel LIKE '%Mngmnt' THEN 1 ELSE 2 END,EmpLevel,NumberOfstaff FROM )

SELECT COALESCE(EmpLevel,CASE WHEN GROUPING(MainGroup) = 0 THEN 'Sub Total' ELSE 'Grand Total' END),SUM(NumberOfstaff)...

Add a textbox at the top of your report containing the error message as you would like to see it.

Right click on the box and select textbox properties, select visibility,...

Then I think you are stuck with your original query.

IIRC There have been some posts suggesting using OPENROWSET with dynamic sql to avoid the use...

For your end date I think it should be

=DateAdd(DateInterval.Day,6,DateAdd(DateInterval.Day,7-Weekday(Today,FirstDayOfWeek.Tuesday),Today))

This will give you the date of the next monday (note if today is monday then today is the date returned)

=DateAdd(DateInterval.Day,7-Weekday(Today,FirstDayOfWeek.Tuesday),Today)

Notwithstanding ndiro's reply, I would guess this

=IIF(Sum(Fields!PreviousMonth.Value) = 0,0,

(Sum(Fields!CurrentMonth) - Sum(Fields!PreviousMonth.Value))

/IIF(Sum(Fields!PreviousMonth.Value) = 0,1,Sum(Fields!PreviousMonth.Value)))

Why not put the values of the variables in the dynamic sql @sql before execution

My solution (bet Jeff picks holes in it :Whistling:)

Create a format file containing

9.0

6

1 SQLCHAR 0 ...