nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

expand collapse feature in crosstab

appform · 2013-07-17T08:00:13+00:00

Hi All, Please help me to design the crosstab having expand collapse feature. Please provide me a sample design file. Regards, Swapna.

appform

Hi All, Please help me to design the crosstab having expand collapse feature.Please provide me a sample design file. Regards,Swapna.

Find more posts tagged with

Comments

kclark

What data do you want to expand/collapse? With some scripting you can make rows/columns invisible using drill-through links but the group labels will still need to be there so they can be made visible again. Are you wanting to show more detail about that row if it's clicked?

appform

Hi kclark, As i implemented expand/collapse feature in attached table,i want same thing in crosstab. PleaseHelp me to achive this.Regards,Swapna.

kclark

Sorry for the late reply. I've attached an example of one way you could do this. I created a computed column for the grouping that you want to show/hide. With the following logic.<pre class="_prettyXprint">var col = new String();col = params["collapse"].valueif(col.indexOf(row["COUNTRY"]) != -1){ row["CUSTOMERNAME"];}else{ "";}</pre>This will check if the country you clicked on is in the parameter collapse. If it is then it will return the customer names. If it is not then it will return nothing. Then I used a hyperlink for the top level of my group in the crosstab "country" with this logic.<pre class="_prettyXprint">var col = new String();col = params["collapse"].valueif(col.indexOf(data["COUNTRY"]) != -1) { // Has this string removeMe = data["COUNTRY"] + ","; newVal = col.replace(removeMe, ""); newVal;}else{ newVal = col + data["COUNTRY"] + ","; newVal;}</pre>This will check to see if that country is already in the parameter, if it is then I remove it since they are wanting to get rid of it. If it isn't then I add it so it will expand. Let me know if this helps.

appform

Thanks a lot, This is great ,but i want attached report functionality for expand/collapse for crosstab.Please run attached report.Please provide me a quick solution.