I'm trying to a print a Data Report from VB.
I'm passing a sql statement to the Data Envioronment at run time as below:
sql = "Select count(*) as tot_Count From table1 Where sold=1"
DataEnvironment1.Commands(2).CommandText = sql
My problem is how would i put tot_count to Data Report since it's not a table field to drag and drop as we nomally do?
Can some one out there please help?
I'm passing a sql statement to the Data Envioronment at run time as below:
sql = "Select count(*) as tot_Count From table1 Where sold=1"
DataEnvironment1.Commands(2).CommandText = sql
My problem is how would i put tot_count to Data Report since it's not a table field to drag and drop as we nomally do?
Can some one out there please help?
