Set Table Location giving problem

[Vinod S]

Hi all,

i am using crystal report with ASP .NET. I am gettign data from stored proceedures to the report.

Now comming to the problem.

i am trying to set the table location using the code

reportTable.Location = reportTable.Location.Substring( reportTable.Location.LastIndexOf(".") + 1 ) ;

i am doing this for database name independency to the report.

My stored proceedures have two input parameters. one string value and another int value.

i am setting the parameter values before setting the location of the table.

i have give the log in informations also before setting the table location.

now comming to the real probelm.

when i set the location for the table. i have observed through SQL Profiler that the report internaly calling the strored proceedure with null paramerter vaules. this is giving me error in my stored proceedure as its not expecting null values for the parameters and the application fails. when i comment this line of code everything is smooth running. can any one tell me why its happening and how can i handle this situation.

I cant change my stored proceedure to handle null as they are of considerably big number and its being used by another application in VC also.

can any one give me a solution for this.