Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JonAtHQ

    Record Select Formula: How specify two separate criteria

    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...
  2. JonAtHQ

    Record Select Formula: How specify two separate criteria

    @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...
  3. JonAtHQ

    Record Select Formula: How specify two separate criteria

    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...
  4. JonAtHQ

    Record Select Formula: How specify two separate criteria

    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...
  5. JonAtHQ

    How to include quotes in my output?

    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?
  6. JonAtHQ

    How to format phone numbers so they are clickable on iPhone?

    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...
  7. JonAtHQ

    What is best practice to format reports for Mobile?

    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...
  8. JonAtHQ

    Excel: How prevent chart from resizing when legend is deleted?

    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?
  9. JonAtHQ

    How to count records in one column, for each value in other column?

    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...
  10. JonAtHQ

    How to count records in one column, for each value in other column?

    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...
  11. JonAtHQ

    Outlook 2010: Meeting Suggestions Pane is not showing

    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...
  12. JonAtHQ

    My checkbox formula is not working. Can you see what's wrong?

    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
  13. JonAtHQ

    My checkbox formula is not working. Can you see what's wrong?

    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 '-...
  14. JonAtHQ

    My checkbox formula is not working. Can you see what's wrong?

    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...
  15. JonAtHQ

    My checkbox formula is not working. Can you see what's wrong?

    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...
  16. JonAtHQ

    How to "delink" Field Heading from Field

    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...
  17. JonAtHQ

    Format output for iPhone?

    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...
  18. JonAtHQ

    Formula? Field starts with ABC, but does not end with LMN

    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.
  19. JonAtHQ

    Formula? Field starts with ABC, but does not end with LMN

    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?

Part and Inventory Search

Back
Top