Why not put a footer in your 3rd subreport and toggle the visibility as described above? Alternatively, set the body size of the 3rd subreport to a specific size...

Yeah, that's the easy way

1. Define a datasource (points to your database)

2. Define a dataset (query that gets the data from the datasource)

3. Choose a Table from the toolbox and bind it to the...

Yes, you can run your script in SSIS. Use an Execute SQL Task

Here's a crazy query that does the whole thing, I think:

;with cte as (

select CourseGroup, Title_Offering, sum(No_people_Attended) No_people_Attended

, RANK() over(partition by CourseGroup order by sum(No_people_Attended)...

This produced the desired output for me:

select CourseGroup, Title_Offering, No_people_Attended,

RANK() over(order by no_people_attended desc) as Ranking

from Learning l1

where No_people_Attended = (

select max(No_people_Attended) maxpeople

from Learning l2

where l1.CourseGroup...

If you mean, "Can I install SQL Server Data Tools 2012" when you already have 2008 R2, the answer is "Yes". That's my setup.

Jeff Moden (4/19/2014)

---

gbritton1 (4/16/2014)

---

Well, the fix is not complete. I ran into this again in SQL Server 2008R2 just last year. I applied my workaround and voila! ...

I think I'd be inclined to start with one DW for all countries, build views to pull out data country-by-country or for all countries, then split up tables if/when growth...

Kinda hard to answer without knowing lots more.

e.g.

1. will most BI reporting be country-specific? (argues for separation)

2. what are the expected table sizes? (if small-ish, no value in separating...

Add the text box you want, but make its visibility dependent on the page number being the last page number.

Here's a solution that doesn't depend on SQL Server 2012:

declare @test-2 table

(Tsq INT IDENTITY (1,1),

Data Varchar (150),

ts datetime,

Tpkt_type int)

insert into @test-2 values ('GS,000020,000021,000022,000023','2013-11-13 09:47:35.963','2') --1

insert...

or:

with someData as

(

select '1.51922e+015' as SomeValue union all

select '1.53122e+015' union all

select 'FMCIT' union all

select 'ABCNP' union all

select 'FMCPNG' union all

select '1.62073e+015' union all

select '1.6127e+015'

)

select *

from someData

where 0 = isnumeric(SomeValue)

yields:

FMCIT

ABCNP

FMCPNG

Can't you use the ISNUMERIC function?

Sorry, you're quite right! That should be:

declare @maxminutes bigint = datediff(day, '0001-01-01', '9999-12-31')*cast(24*60 as bigint)

select @maxminutes

which yields: 5258963520