Creating a report in Visual Studio. It has 2 queries. First query is an insert statement using report parameters. The second is a select of the table I just inserted records into. The second returns 0 results. If I rerun the report (Which then inserts another set of records) the second query does show the first set of records. Is there a way to refresh before the select? If I run the insert thru SSMS I do get a message saying (x_number rows affected). Can Something like that be displayed in Visual Studio?
Q:Is there a way to refresh before the select?
Q:Is there a way to display number of rows inserted in Visual Studio?