SQL Server 2000 Report by Microsoft Visual Studio.NET 2003-CommandText property not initialized

• Scott H. Chang

  SSCommitted

  Points: 1794

  More actions

  November 19, 2005 at 1:19 pm

  #90020

  Hi all,

  I have a Query Analyst report to be processed by the Buiness Intelligence  Projects of MS Visual Studio .NET 2003.  When I executed "Define a Query", I got the following:

          Report1.rdl

       Processing report

       Processing Error: An error has occured during report processing. Query executuion failed for data set 'adpRotateTableSQL'. ExecuteReader: CommandText property has not been initialized.

  I used Microsoft Access 2003 ADP to set up an adp project that has an ADO Command Object and its data file 'Table' - adpRotateTableSQL is in the SQL  Server 2000 file.  I do not know how to initialize the CommandText property. Please help and advise.

  Thanks in advance,

  Scott  Chang