From: aaron on
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!
From: William Vaughn (MVP) on
How are you modifying the report? Using the Visual Studio BI tools, Report
Builder or the ReportViewer tools?

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com http://betav.com/blog/billva
____________________________________________________________________________________________



"aaron" <aaron(a)discussions.microsoft.com> wrote in message
news:7B8FBE70-1804-4DDF-AB23-27A58E4E2F77(a)microsoft.com...
> 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!

From: aaron on
I am using the Visual Studio 2005 BI tools.

Thanks!

"aaron" wrote:

> 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!