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!

Register Log in
  • Congratulations Chriss Miller 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. beacon5

    Forcing Data Field Type

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

    Forcing Data Field Type

    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?
  3. beacon5

    Charting Distinct Count Averages

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

    How to write a subreport into an existing SQL Command?

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

    List of months depending on lease term

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

    Formulas for different ranges

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

    List of months depending on lease term

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

    List of months depending on lease term

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

    How do I take my ReportName Parameter and makea formula for Rpt Title

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

    How to write a subreport into an existing SQL Command?

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

    How to display all records in a crosstab?

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

    How to display all records in a crosstab?

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

    How to display all records in a crosstab?

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

    Time Selection

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

    Show time zone

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

    Time Selection

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

    How to view patients readmitted within 30 days?

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

    How to combine the field values for multiple records?

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

    Business Objects - How to Prevent Scheduled Reports from Emailing?

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

    How to suppress a group without a specific number of records in detail

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

Part and Inventory Search

Back
Top