Hi Thank you very much, it worked well 🙂

Hi Lutz, i am not getting the place to post on your first link, in trigger i have used

/****** Object: Trigger [dbo].[New_Author] Script Date: 04/28/2010 16:01:16...

I had created the new table and executed the query but i am not gettting the records able to see only column names.

the query which i had executed is...

in SQL-2008, all the databases are in same server

Thanks a lot kshitij kumar it worked out well, can you please help on joining the tables with two or three databases

Hi Willem, i tried on this query

select x.TRUSTID,Y.Date1, isnull(x.total,0) from

(select TRUSTID, Date=convert(varchar(25),UPLOADTIME,103),

Total=SUM(uploadlncnt) from DCLIVEJOBS where UPLOADTIME between '2010-01-01' and '2010-01-31'

group by TRUSTID,UPLOADTIME

)X

right outer join

(select '' as TA_A_NAme,convert(varchar(25),DATE,103)...

Hi Willem, thanks its working fine now, i have used

=DateSerial(Fields!Year.Value-10, Fields!Month.Value+3,Fields!Date.Value-1) in Expression on that column and in same column text box properties > Number > in category i...

Hi Willem, attached the screenshot

The error i am getting is in reports as #Error in the day number which was displaying earlier, and in reports on expression i have used...

Hi Willem,

the query i have used in sql is

SELECT DATEPART(YY, CHECKINTIME) AS Year, DATEPART(MM, CHECKINTIME) AS

Month, DATEPART(D, CHECKINTIME) AS 'Date', SUM(UPLOADLNCNT)

AS 'Total Lines',...