hi,

If you need to avoid duplicate then it really depends on how many columns do you have in the query. If you have duplicate record with same city then you...

Do you need to copy each time from one table to another? If once then you might create table by writing SELECT INTO from one table to another and then...

You might use isnull(value, 0). It will put 0 if value is null. You can put 1 or anything so that it will not be null any time. obviously u...

hi,

i think it might be that ur name field u said is not null...try to declare it as null....i dont have sql server installed at home...so cant test...sorry....just try....

Hi Alok,

when you write your query for dataset or SP for dataset then just combine two column of two different tables. You can do it by join or if it...

please check this as well.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98507

regards,

Vijay

hi,

i dont know why some one is so harsh to requestor of interview questions. This group is made to share knowledge and skills. If some one is asking for interview...

hi,

i m bit confused but r u looking for something where u can see how to pass parameter in RS?

if yes then following link will be helpful.

http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-1/

regards,

vijay

Hi,

sorry i didnt test this. But if you see the last 2-3 conversation in this topic then u would be able to get something. Please check last query.

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3964391&SiteID=17

regards,

vijay

hi,

i m not sure it will hep for what you are looking for. But it will be helpful for any kind of images work and graphs.

http://www.ssw.com.au/Ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx

I have used it a...

hi...the report is already been used by many people for different time period so i cant make it defaulut value....bt for subscription purpose, i made copy of the same report...

Please read this. It might be helpful.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3069045&SiteID=1

I believe you can try this using Report File Share Server. Did you try this? It is under Report Delivery Option and Delivered By.

R u looking at subscription or data driven subscription? do you have enough rights to set it up? it might be problem with the rights.

Again i am thinking about year 2008. We will get more and more data as time goes and in this way it will work only for certain months and year....