ASP.Net/C# - Object reference not set to an instance of an object

Hello, i am creating a report by sending a star and end month so i can get data within that time frame

however if i put a start month of: Jan 2009 and an end month of: Feb 2009, the data is retrieved and the report is generated

however,

if i put in a start month of: jan 2009 and an end month of: May 2009

i get this error
Object reference not set to an instance of an object

as anyone encountered this problem with reports?

i put all the grouping and keep together true.

What does the code look like that grabs the data? Sounds like you have a try catch around it but are still returning the dataset which is null. Perhaps the query is large enough with that date range that it's timing out and you're not handling that error properly?

but for some reason it works on my local system but when i uploaded it on to to the web so the clients can use, then i am having the problem =S

Are you hitting the same database on the same server? Maybe your machine has a better path to the data? Force it to fail on your dev machine and see what the results are (change the password to the data source in your connection string so it will fail).

That's where I'd head first anyway...

yes it is a different database that is running to, on my local its call PCFMDEV and on the server its called PCFM, i did run the same scripts and everything. however, i restored my PCFMDEV db as PCFM so i can have the same data.

like it should work cuz i copied my PCFMDEV like my PCFM.