Search results for query: *

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?

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

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

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?

I have strings such as: The sky, is blue, ID_123 The grass is green, ID_345 All trees have leaves, PW_456 Tek-Tips is Great, YY_331 I would like to eliminate the identification code and print out only: The sky, is blue The grass is green All trees have leaves Tek-Tips is Great...

I wanted to prevent a group from splitting over two pages. I tried using the "Keep Together" under the Section Expert, but that didn't work. I was able to get it to work using the "Keep Group Together" option under the Group Expert. Can anyone explain the difference between these two similar...

I'm trying to free up space on my C drive. Can I remove files with an .msi extension? For example, "Acrobat505.msi" Thanks.

I am trying to open my "full" Adobe Acroabt program. But it is opening Acrobat Reader instead. Double-clicking on a PDF file opens Reader. Start > Run > Acrobat opens reader. Does anyone have any hints for me?

I have a report w/ many columns, outputing to a spreadsheet. One column is too narrow. So, I want to several columns at once over the right a bit. I do know how to move multiple fields at once. But the guidelines don't go with the fields. If I grab a Guideline Handle, only one field moves. Since...

Hello, I am creating an email mail merge. The last step lets me specify the "to" address and the "subject" line. But not the "From". I would like to have the email mail merge sent "From" someone else. I am a designate for another person, and can send normal emails from that person. But how do I...

Hello, We have employee records with a checkmark as a field to indicate whether someone works from home or not. The records have been imported from another database, so the values for the checkmark are "1", "0" or "NULL". How do I create a report that produces only two groups? I would like to...

Hello, I'm not sure if it's called "self-documenting" or something else. But I was wondering if there is a way for Crystal Reports to print a document showing all the criteria, formatting, field selection, etc for a report. I'd like to build a new report from scratch using a previous report...

When I try to strip hyphens from phone numbers using the following forumla ... Replace ({EMPLOYEE.TELE_WORK}, "-","") ... the report just contains a blank space, no data. I am certain that the correct field is displayed, and it does have data. The original field contains data like...