1. are you receiving any error messages and if so what are they? if you have On Error Resume, try turning it off to see if you do get an error.
2. does your sql user have the proper rights to get the needed data?
3. Have you verified in query analyzer that the data is there that you are expecting in the result of your report? Try recreating the queries or exec the Stored Procs in query analyzer as a test.
4. As a simple test, do a simple "select top 1 column1 from table1" in a test page and see if that would work.