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 TouchToneTommy 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: jenfromjax
  • Content: Threads
  • Order by date
  1. jenfromjax

    Sort Group based on Percent Formula

    Let me start by saying that I've seen the other threads on this topic and gather that a SQL Expression is required, which gets inserted into details, then a max summary created (thank you lbass), but that is where I am stuck. I've been looking at this all day so please forgive me if I've left...
  2. jenfromjax

    Using Parameter values in calculation?

    I am using CR v10 & SQL 2000 and have been asked to do something in Crystal that I don't know is possible. I am hoping someone can advise me. Scenario: I am reporting on sold deals in our sales db. These deals can contain any number of products, at different prices, at whatever discount % the...
  3. jenfromjax

    Number of Occurrences for Conditional Formatting

    I am using Crystal Reports v10 accessing a SQL Server (v8 I think). SCENARIO: I have a Salesmen Commission Report. The report is grouped 1st by "Region", then by Salesman ("Rep"). This order of grouping is not negotiable unfortunately. Occasionally, a Rep will sell something in more than one...
  4. jenfromjax

    Line chart for details and summary - URGENT

    Hi everyone. I am using Crystal Reports v10. The Sales Dept wants a line chart that shows: Sales Types: New & Add-on Y axis: Millions X axis: Months I had the above in a cross-tab and no problem creating the chart for this. But now they want to include a line for the totals row. So the...
  5. jenfromjax

    Multiple records from same field on one line... kinda

    I apologize if this has been addressed somewhere in this forum, but I haven't had luck searching keywords or FAQs. I have been asked to create a report that will show all our clients & which of our products they subscribe to. And if they do not use our product for a particular category, then...

Part and Inventory Search

Back
Top