It's getting closer. Here is my formula:
{Employee.U_Facility} in ["Corporate Facilities", "Company HQ"]
or
{Plan.U_AlertFind} = 1 AND not isnull ({Employee.U_Facility})
However, when the report runs, it's omitting records with no value in the {Employee.U_Facility} field. What's strange to me...
@Charliy,
Thanks. Let me give that a try. It might take a few days (or over a week), as I'm slammed over the next few days, and on vacation at the end of this week. But I'll get back and let you know how it went.
But in the meantime, what's the syntax? Do I add an "OR" or "AND" between both...
I'm desiring your Number 2: All Flag = 1 (from one table) AND all states in the list (from another table)
It's been quite a while since I linked this database (and I'm no expert in this), but the Database Expert window is telling me that the tables are Auto-Linked By Key. The Links window shows...
Hello,
I don't know how to combine two separate queries into one formula so that my report will print records based on two separate criteria from two separate tables in my database. (Using CR 11)
1) Print employee records if table.flag = 1
Formula example: {table.flag} = 1
2) Print...
I'd like to add quotes to my output. The data is simply: Hello. I'd like the output to be "Hello".
In other words the field surrpounded by double quotes.
Any ideas?
Hi,
I've read this thread, http://tek-tips.com/viewthread.cfm?qid=489918 which has been helpful up to a point for me. I'd like my users to be able to click on phone numbers that appear in a PDF (created from CR), and have that number be dialed on an iPhone.
My database has phone numbers...
Is anyone formatting reports for viewing on tablets? I'm wonder what the best approach is in order to prevent the user from having to pinch & zoom, and scroll around the page to view the data. Do I just reformat the report so that the text is larger, and in one column down the page?
Thansk for...
In Excel, I would like to delete the legend that is next to a Pie chart, but not have the Pie chart resize automatically. I have not been able to figure that out. Any suggstions?
Thanks Petrosky, Ernest and Skip. You forced me to learn Pivot Tables! But it took me about 90 seconds, not 30. Guess I'll take it!
By the way ... at one point, the Field Table wouldn't appear. And, yes, the Field List butto was depressed. Googling the issue told me that I needed to start up...
Here's my challeng that I'm hoping you can help with. I have a report (see attached) showing the dates our students completed a class (in column A), and the region where they are from (in Column B)
Column A = Date
Column B = Region
I want a summary to show how many from each region took the...
Hello,
Some of my colleagues see a "Meeting Suggestions" pane in Outlook 2010. They love how it suggests meeting times for people as they are added to an invite. However, I don't see the Meeting Suggestions pane. At first, I thought it was becuase I couldn't see the "People Pane", but I went...
Yet another follow-up from OP:
The problem is resolved!
I changed the drop-down at the top of the Formula Editor from "Exceptions for Nulls" to "Default Values for Nulls".
Next up for me is to see how I can optimize the formula to take advantage of this.
Thanks all.
Jon
Follow-up from OP:
I tested for 1, then 0, then null, and it is still not printing anyting for the null value. Here is the formula:
if isnull ({location.siteName}) Then ''
Else if ({PlanSegment_Location.alternate}) = 1 Then '- Alternate Site'
Else if {PlanSegment_Location.alternate} = 0 Then '-...
I took you upon on your suggestion to print the field values. Here is what's happening:
When the field is "brand new", that is where no entry was made, (which I would assume to mean 'null'), then nothing is printing on the report. Just a blank space.
When the field has a checkmark added, a 1...
Hi All,
There's a checkbox in my db. If it's checked, I want to print "-Alternate Site". If it's not checked, I want it to print "-Production Site".
Am I correct in that there can be three values for a checkbox? Null, 0 and 1? I think it is Null until someone checks the box, then it is 1. If...
On my computer, when I add a field to a report, I can simply delete the cooresponding Field Heading that is inserted above it (if I don't want it to displayed). However, on a colleague's computer, whenever he adds a field, the Field Header is added, and it's locked to the field. That is, if he...
Hello,
I have a Crystal Report that my users carry with them as PDF files in their iPhones. If they need to access the data, they open the PDF and read the file. The problem is that the text is so small, they are constatnly zooming in and out, and scrolling all over the page to read the report...
Thanks for the formula. We'll give it a try. For some reason I was trying to build the formula with "STARTS WITH", and something else. Too bad there isn't an "ENDS WITH". That would make my life a lot easier.
Hello,
I'm lost. I'm looking for a formula that will print records if the value in field begins with "ABC" but will exclude records if the value in the same field ends with "LMN".
Any ideas?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.