Open Q&A | Walkthrough of using Style Variables to hide columns on your report. High-level steps are: Prompt: Create a Checkbox, value prompt (multi-select value prompt with static choices, checkbox, static values). The choices should list out all the columns in your report. Image Added 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 state to “False”, then set the “Box type” to “None” for both the header and the field. Image Added
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) |