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

    This Month and Next Three Months in a date

    I believe this will work for you, if I am understanding your question correctly. Make a new formula field. I'll use the name DateChk for this example. Place the following formula in this field. IF year(hiredate) = year(currentdate()) AND month(hiredate) = month(currentdate()) THEN 1 ELSE IF...
  2. SchwabTerex

    How to make a field to show nothing rather than 0

    In the table you are pulling this info from: is the field allowed to be null or is it set to default to zero? If it is null in the table I would assume it would be blank in the report (mine normally is unless I script it to default for null values). You could always make a formula field. Is...
  3. SchwabTerex

    Show value

    Sorry, I didn't get that there was no record in the table at all for that instance. I was just thinking of a null field. Let mw think about it - that is a bigger problem.
  4. SchwabTerex

    Show value

    Don't try to add {current_transaction.amount} to 100. Crystal can't add a number to NULL. If 100 is the answer you want just do ...then 100 else {current_transaction.amount}
  5. SchwabTerex

    Group Sort Expert

    I'm not sure what your layout looks like. I assume you will be using a group on name. I would try placing a count in the group footer on dates of service. You could supress the field so it didn't show. That would give you a field to filter by in your selection criteria. Worked on the quick...
  6. SchwabTerex

    Help with nested if...

    I believe the code below will do what you are looking for. I tried to clean it up some without changing your overall layout much. In my experience all of the parenthesis are not necessary. They just make it more difficult because you have to match them. I prefer to just stick to a "tabbing...
  7. SchwabTerex

    Connection String - SQL Server 2005

    I'm not 100% sure what you are looking at. If you would like a different way to look at setting up an ODBC connection try this site: http://www.herongyang.com/jdbc/JDBC-ODBC-DSN-for-SQL-Server.html I personally have never tried to use one of the strings they are talking about on...
  8. SchwabTerex

    Crystal Report from CSV file is EXTREMELY SLOW

    You've probably solved this by now. However, I had to do some searching lately to fix a report I had created with a csv file. I've never created a report in Crystal from a csv file before and I found out the reason my report was so terribly slow (9 min) was that I had used the wrong kind of...
  9. SchwabTerex

    Tracking the Change in Count

    Would anyone have an idea on how to use a count from the previous time a report was run in a calculation when the report is refreshed? What I'd like to do is track the change in the # of orders (in each group) on the report from the previous day to today. I assume that it would involve storing...
  10. SchwabTerex

    minimum date in graph (Crystal Reports XI)

    That works. Thank you! That was getting very frustrating.
  11. SchwabTerex

    minimum date in graph (Crystal Reports XI)

    The original graph that I am trying to duplicate showed the production categories along the y-axis and dates (current date forward in week increments) on the x-axis. The actual date was then plotted on this chart. The purpose was to visually see where the minimum starting date would appear in...
  12. SchwabTerex

    minimum date in graph (Crystal Reports XI)

    I am trying to use Crystal Reports XI to recreate reports and graphs that were originally done in Access/Excel. I am pretty familiar with designing reports in this software but have never used the graphs before now. What I would like to do is graph the minimum start date per production...

Part and Inventory Search

Back
Top