Reports not showing the data | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Reports not showing the data

Hi Everybody
our reports were working fine……suddenly few days ago….
here is the senario:
We are using sql server2000 reporting services for reports generation.
in our reports we have a column where if click on header its fowds to a link where we can enter data to tht particular row
and when we come back to reports mail page and refresh it the data is suppose to show up in reports.
but now sometimes it shows up instantly some times its not takes like 30 mins to appear on the report page.
and even more like yesterday we entered data in two rows and when we refreshed the page one row shows the data one does’t
please help
urgent
Thanks
Danny
Did you try wiggling the plug? j/k. Perhaps it’s a timeout issue due to server load, which would explain the inconnsistency.
quote:Originally posted by escherrer Did you try wiggling the plug? j/k. Perhaps it’s a timeout issue due to server load, which would explain the inconnsistency.
I am really new in this could not get wht you said.
can you please explain .
Thanks for reply
Danny
Hi danny, In reports are you calling a store procedure to fetch information from tables?
If yes then you can try to execute store procedure to see if those newly entered lines appear? Waqar.
________________________________________________
~* Opinions are like a$$holes, everyone got one. *~
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |