on 10-30-2017 6:20 AM
Hi,
I have prompt filters in an application, As_of_Date and Region Prompt for two different DS.
DS_3 with Region Prompt shows data in Cross tab by passing Region after clicking OK+ Create Cross Tab
But DS_1 with As_of_Date Prompt doesn't show data in Cross Tab after clicking OK+ Create Cross Tab, however it shows data in Query Refresh and Edit Initial View preview after passing the date to prompt.
So I tried in different way, removed prompt (DS_2) on As_of_Date and fixed the filter value of date, it works, it shows the data in Cross Tab.
I have attached the screen print
Please suggest...
Regards
Sahil
Hi,
Thanks for the response, here are the screens,
I didn't make any change in property in all three scenario,
one with date as prompt (Data not showing in CT)
one with region as prompt (Data showing in CT)
one with date as fixed constant values(Data showing in CT).
1: "001 Property Screen Print of CT(DS_1) with Date as prompt " Where data is not coming CT after applying Date prompt but shows data in Edit Initial View.
001-property-screen-print-of-ctds-1-with-date-as-p.png
001-binding-screen-print-of-ctds-1-with-date-as-pr.png
2: "002 Property Screen Print of CT(DS_2) with Date as Constant filter" Where data is appearing in CT after applying Date as constant filter and also shows data in Edit Initial View.
002-property-screen-print-of-ctds-2-with-date-as-c.png
002-binding-screen-print-of-ctds-2-with-date-as-co.png
3: "003 Property Screen Print of CT(DS_3) with Region as prompt" Where data comes in CT after applying Region as prompt filter. ... ( same as 001, only different instead of Date, instead Date I took Region to check, works perfectly fine)
003-property-screen-print-of-ctds-3-with-region-as.png
003-binding-screen-print-of-ctds-3-with-region-as.png
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry forgot to attached screen print.
03-data-in-edit-view-after-date-prompt.png
04-no-data-in-cross-tab-after-click-ok-crosstab.png
Regards
Sahil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
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.