Crystal Reports XI - Formula fields/Sorting/Grouping
Posted on 2014-12-09
I'm working on a custom report and have gotten hung up trying to filter my data down the way my user would like to see the information presented. My report uses a hundreds of unique option codes. The letters and numbers in the option code are used to identify the location the option is used and what type of option it is. For example option 20918BNC1 is carpeting level 1 in Bed room 2. We use 'BN' to identify the room and 'C1' to identify the flooring type. Fortunately there are only about 15 rooms and 8 flooring levels so I was hoping I could just build in Formula Fields to accomplish my objective. That being said my goal is to allow my user to run the report from my enterprise server and be able to specify the room or rooms they wish to see and also the type of flooring from a selection window.