I have a report with two groups that are expandable and collapsible. On opening the report the group header shows with totals but on clicking the toggle button the report expands out and the outgroup totals are set to visible = false. This all works fine until I export to excel. The data in the text boxes show no matter what I try. I have tried using =IIF(Globals!RenderFormat.Name= "EXCELOPENXML" OR Globals!RenderFormat.Name= "EXCEL", true, false) in the expression but the data still shows. I've tried setting the DataElementOutput to NoOutput but it still shows. The only thing that seems to work is if the initial state of the text box is set to visible = false but I need this to be set to true. Anyone know of any way of doing this?
Hidden text boxes show on exporting SSRS report to Excel
28 Views Asked by Mco At
0
There are 0 best solutions below
Related Questions in REPORTING-SERVICES
- SSRS cannot aggregate a variable
- How to filter data in a report using Microsoft Report Builder based on Orders of Service (OS) dates?
- Check if a value is not in a list in SSRS
- SSRS Report Builder returns error when entering more than one value in a parameter filter
- SSRS - Do not want to round a percent
- SSRS report exporting as PPT file
- SSRS use a dynamic SQL query with parameter
- Error when trying to change subscription owner (SSRS, SQL Server 2016)
- Background Colour Conditional Formatting in PBI Report Builder
- do you know any free reporting services like devexpress or boldreports?
- Embedded SSRS permissions error using rsweb:ReportViewer
- SSRS - Visual Studio round issue
- How to Implement Multi-Parameter Queries in SSRS Report Builder with Databricks ODBC?
- I want to integrate Crystal reports or SSRS reports in react js
- Column Grouping in SSRS report Matrix
Related Questions in EXPORT-TO-EXCEL
- PEAR SPREADSHEET EXCEL issue on writing local file
- Style extra content in ag-grid exportDataAsExcel
- Laravel10 Filament/ Excel export: Your requirements could not be resolved to an installable set of packages
- ag-grid export removes leading zeros
- Kendo-Vue Excel Export Currency Formatting
- Exporting Metatrader 4 historical data to excel
- Excel file converted to html table then set as editable, but changes aren't reflected when converted back as excel file
- Excel adds "@" to SWITCH and creates #NAME error, when first opened. Why?
- I want to export my html table to an xlsx file but the formatting is screwed
- Excel VBA Macro Finding data in a column, stuck in 'Do' loop if data not found
- Excel file is not opening while export data in excel, but working fine in localhost
- Python export to Excel file issues
- Set specific Width to Generated excel via code
- How to export values from R to Excel, from a table I generated comparing 2 data frames using arsenal package?
- Hidden text boxes show on exporting SSRS report to Excel
Related Questions in SHOW-HIDE
- Show/hide text using getElementsByClassName for all classes
- Button hide based on author in elementor
- Excel VBA hide/Unhide Rows
- Hide all elements when the one element is visible
- How can I hide and show the menu well so that it doesn't look messed up?
- Hide and show span element by clicking div element?
- Hidden text boxes show on exporting SSRS report to Excel
- How to show and hide password when click on eye icon using jQuery and also both the password (new and confirm) should be matched
- Show Hide a div based on selected option value of a select using JS
- How to Remove Class from Current and Add to Next Element with JS Only?
- When I tap and immediately type, the UITextField freezes, but if I tap it then wait, type works
- How to show and hide multiple divs as I click the respective button with only JavaScript?
- Show/hide rows and sheets based on other cell values
- How to hide pages in a streamlit multiple page app?
- How to specify only the id of the appearing text, without specifying the ids of the hiding texts?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?