Search results for query: *

Pete, Thank you for the tip! I thought there may be an easier way to exclude the null value from the crosstab other than the first approach you've recommended. For now, it's working perfectly with sub-report method. Will try to venture the second approach when I have some free time to play...

Hello everyone, I have a cross tab that I would like to exclude the null value of a particular field. However, I don't want to exclude the null value from a report. I had the group sort to only display the top 10 medications dispensed in the crosstab but the "null" value is displayed as the...

Betty, Thank you for the tip! I've got to try this out. I really appreciate all of your help!

What if I want to search for the combination uppercase and/or lower case like "INSULIN", "Insulin", or "insulin"? Is there a function to look for the string regardless of the case instead of typing out all of the possible combinations? Thank you again for all of your help! :) TC

BettyJ & kray4660, Thank you so much for the tips! I really appreciate your time. Best regards, TC

Hello, I have a list of about 75 different types insulin medications and would like to query the report to look for records with medication that begins with a combination of either “INSULIN”, "Insulin" or "insulin". How can this be done in Crystal Reports? Thank you so much in advance for any...

Hello D, Thank you so much for the helpful tip!!! This works perfectly! I really appreciate you for spending time to help me with the formula! Thanks a bunch! TC

Hello everyone, I've created a report with a date selection parameter to allow users to select from a list of date range option from the Date Range function in Crystal Reports. However, the defaulted function doesn't have an option for last 12 months. I've attempted to create a formula for...