Hi, I need some help with my Data Enviroments.. I set up a DataEnviroment and linked it to a data report to print invoices.. I set up the command and a child command and inserted some SQL statements and put the proper text boxes on the datareport.. But the invoices will be changing every time I print a report, so in my VB application, I go:
dataEnvInvoice.Commands("Invoice").CommandText = "SHAPE (SELECT ...)"
And my report displays fine... Then, when a different report have to be printed, I set the command text again and it doesn't change.. The same information is display from the last invoice.. Can I only set the command set once ever session? Is there a way for me to reset the command text so everything I print an invoice with different criteria, it'll work perperly?
Thanks
John
