sql server reproiting service 2005

Diane

16y3k

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!

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kirtan Patel16y ago
Accepted answer
Post your Code so that we can see where is problem !!
0
Diane16y ago
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!
0
Lalit M16y ago
->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
0