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