sql server reproiting service 2005

Question

I am new to sql reporting service 2005. I am getting an error message
saying the 'command text' property is not 'initialized'.
Being a .net programmer, I know the comand text is the sql in text format
or a stored procedure is not being accessed.
This error occurs after I have setup a report manually and I have changed
the stored procedure that is being called or after I have made a modification
to the report.
Note: when I setup the report format initially myself, the report runs and
displays all the data I want to see.

Thus, can you make suggestions on what I can change and/or look at?

Thanks!

Kirtan Patel · Answer

Post your Code so that we can see where is problem !!

Diane · Answer

How do I know if my commandtext property is set to null? Basically how do you change the command test property after the intitial report has been created? Thanks!

Lalit M · Answer

->i think your data source is case insensitive ->.CommandText = sql and this line sql = objsql.txt_sql.Text make sure that sql is not null before you get into .CommandText = sql as it would appear that it is. You need to set the variable sql with some commandtext like an SQL select statement or Stored procedure name. With any necessary mods