Mandar Kavishwar 6 Posted January 21, 2019 Share Posted January 21, 2019 Hi I have 2 questions regarding Cross table. 1 . I need to change columns in a cross table with property control. Ex. There are 6 columns : Col 1, Col2 , Col3 , Col4, Col 5, Col6 I am using list box property : It has 2 values like Val1, Val2. When i select Val1 , Out put should be :Col 1, Col2 , Col3 , Col4 When i select Val2 , Output should be :Col 1, Col2 ,Col 5, Col6 I tried many ways to get this done, but i am getting error. I think i am doing something wrong. Can anyone help me please Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted January 28, 2019 Share Posted January 28, 2019 1) You can use python script to set the cross table visualization axes to have specified columns on selecting any value in list box: https://www.sf-ref.com/ironpython/visualizations/cross-table/axes/ 2) If your columns count isfixed like 4 columns for each value selection in document property you can use conditional statement in cross table axes like: Link to comment Share on other sites More sharing options...
Mandar Kavishwar 6 Posted February 20, 2019 Author Share Posted February 20, 2019 Thank you Khusboo. I figured out another way. I used expression to pass the values to property control. It worked. Link to comment Share on other sites More sharing options...
Arjit Aggarwal Posted May 23, 2019 Share Posted May 23, 2019 Hi Kavi, Can you please help me to understand how did you do with a custom expression As soon as I put Property value $Date.Shipped in my column's expression , it automatically takes the current value of Date Shipped and doesn't change even if I change the dropdown in my text area. Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now