No prob.

I can learn other thing too at the same time

Thanks all.

I get the idea what should I do.

Thanks heaps

Thanks guy.

I need to disable temporary because we need to upgrade one of the DB and can't be disturbed by any backup.

I guess I will use ' disable job' because this job there are multiple schedule.

regular backup job...  back DB and log

thanks,

Susan

I have the similar problems the log grows...

so I create a job to shrink the log file and run once a week. 

Thanks for replying my email.

here what  I mean

Q1,Q2,Q3,Q4 need to be taken from the visit date of the client

So for example...

I am using ceiling ( value/60) and it looks ok..

I will try your suggestion, Jeff

thanks every one

Thanks,,,

It works well

I have that prob before

so I create 1 user with DB login to access then in datasource I choose to connect using

credentials stored securely in the report server and put...

Thanks Aaron.

however when I run it

exec PR_ActClientWithMulti '80,81',null,null,null

it doesn't give me any data only say the commands is completed succesfully.

Do you think my Proc is wrong?

Thanks for the tip.

I just add extra CONVERT(varchar,getdate(),103) as today in my proc.

I thought I can just easily grab the datetime functionality in VS2005 unfortunately I can't...

thanks

Have you tried to look at 'report parameter'?

Finally I found the solution.

I have to use CASE and SUM

then in RS I create a report without wizard.

thanks Guys 

I used  this method in reporting( cos the user only interested in total bal, doesn't care about the detail) 

select ge.[G_L Account No_],ga.[Name],SUM(ge.Amount)  As...