Viewing 9 posts - 31 through 39 (of 39 total)
ChrisM@Work (8/16/2012)
August 16, 2012 at 6:15 am
Thanks for your reply.
Sorry, Im still fairly new to SSRS.
Report results would be as bellow:
CELL00, CELL01, ...
August 16, 2012 at 3:56 am
Just in case you're a newbie like me...
You need to add a valid username and pwd or use Windows Authentication to the datasource credentials.
Double click your datasource.
Click Credentials, enter your...
August 16, 2012 at 12:38 am
Luke L (6/24/2010)
June 28, 2010 at 8:22 am
GregoryF (4/21/2010)
Also, ZZZZ + Char(10) + Char(13) + XXXX
will be:
ZZZZ
XXXX
just use...
April 21, 2010 at 1:03 pm
Dave Ballantyne (9/29/2009)
Even with completely empty KPI table , you should still be getting all the rows in the months...
September 29, 2009 at 6:17 am
Dave Ballantyne (9/29/2009)
drop table #MNTH_TBL1
go
drop table #RSM_KPI
go
create table #MNTH_TBL1(
MNTH integer
)
insert into #MNTH_TBL1 values(1)
insert into #MNTH_TBL1 values(2)
insert into #MNTH_TBL1 values(3)
insert into #MNTH_TBL1 values(4)
create table #RSM_KPI
(
UserName varchar(10),
Recorded_DateTime...
September 29, 2009 at 5:49 am
Dave Ballantyne (9/29/2009)
Sorry ignore that , LEFT JOIN and LEFT OUTER JOIN are synonymous....Can you provide a sample script ?
Hi Dave,
Could you clarify what sample script you need?
The script that...
September 29, 2009 at 5:00 am
Dave Ballantyne (9/29/2009)
You need to create a list of all the month / years you are interested in then left outer join that to your table.
Hi Dave,
Thanks for your reply.
I...
September 29, 2009 at 4:24 am
Viewing 9 posts - 31 through 39 (of 39 total)