I have a crystal report where I need to mail the users the data in the excel as an attachment but with the condition that filters are enabled in each columns of the excel report . If I have 10 columns in excel , user doesn't want to apply filter explicitly rather they want the filter already present so that they can filter based on any column . If there is another better way of filtering the data on user side please suggest that too.
How to output the excel with filters enabled on columns in crystal reports
678 Views Asked by Gooks At
1
There are 1 best solutions below
Related Questions in CRYSTAL-REPORTS
- Crystal Reports and Null fields
- Crystal Reports extracting text within delimiters
- "Blank" pages in crystal reports with groups
- How to sum filed based on day type in crystal report
- Crystal Report Pie Chart Formula Labels
- how to pass value to crystal report parameter filed from the code
- C#&Crystal Reports, Failed to Load database error
- Crystal Reports - How to include more than one data value in my report
- Crystal report to rounding
- crystal reports fill with lines
- Year and month in a crystal report
- published reports don't work - Database logon failed Error
- Crystal Report not display in Crystal report viewer
- Crystal Report page split up and encrypting the generated document in C#
- Dynamic sort group in crystal reports
Related Questions in CRYSTAL-REPORTS-2008
- "Blank" pages in crystal reports with groups
- How to make drop down parameter in crystal reports
- unable to save generated rpt file into my local drive as a pdf
- Suppress Subreport in crystal reports
- Crystal Report : Missing parameter values in the PDF export
- How to output the excel with filters enabled on columns in crystal reports
- Crystal report Header row Color
- Crystal Report ODBC connection only shows "Add command"
- Crystal report running total sum fluctuates between two values
- SAP Crystal Reports v13 runtime not installing on local computer
- crystal report - Create report Not Equal to Column
- How to show all subreports one after one according to its detail sections record count
- Export PDF or Excel file from Crystal Reports using save dialog
- How to refresh business view in Crystal Reports?
- Is there any limitations to bind/rending large amount of data to crystal report viewer?
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?
There is no way to do this from within Crystal reports. You can write an application, which will export the report to Excel, open the Excel file and add a filter.
There is a free version of R-Tag, which supports this feature. You can see it demonstrated here: http://www.r-tag.com/Pages/Preview_RTagAndBOE.aspx Use the menu to jump to "Advanced report extensions" or go to position 5:26
If this works for you, here is the link to the free edition: http://www.r-tag.com/Pages/CommunityEdition.aspx