Open Q&A | Walkthrough of using Style Variables to hide columns on your report. High-level steps are: Prompt: Create a value prompt (multi-select, checkbox, static values). The choices should list out all the columns in your report. Variables: Create boolean (true/false) variables for each column that checks to see if the column name is in the checkbox prompt. Example calculation below in which “P_Report Fields” is the parameter, “Term” is one of the options in the prompt: ParamDisplayValue('P_Report Fields') contains 'Term' Report: Set the Style Variable on each column. Set the variable conditional state to “False”, then set the “Box type” to “None” for both the header and the field. To see the hidden field back on the report component (List) clear the conditional state.
Q: Does the user have the ability to save the report with their choices? A: Yes. They can create a report view in their “My Content” or a to share it, create the view in a “Team Content” Q: Data Module Error: Query Service internal error has occurred, please see the log for details.” A: Submit a ticket to BIA (busintel@ucsd.edu) |