on 07-15-2016 1:22 PM
Hi all,
when I'm retrieve a crosstab datawindow with rows then everything works great. (attach 1)
When I'm retrieve a crosstab datawindow without rows then everything works great.. So far OK.
But why the crosstab group remains. I have already set the reset. No success. The Crosstab group remains. (attach 2)
How can I reset it without crosstab group remains?
See attach 1+2
Thanks for help.
Regards
André Rust
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi David,
It's true, you've understood differently.
I'm doing a retrieve, get back a set. Attach 1.
Now I change some in the where clause, make a Retrieve, can not get a sentence and the Crosstab group remains as the Retrieve previously. Attach 2
The Retrieve happened during the term not in DW!
Even with a DW.reset () will not be reset it.
André Rust
I think I understand your problem now and I still think that the Rebuild columns tick box should have fixed it. I guess that you are modifying the DW where clause and then doing the next retrieve and perhaps PB is not seeing this as a change so is fixing the columns on the first retrieve.
If you can humour me and assuming that you have Rebuild columns ticked, After the first retrieve can you change the dw.dataobject to something else and then change it back again. Then modify the SQL where and see if that is enough to force the refresh. Just a thought....
Hi
It was my suggestion that you do this at runtime...
"After the first retrieve can you change the dw.dataobject to something else and then change it back again. Then modify the SQL where and see if that is enough to force the refresh."
Use something like this....
dw_1.dataobject='d_dummydw'
dw_1.reset()
dw_1.dataobject='d_myactualdw'
..... modify the where clause
dw_1.retrieve(....)
Hi Andre;
I hope that works for you. Its just a suggestion that might work a little more effectively.
BTW: Here is a little known tip for CrossTab DWO's. When they encounter a Retrieve ( ), they fire a user event "pbm_dwnmessagetext" that informs the DW Control that a CrossTab operation is underway. You can add this as a "mapped" User Event and then utilize that to inform your application users that a CrossTab operation is proceeding ... "please wait" for example.
HTH
Regards ... Chris
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.