Search results for query: *

If it's not a .csv, you can format the entire column as text and that should do the same thing. As far as I know, the "Text" format in Excel should convert any numbers to the ASCII equivalent.

Are the US zip codes and the Canadian zip codes in different columns on your spreadsheet? If so, how do you have both columns formatted...have you checked to see if the entire column for both is set to text/string?

What version of Crystal Reports are you using? I'm using 2008, so my response is going to be based on my version. You made to alter the steps slightly to get it to work with your version (specifically the part about the chart toward the end). Do you have a group for the ticket numbers under the...

Technically, the form isn't specifically identified in the table. There are fields that appear on each form that are specific to only that form, and that's how I can tell which form was completed. The table looks something like this (Keep in mind that Form A and Form B also show on the same...

Nope...you're making it just the right amount of difficult! =)

You should be able to create a formula for each month to accumulate the total money. You can use a conditional to determine if it falls in a particular month or not, then add it accordingly. You can also create a formula for each month to use as the column header (01/01/2012-01/31/2012) and...

That's a pain, but it's usually the most reliable...at least, that's what I've found. I recently had to do this same thing, but had to create 200 formulas for a weekly class schedule with variable output. It's a great looking report, but it took forever to setup initially and I hope I never...

Hi Brianna, You can do one of two things: 1) If the months are static and you only need 12, then you can create a formula for each month and use this as a column header. You can use the DateAdd function and a date parameter to change the values of the formula. This is a type of manual cross...

1. Create a new formula. 2. Name it something like ReportTitle, PrimaryTitle, etc. 3. Use the following code: {?ReportName} Note - {?ReportName} needs to be the name of the ReportName parameter (I'm assuming that's the name you gave it since that's how you referenced it in your...

Hi everybody, [Crystal Reports 2008] I have a report that connects rows in a table based on a common field, an order number. However, there's a field, called Draft/Final, that indicates whether a specific form has been completed or not. The problem is that the table is the data source for four...

Thanks for your help LB, but I'm going to cut my losses and just create a manual crosstab. I hate that I can't get this figured out, but I have to finish this report today, so I can't spend any more time troubleshooting it or asking for help. Thanks again, beacon

The join is currently a left join FROM tblProblem TO tblCallLog...that's the issue, it appears to be setup properly, but it's not still not displaying all of the Problems. Hardware is a record in the Problem field of the tblProblem and technician is a field in the tblCallLog. There are enough...

Hi everybody, [Crystal Reports 8.5] I created a summary report which has a Microsoft Access 2003 database as the datasource, and have inserted a crosstab in the Report Footer. In the database, there's a table called tblCallLog and another table called tblProblem, which I've added to the...

If you browse the data in the {Split.datetime} field, what's an example of how the data is stored? Does it list time values separated by a comma or a semicolon? Also, I know that the field is working with date/times, but is that the data type for the field? Or is it some other data type, like...

I think you need the special field "PrintTimeZone". You may want to read up on this field in the help file, but I'm pretty sure that it uses the system clock on the user's machine to determine the time zone when the report is run. This may differ if you're using a Business Objects server or...

Since the error message said the "hour must be between 0 and 23," have you tried using a timevalue range of (00,00,00) to (23,00,00) instead of the (00,00,01) to (23,59,59) timevalue you listed at the end of your post? It seems like, if you were using (23,59,59), which is basically 24, that...

Hi everybody, [Crystal Reports 2008] I'm attempting to write a report that will show patients that have readmitted within 30 days of their previous discharge date. I found a similar post that addresses the same question and is almost identical to my situation except for the fact that I have...

Hi everybody, [Crystal Report 2008] [Crystal SQL Designer] Many months ago I posted a similar question, but I had to abandon it for a while due to other work priorities. Now that the dust has settled I'm tackling this once again. Here's the link from the original thread...

Hi everybody, I found the following thread and the third post in the thread is what prompted my question: http://www.tek-tips.com/viewthread.cfm?qid=1596381. I typically don't put anything in the report header...my personal preference is to use the page header and have it repeat for every...

Hi LB, I'm using the running totals for another purpose and was going to use it for this purpose too. When I couldn't get it to work with the running total field, I used the three formulas. I got it to work based on your suggestion. I forgot that you can perform a count for a field within a...