I am using a BO report which has a VBA data provider. This builds SQL dynamically based on the table and other selections that the user makes in the VB form. Due to this, BO always shows a message at the end of document refresh :
"Modified Data Provider. The data provider now contains additional columns of data. You cannot simply add these to the current document as doing so would damage the formats you have applied."
It then give the option to :
"Leave the current report as it is" or
"Display the new data in a new Report".
I always use the first option i.e. "Leave the current report as it is". But i want this to be my default all the time and that BO should not pop up such a message all the time. This is essential as i need to schedule my report to Broadcast Agent.
Please do let me know how this can be achieved?
Thanks much
Bin
"Modified Data Provider. The data provider now contains additional columns of data. You cannot simply add these to the current document as doing so would damage the formats you have applied."
It then give the option to :
"Leave the current report as it is" or
"Display the new data in a new Report".
I always use the first option i.e. "Leave the current report as it is". But i want this to be my default all the time and that BO should not pop up such a message all the time. This is essential as i need to schedule my report to Broadcast Agent.
Please do let me know how this can be achieved?
Thanks much
Bin