Yeah, it will be good idea. Thanks for your suggestion.

Hi ALZDBA,

I have found all invalid data. It is there for some reason. so i just need to ignore those particular records.

Thanks for your help.

Hi Friends,

I found the solution. it was running for some time but failing at some point as table is having millions of record. I tried to see at point where...

Hi,

If we accept the fact about wrong desing then try to sort out.

If there is a problem with varchar datatype then it should not work for startdate. How come...

Hi,

Well, it is already designed system. I cant change it easily. Both dates in the table is varchar. Thats the problem.

Thanks for looking.

Hi,

It is with your date format. Make sure which dateformat your machine is using. In some cases you will not get error because 01/04/2008 might be USA format and it...

hi,

when you create datasource at that time you need to write query string. It must be coming from some table.

You can write query where country is not null or country...

hi,

Please make sure you have subscription (not data driven subscription).

Make sure You select 'REPORT SERVER EMAIL' in Delivered by.

WHen you select schedule, please make sure your stop this schedule...

Hi,

It will select AND automatically if you need to add filter on another field. If you are adding filter on same field then it will select OR.

e.g. filter on...

hi,

=sum(IIF(Fields!YearGroup.Value = "B", 1, 0))

I have something like this. If value of yeargroup into table is 'B' then it will sum of every record.

It depends if your second value...

Hi,

I believe you might be using stored procedure to retrieve the data. You can create parameter into the report and pass that parameter into stored procedure. Then in the stored...

Hi,

I already tried that but it will only give rdl file and i can find out data source. Data source will tell about stored procedure used and any query. But...

Hi Hari,

Bluddy hell.....why i didnt think about it...it was so easy....thanks very much....

thankssss

hi jason,

i am trying to achieve something which seems difficult to me. I am just wondering if some one can give some advice. We have chart in reporting services to...

Hi,

Is there any feed back/ Reply on this.? I am looking for same thing but didnt find anything yet.

thanks,

vijay