Hi all
I have a disco Report with two sheets. In sheet 1, i used a function from database that inserts data (based on some calculation) into a table. In sheet 2, the column inserted by function in sheet1 is to be displayed. Is it possible to dynamically display this, If the calculation changes in sheet and inserts thee data, will i be able to see that in sheet two immediately after i do refresh.
I tried this, but not working. I have to disconnect and connect again to see the change.Why is this so?Is this the only solution for this.
--> sometimes i see xxx as data in some columns, i tried to drag the filed space assuming that it is not sufficient to display, but the problem still exists. I also copied the sql code from view-->sql inspector and tried in toad, it works fine.What could be the reason for this.
Vamsi
I have a disco Report with two sheets. In sheet 1, i used a function from database that inserts data (based on some calculation) into a table. In sheet 2, the column inserted by function in sheet1 is to be displayed. Is it possible to dynamically display this, If the calculation changes in sheet and inserts thee data, will i be able to see that in sheet two immediately after i do refresh.
I tried this, but not working. I have to disconnect and connect again to see the change.Why is this so?Is this the only solution for this.
--> sometimes i see xxx as data in some columns, i tried to drag the filed space assuming that it is not sufficient to display, but the problem still exists. I also copied the sql code from view-->sql inspector and tried in toad, it works fine.What could be the reason for this.
Vamsi