Report\Preview Not all the data is displaying

hi reporting guru's

report collecting data sql2000 server.
there data being replicated sql2000 server.

replication broke because there huge network connection problems.
data replicated country.

in time when had network issues server migrated new sql2005 server.
, network issues sorted out , data available on tables (it took couple of days data across , rerun snapshot), if run table (count) compare server in other country data same.

below example of 2 expressions in report:

old expression
=sum(fields!countsuccess.value/fields!hits.value*100)
new expression
=iif(fields!hits.value =0 ,0, sum(fields!countsuccess.value/fields!hits.value*100))

old expression
=fields!countsuccess.value/fields!countmarketing.value*100
new expression
=iif(fields!hits.value =0 ,0,(fields!countsuccess.value/fields!countmarketing.value*100))

have expressions? of data have 0(null) values. if change date run report of data display there data doesn't display @ all.

when in dataset properties there stored procedure getting executed. if execute stored procedure in query designer execute data need.

if execute stored procedure manually on database working, declare necessary.

run report in report preview there missing data.
dba not developer have no idea next data in report.

reporting server sql2008.
report collect data 3 tables provide amount of hits site got , amount of downloads completed/uncompleted.
have been struggling 6 working days between other daily work.
appreciated on how data display in report!

thank in advance!

hi niël pieterse,

according description, not data displayed when preview report, , data returned corrected in report query designer, right? please correct me if understanding wrong.

have tried click on fresh button refresh data when preview report?  after deploying report, correct result displayed on report?

in case, when editing report in bids, have subtly different kind of access data when compared access report served report server. data tab executes query data source when request refresh, preview tab different again, in when run it, data can cached in bids project (you can find file in same folder report, same name .data file extension), preview tab loads more quickly. can lead seeing 'old' data while developing report.

best way forward deploy report report server can serving up-to-date data. in addition, method supply reference, please try following applies:
1. go directory of solution (where .rdl files stored)
2. delete files ".rdl.data" extension
3. refresh preview.
note: sometimes, necessary rebuild reporting service project after deleting .rdl.data files.

if have question, please feel free ask.

thanks,
eileen

SQL Server  >  SQL Server Reporting Services, Power View