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

    if/then with two formulas

    Wow! Thanks so much for your help. I just tried it and see that it is working correctly now. Thanks again!!
  2. jessieyull

    if/then with two formulas

    Hi Mike, I just emailed you a copy of my report with data. Thanks for taking a look. -j
  3. jessieyull

    if/then with two formulas

    thanks for your quick reply! I tried your version and I got the same results. Individually, the statements work if instr({@HealthCoverage},'Employee and Family') > 0 then "$500" WORKS!!! but when I combine the two with an AND I get no results. And there are rows that match the...
  4. jessieyull

    if/then with two formulas

    I can't seem to make the formula that I want work!! I'm no programmer so I had one come review my formula and he couldn't figure out why Crystal didn't like it either. I have a couple of formulas that are returning the proper data in their columns. In another column, I am trying to compare...
  5. jessieyull

    oracle "non-numeric" error

    Here is one of the views that is not working... CREATE OR REPLACE VIEW LEGX_SALARY_ALL_V ( EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, LAST_NAME, FIRST_NAME, MIDDLE_NAMES, CHANGE_DATE, CHANGE_VALUE, CHANGE_PERCENTAGE, REASON, SALARY, APPROVED, RATING, RANKING, GROUP_SIZE, PAY_BASIS...
  6. jessieyull

    oracle "non-numeric" error

    ok, this error isn't really formula related but I seem to get the best response in this forum so I thought I'd give it a try. I have some sql views written that work perfectly well in other tools (toad, discoverer, oracle reports) but when i try to use them in crystal i get the following...
  7. jessieyull

    kind of like a cross tab - or formula

    yep, its a VarChar (description field) so that must be the problem. Thanks for the Maximun operaton tip too. -jessie
  8. jessieyull

    kind of like a cross tab - or formula

    I was hoping that it would be just as easy as you described - using a crosstab. But my two issues I ran into there are... 1) I can't figure out how to suppress subtotalling on all the fields I am displaying. This report would not need any totals fields. 2) For some unknown reason, when I...
  9. jessieyull

    kind of like a cross tab - or formula

    I have some data that I am reporting on for parts that includes description type columns and pricing columns. If I bring back all the fields in the usual mannner af placing each of them in the detail section, I get multiple rows for each part as it returns each of the column prices. I am...
  10. jessieyull

    Oracle Reports vs Crystal Reports

    we are trying to choose a one tool to standardize on for our reporting needs. Currently, we have reports being created/maintained/distributed in both Crystal and Oracle reports. Can anyone give me their opinion on which tool would be the best to use. Or give advantages/diadvantages to both...
  11. jessieyull

    Filtering on a group

    ah ah! That works! Thanks, Jessie
  12. jessieyull

    Specifying group order

    We are using v7.0 - I am trying to arrange my groups based on a specific order that the user wants. From the design tab, I right-click on the group (I only have one group header) and select change group. I selected "in specified order" and went to the 'specified order' tab to select...
  13. jessieyull

    Filtering on a group

    I ended up getting this to work as the record selection in the select expert: ({OPPORTUNITIES_V.VALUE_1_YR_PROD} >= 1000000.00 and {OPPORTUNITIES_V.WIN_STATUS} in ["Pending", "Win"]) or {OPPORTUNITIES_V.WIN_STATUS} in ["Cancel", "DesignWin&quot...
  14. jessieyull

    Filtering on a group

    Thanks for your help!
  15. jessieyull

    Filtering on a group

    thanks for the response! I'm needing to filter the records, but just on one group. for instance, if I had... group A record1 200.00 record2 900.00 group B record1 200.00 record2 400.00 group C record1 400.00 record2 800.00 and the formula I need is to only bring back...
  16. jessieyull

    Filtering on a group

    I have a report that is grouping by a win_status field. Each record returned in every group contains a $amount field. I'm wanting to filter just one specific group by $amounts greater than 1 million. Something like... If win_status=Pending and $amount > 1000000

Part and Inventory Search

Back
Top