Print Page | Close Window

Dynamic Filtering Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22782 Printed Date: 27 Apr 2024 at 2:51pm Topic: Dynamic Filtering Posted By: pdcjlw1 Subject: Dynamic Filtering Date Posted: 07 Jun 2019 at 5:03am I use Crystal reports with the command option so I have sql scripts in my crystal report instead of connecting crystal reports to the database. What I want to do is after returning the data to crystal reports and having it displayed. I would like to give the user the option to filter the data similar to the way you can filter data in excel. A drop down button on the header that shows you a unique list of items from that column and you can click which ones you want to see in the report. Is this possible in crystal reports? ------------- Jeff Replies: Posted By: DBlank Date Posted: 07 Jun 2019 at 5:16am that happens at the point the report is executed. You do it via parameter fields that are used in the select criteria. you can set up dynamic parameters that give select values from your data set. Posted By: pdcjlw1 Date Posted: 07 Jun 2019 at 10:49am I am able to filter that way. What I want to do is allow the users to run the report and have it displayed. Then based on the data being displayed in a column allow them to chose one or more and only the records that match that column will be displayed. Let's say the column is State and the state code is displayed. They would be able to select OH and MI and only those records would then display. Kind of like the filter you can use in excel. ------------- Jeff Posted By: DBlank Date Posted: 10 Jun 2019 at 3:55am I am not familiar with any way to do that. Perhaps you can mimic it somewhat with a drill down report functionality but that has to do with grouping more than user record selection.

Print Page | Close Window