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 wOOdy-Soft 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: *

  • Users: jotek
  • Content: Threads
  • Order by date
  1. jotek

    Parameter Description Field?

    Is there a way to access the parameter description field. I want to use it like a code table. But I want the user to see the value and I want to use the description field.
  2. jotek

    Null and/Blank Parameters when scheduling

    Why does a check for IsNull(Parameter_String) or Paramater_String = '' work fine(behaves like I would expect) when developing my Crystal Report. But when I place it on the Seagate Info Server and schedule it and either check Null or leave blank on the prompt window, it does not evaluate out...
  3. jotek

    Variable set in Page Header not working in Detail

    I have set a global variable in a formula, I have placed in the Page Header (I assume thats the place to put it, I tried the Report Header too). It is assigned as follows: Global NumberVar Max_Period; Max_Period := maximum(Period); // Period is a field from the returned data set. I want the...
  4. jotek

    Outer Join on a filtered value

    I am creating a report in CR 8.5 against an Oracle 8 database and have two tables which are join together using an outer join. I have an additional field that needs to be filtered in which the user provides the value. The field I am filtering on is on the outer joined table. We need all the...
  5. jotek

    Dynamically changing Parameters based on user selection.

    Is there a way to add a parameter or suppress a parameter depending on what the use selects from another user parameter? I want to allow the user to pick the report type but depending on which report option they select they need to fill in another parameter. (The answer can't be database driven...
  6. jotek

    Sort on different field from grouping field

    I am trying to sort on a different field than the field in which I am grouping. I would like to group on Items but sort in their order date. So the whole report is in order date sequence with groupings of items within each date. I have changed the grouping to "on original order" and...
  7. jotek

    Converting Date in Formula Edit to Year-Month

    I have a formula which converts a Date to Year-Month (2001-10) which I am using to Group records. The formula is: Year(Delivery_Date)&Month(Delivery_Date). The problem is that the answer comes back as 2,0000.000010.0000 The only thing I know of is the number "Options" on the report...
  8. jotek

    Show SQL Query not enable when using Dictionary

    Sometimes when Iam using my Crystal Dictionaries the Show SQL Query option is not enabled. What am I doing or what can be done to ensure this option is on. I need to review my sql, to ensure the Dictionary is correct. Sometimes the same dictionary causes this to work and not to work. But I...

Part and Inventory Search

Back
Top